APPS.DPP_XLA_EVENT_PUB dependencies on DPP_XLA_HEADERS

Line 74: DPP_XLA_HEADERS PSEH,

70: DXE.ENTITY_CODE,
71: DXE.EVENT_CLASS_CODE,
72: DXE.EVENT_TYPE_CODE
73: FROM
74: DPP_XLA_HEADERS PSEH,
75: DPP_TRANSACTION_HEADERS_ALL DTH,
76: hr_operating_units hou,
77: DPP_XLA_EVENT_MAP DXE
78: WHERE NVL(PSEH.PROCESSED_FLAG,'N') IN ('N','E')

Line 136: UPDATE DPP_XLA_HEADERS PSEH

132: fnd_file.put_line(fnd_file.log, 'One or more items in Price Protection transaction ID= '||rec_get_eligible_headers.transaction_header_id
133: ||'and execution detail ID= '|| rec_get_eligible_headers.base_transaction_header_id||' has not been accounted in Oracle costing');
134: retcode:=1;
135:
136: UPDATE DPP_XLA_HEADERS PSEH
137: SET PROCESSED_FLAG='E',
138: ERROR_DESCRIPTION='One or more items in Price Protection transaction ID= '||rec_get_eligible_headers.transaction_header_id
139: ||'and execution detail ID= '|| rec_get_eligible_headers.base_transaction_header_id||' has not been accounted in Oracle costing'
140: WHERE TRANSACTION_HEADER_ID= rec_get_eligible_headers.transaction_header_id

Line 204: UPDATE DPP_XLA_HEADERS PSEH

200: l_event_count:=l_event_count+1;
201: END IF;
202:
203: IF NVL(l_event_id,-1)>0 THEN
204: UPDATE DPP_XLA_HEADERS PSEH
205: SET PROCESSED_FLAG='P',
206: ERROR_DESCRIPTION=NULL
207: WHERE TRANSACTION_HEADER_ID= rec_get_eligible_headers.transaction_header_id
208: AND BASE_TRANSACTION_HEADER_ID=rec_get_eligible_headers.base_transaction_header_id