DBA Data[Home] [Help]

APPS.PO_PDOI_UTL dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 402: UPDATE po_line_locations_interface

398:
399: IF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID) THEN
400: d_position := 20;
401: FORALL i IN 1..p_id_tbl.COUNT
402: UPDATE po_line_locations_interface
403: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
404: processing_id = -PO_PDOI_PARAMS.g_processing_id
405: WHERE interface_line_id = p_id_tbl(i)
406: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 415: UPDATE po_line_locations_interface

411:
412: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_LINE_LOCATION_ID) THEN
413: d_position := 30;
414: FORALL i IN 1..p_id_tbl.COUNT
415: UPDATE po_line_locations_interface
416: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
417: processing_id = -PO_PDOI_PARAMS.g_processing_id
418: WHERE interface_line_location_id = p_id_tbl(i)
419: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1202: UPDATE po_line_locations_interface

1198:
1199: d_position := 30;
1200:
1201: -- reject line location level records
1202: UPDATE po_line_locations_interface
1203: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1204: processing_id = -PO_PDOI_PARAMS.g_processing_id
1205: WHERE interface_header_id = p_intf_header_id
1206: AND processing_id = PO_PDOI_PARAMS.g_processing_id