ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US E8E1B3A100010000A0000000AA000001Y select null action_, null status_, null message_, null modified_columns_, xxen_util.meaning(x.code_type,'EAM_FAILURE_CODE_TYPE',700) code_type, x.code, x.description, x.effective_end_date, to_char(null) delete_record, x.upload_row from ( select '10' code_type, efc.failure_code code, efc.description, efc.effective_end_date, rownum upload_row from eam_failure_codes efc where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and (:p_code_type is null or :p_code_type='10') union all select '20' code_type, ecc.cause_code, ecc.description, ecc.effective_end_date, rownum upload_row from eam_cause_codes ecc where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and (:p_code_type is null or :p_code_type='20') union all select '30' code_type, erc.resolution_code, erc.description, erc.effective_end_date, rownum upload_row from eam_resolution_codes erc where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and (:p_code_type is null or :p_code_type='30') ) x U A xxen_eam_upload.upload_failure_codes US EAM Failure Codes Upload Create, update, and delete EAM failure codes, cause codes, and resolution codes. Upload Mode =========== Create ------ Opens an empty spreadsheet to define new codes. Create, Update -------------- Downloads existing codes for review and modification, and allows adding new rows. Code Type ========= Determines which of the three code tables is affected: - Failure Code (stored in eam_failure_codes) - Cause Code (stored in eam_cause_codes) - Resolution Code (stored in eam_resolution_codes) Codes are global - not scoped to any operating unit. Fields ====== - Code Type: Required. Failure Code, Cause Code, or Resolution Code. - Code: Required. Unique within its code type. - Description: Optional. - Effective End Date: Optional. Blank to keep the code active; set to reactivate an end-dated code. - Delete Record: Optional. Set to Yes to delete an existing code. Enginatics R12 only Upload 1=1 :p_code_type :p_upload_mode 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 :p_code_type=:p_code_type LOV custom Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='EAM_FAILURE_CODE_TYPE' and flv.view_application_id=700 and flv.security_group_id=0 and flv.enabled_flag='Y' order by flv.lookup_code US Code Type 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 CODE_TYPE LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='EAM_FAILURE_CODE_TYPE' and flv.view_application_id=700 and flv.security_group_id=0 and flv.enabled_flag='Y' order by flv.lookup_code Y 6 CODE Char varchar2 80 Y 7 DESCRIPTION Char varchar2 2000 8 EFFECTIVE_END_DATE Date date 9 DELETE_RECORD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 10 UPLOAD_ROW Number number Y U 1 p_upload_mode in Char U 2 p_code_type in Char CODE_TYPE U 3 p_code in Char CODE U 4 p_description in Char DESCRIPTION U 5 p_effective_end_date in Date EFFECTIVE_END_DATE U 6 p_delete_record in Char DELETE_RECORD U 7 status_ out Char STATUS_CODE_ U 8 message_ out Char MESSAGE_ Error SQL Order By upload_row, code_type, code Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(x.code_type,xu.code_type) code_type, nvl(x.code,xu.code) code, nvl(x.description,xu.description) description, nvl(x.effective_end_date,xu.effective_end_date) effective_end_date, xu.delete_record, xu.upload_row from xxen_eam_failure_codes_9533_u xu, (select '10' code_type_id, xxen_util.meaning('10','EAM_FAILURE_CODE_TYPE',700) code_type, efc.failure_code code, efc.description, efc.effective_end_date from eam_failure_codes efc union all select '20', xxen_util.meaning('20','EAM_FAILURE_CODE_TYPE',700), ecc.cause_code, ecc.description, ecc.effective_end_date from eam_cause_codes ecc union all select '30', xxen_util.meaning('30','EAM_FAILURE_CODE_TYPE',700), erc.resolution_code, erc.description, erc.effective_end_date from eam_resolution_codes erc) x where xu.status_code_=xxen_upload.status_success and case when regexp_like(xu.code_type,'^[0-9]+$') then xu.code_type else xxen_util.lookup_code(xu.code_type,'EAM_FAILURE_CODE_TYPE',700) end=x.code_type_id(+) and xu.code=x.code(+)