DBA Data[Home] [Help]

APPS.PO_PDOI_UTL dependencies on PO_PRICE_DIFF_INTERFACE

Line 589: UPDATE po_price_diff_interface

585:
586: IF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID) THEN
587: d_position := 20;
588: FORALL i IN 1..p_id_tbl.COUNT
589: UPDATE po_price_diff_interface
590: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
591: processing_id = -PO_PDOI_PARAMS.g_processing_id
592: WHERE interface_line_id = p_id_tbl(i)
593: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 600: UPDATE po_price_diff_interface

596:
597: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_PRICE_DIFF_INTERFACE_ID) THEN
598: d_position := 30;
599: FORALL i IN 1..p_id_tbl.COUNT
600: UPDATE po_price_diff_interface
601: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
602: processing_id = -PO_PDOI_PARAMS.g_processing_id
603: WHERE price_diff_interface_id = p_id_tbl(i)
604: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1213: UPDATE po_price_diff_interface

1209:
1210: d_position := 40;
1211:
1212: -- reject price diff level records
1213: UPDATE po_price_diff_interface
1214: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1215: processing_id = -PO_PDOI_PARAMS.g_processing_id
1216: WHERE interface_header_id = p_intf_header_id
1217: AND processing_id = PO_PDOI_PARAMS.g_processing_id