DBA Data[Home] [Help]

APPS.OE_HEADER_STATUS_PUB dependencies on OE_GLOBALS

Line 80: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR

76: IF x_result = 'Y' THEN
77: SELECT end_date
78: INTO x_result_date
79: FROM wf_item_activity_statuses wias, wf_process_activities wpa
80: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
81: AND wias.item_key = to_char(p_header_id)
82: AND wias.process_activity = wpa.instance_id
83: AND wpa.activity_name = 'CLOSE_HEADER';
84: ELSE

Line 241: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR

237: IF x_result = 'Y' THEN
238: SELECT end_date
239: INTO x_result_date
240: FROM wf_item_activity_statuses wias, wf_process_activities wpa
241: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
242: AND wias.item_key = to_char(p_header_id)
243: AND wias.process_activity = wpa.instance_id
244: AND wpa.activity_name = 'CLOSE_HEADER';
245: ELSE