DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_TRX_PRE_PROC_OPTIONS_GT

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

2042: end loop;
2043:
2044: --Vchallur
2045: /*Bug 4950953 , 4950901 During Invoice update,complete scenario's need to populate the
2046: ZX_TRX_PRE_PROC_OPTIONS_GT as it used in user procedures.*/
2047:
2048: Begin
2049: select count(*)
2050: into l_count

Line 2051: from ZX_TRX_PRE_PROC_OPTIONS_GT

2047:
2048: Begin
2049: select count(*)
2050: into l_count
2051: from ZX_TRX_PRE_PROC_OPTIONS_GT
2052: where APPLICATION_ID = p_event_class_rec.application_id
2053: AND ENTITY_CODE = p_event_class_rec.entity_code
2054: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
2055: AND TRX_ID = p_event_class_rec.trx_id;

Line 2064: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,

2060: end;
2061:
2062: If(l_count=0) then
2063:
2064: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
2065: APPLICATION_ID,
2066: ENTITY_CODE,
2067: EVENT_CLASS_CODE,
2068: EVNT_CLS_MAPPING_ID,

Line 2192: DELETE FROM ZX_TRX_PRE_PROC_OPTIONS_GT

2188: end if;
2189: End loop;
2190:
2191: IF ZX_API_PUB.G_PUB_SRVC NOT IN ('GLOBAL_DOCUMENT_UPDATE', 'OVERRIDE_TAX') THEN -- Bug 5200373
2192: DELETE FROM ZX_TRX_PRE_PROC_OPTIONS_GT
2193: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
2194: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
2195: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
2196: AND TRX_ID = p_event_class_rec.TRX_ID;