DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_TRX_PRE_PROC_OPTIONS_GT

Line 2091: ZX_TRX_PRE_PROC_OPTIONS_GT as it used in user procedures.*/

2087: end loop;
2088:
2089: --Vchallur
2090: /*Bug 4950953 , 4950901 During Invoice update,complete scenario's need to populate the
2091: ZX_TRX_PRE_PROC_OPTIONS_GT as it used in user procedures.*/
2092:
2093: Begin
2094: select count(*)
2095: into l_count

Line 2096: from ZX_TRX_PRE_PROC_OPTIONS_GT

2092:
2093: Begin
2094: select count(*)
2095: into l_count
2096: from ZX_TRX_PRE_PROC_OPTIONS_GT
2097: where APPLICATION_ID = p_event_class_rec.application_id
2098: AND ENTITY_CODE = p_event_class_rec.entity_code
2099: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
2100: AND TRX_ID = p_event_class_rec.trx_id;

Line 2109: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,

2105: end;
2106:
2107: If(l_count=0) then
2108:
2109: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
2110: APPLICATION_ID,
2111: ENTITY_CODE,
2112: EVENT_CLASS_CODE,
2113: EVNT_CLS_MAPPING_ID,

Line 2237: DELETE FROM ZX_TRX_PRE_PROC_OPTIONS_GT

2233: end if;
2234: End loop;
2235:
2236: IF ZX_API_PUB.G_PUB_SRVC NOT IN ('GLOBAL_DOCUMENT_UPDATE', 'OVERRIDE_TAX') THEN -- Bug 5200373
2237: DELETE FROM ZX_TRX_PRE_PROC_OPTIONS_GT
2238: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
2239: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
2240: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
2241: AND TRX_ID = p_event_class_rec.TRX_ID;