APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 875: INSERT INTO ZX_REPORT_CODES_ASSOC(

871:
872: -- Code for Reporting Code Association. Bug # 3594759
873: -- Insert the Fiscal Printer Codes into Association table
874:
875: INSERT INTO ZX_REPORT_CODES_ASSOC(
876: REPORTING_CODE_ASSOC_ID,
877: ENTITY_CODE,
878: ENTITY_ID,
879: REPORTING_TYPE_ID,

Line 890: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

886: LAST_UPDATED_BY,
887: LAST_UPDATE_DATE,
888: LAST_UPDATE_LOGIN)
889: (SELECT
890: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
891: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
892: ptp.Party_Tax_Profile_Id, --ENTITY_ID
893: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
894: p_GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE

Line 911: INSERT INTO ZX_REPORT_CODES_ASSOC(

907: reporting_type_code = 'FISCAL PRINTER');
908:
909: -- Insert the CAI Number and Date into Association table
910:
911: INSERT INTO ZX_REPORT_CODES_ASSOC(
912: REPORTING_CODE_ASSOC_ID,
913: ENTITY_CODE,
914: ENTITY_ID,
915: REPORTING_TYPE_ID ,

Line 926: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

922: LAST_UPDATED_BY,
923: LAST_UPDATE_DATE,
924: LAST_UPDATE_LOGIN)
925: (SELECT
926: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
927: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
928: ptp.Party_Tax_Profile_Id, --ENTITY_ID
929: REPORTING_TYPE_ID, --REPORTING_TYPE_ID
930: p_GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE

Line 1201: UPDATE ZX_REPORT_CODES_ASSOC

1197:
1198: -- Code for Reporting Code Association. Bug # 3594759
1199: -- Update the Fiscal Printer Codes into Association table
1200:
1201: UPDATE ZX_REPORT_CODES_ASSOC
1202: SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203: LAST_UPDATED_BY = fnd_global.user_id,
1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

Line 1218: UPDATE ZX_REPORT_CODES_ASSOC

1214:
1215:
1216: -- Update the CAI Number and Date into Association table
1217:
1218: UPDATE ZX_REPORT_CODES_ASSOC
1219: SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220: EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221: LAST_UPDATED_BY = fnd_global.user_id,
1222: LAST_UPDATE_DATE = sysdate,