DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 2434: -- po_attr_values_tlp_interface table

2430: -- None
2431: --Function:
2432: -- handle the logic to validate and insert records
2433: -- from po_attr_values_interface table and
2434: -- po_attr_values_tlp_interface table
2435: --Parameters:
2436: --IN: None
2437: --IN OUT: None
2438: --OUT: None

Line 2481: -- process all lines in po_attr_values_tlp_interface table

2477: process_attr_values;
2478:
2479: d_position := 20;
2480:
2481: -- process all lines in po_attr_values_tlp_interface table
2482: process_attr_values_tlp;
2483:
2484: d_position := 30;
2485:

Line 2716: -- handle the logic on records from po_attr_values_tlp_interface table

2712: --Modifies:
2713: --Locks:
2714: -- None
2715: --Function:
2716: -- handle the logic on records from po_attr_values_tlp_interface table
2717: --Parameters:
2718: --IN: None
2719: --IN OUT: None
2720: --OUT: None

Line 2841: UPDATE po_attr_values_tlp_interface

2837: d_position := 40;
2838:
2839: -- set status to ACCEPTED for all records
2840: FORALL i IN 1..l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT
2841: UPDATE po_attr_values_tlp_interface
2842: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
2843: WHERE interface_attr_values_tlp_id = l_attr_values_tlp.intf_attr_values_tlp_id_tbl(i)
2844: AND l_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
2845: