DBA Data[Home] [Help]

APPS.PO_PDOI_UTL dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 767: UPDATE po_attr_values_tlp_interface

763:
764: IF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID) THEN
765: d_position := 20;
766: FORALL i IN 1..p_id_tbl.COUNT
767: UPDATE po_attr_values_tlp_interface
768: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
769: processing_id = -PO_PDOI_PARAMS.g_processing_id
770: WHERE interface_line_id = p_id_tbl(i)
771: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 779: UPDATE po_attr_values_tlp_interface

775: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_ATTR_VALUES_TLP_ID) THEN
776: d_position := 30;
777:
778: FORALL i IN 1..p_id_tbl.COUNT
779: UPDATE po_attr_values_tlp_interface
780: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
781: processing_id = -PO_PDOI_PARAMS.g_processing_id
782: WHERE interface_attr_values_tlp_id = p_id_tbl(i)
783: AND processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1233: UPDATE po_attr_values_tlp_interface

1229: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1230: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;
1231:
1232: d_position := 60;
1233: UPDATE po_attr_values_tlp_interface
1234: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1235: processing_id = -PO_PDOI_PARAMS.g_processing_id
1236: WHERE interface_header_id = p_intf_header_id
1237: AND processing_id = PO_PDOI_PARAMS.g_processing_id