5168: event_class_code,
5169: trx_id
5170: )
5171: select
5172: PO_CONSTANTS_SV.APPLICATION_ID,
5173: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5174: is pased when the tax lines are created. Same should be passed when they are deleted. */
5175: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5176: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5171: select
5172: PO_CONSTANTS_SV.APPLICATION_ID,
5173: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5174: is pased when the tax lines are created. Same should be passed when they are deleted. */
5175: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5176: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5177: l_po_header_id_tbl(i)
5178: from dual
5179: where l_type_lookup_code_tbl(i) IN ('STANDARD', 'PLANNED');
5172: PO_CONSTANTS_SV.APPLICATION_ID,
5173: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5174: is pased when the tax lines are created. Same should be passed when they are deleted. */
5175: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5176: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5177: l_po_header_id_tbl(i)
5178: from dual
5179: where l_type_lookup_code_tbl(i) IN ('STANDARD', 'PLANNED');
5180:
5185: event_class_code,
5186: trx_id
5187: )
5188: select
5189: PO_CONSTANTS_SV.APPLICATION_ID,
5190: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5191: is pased when the tax lines are created. Same should be passed when they are deleted. */
5192: PO_CONSTANTS_SV.REL_ENTITY_CODE,
5193: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
5188: select
5189: PO_CONSTANTS_SV.APPLICATION_ID,
5190: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5191: is pased when the tax lines are created. Same should be passed when they are deleted. */
5192: PO_CONSTANTS_SV.REL_ENTITY_CODE,
5193: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
5194: l_po_release_id_tbl(i)
5195: from dual;
5196:
5189: PO_CONSTANTS_SV.APPLICATION_ID,
5190: /* Bug 14004400: Applicaton id being passed to EB Tax was responsibility id rather than 201 which
5191: is pased when the tax lines are created. Same should be passed when they are deleted. */
5192: PO_CONSTANTS_SV.REL_ENTITY_CODE,
5193: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
5194: l_po_release_id_tbl(i)
5195: from dual;
5196:
5197: