APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_TBL_VARCHAR1

Line 470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

466: p_po_header_id_tbl IN PO_TBL_NUMBER,
467: p_draft_id_tbl IN PO_TBL_NUMBER,
468: p_intf_line_id_tbl IN PO_TBL_NUMBER,
469: p_line_num_tbl IN PO_TBL_NUMBER,
470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
471: ) IS
472:
473: d_api_name CONSTANT VARCHAR2(30) := 'check_line_num_unique';
474: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 490: x_line_num_unique_tbl := PO_TBL_VARCHAR1();

486: PO_LOG.proc_begin(d_module, 'p_intf_line_id_tbl', p_intf_line_id_tbl);
487: PO_LOG.proc_begin(d_module, 'p_line_num_tbl', p_line_num_tbl);
488: END IF;
489:
490: x_line_num_unique_tbl := PO_TBL_VARCHAR1();
491: x_line_num_unique_tbl.EXTEND(p_line_num_tbl.COUNT);
492:
493: -- pick a new key for temp table
494: l_key := PO_CORE_S.get_session_gt_nextval;

Line 899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

895: p_po_line_id_tbl IN PO_TBL_NUMBER,
896: p_draft_id_tbl IN PO_TBL_NUMBER,
897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
898: p_shipment_num_tbl IN PO_TBL_NUMBER,
899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
900: ) IS
901:
902: d_api_name CONSTANT VARCHAR2(30) := 'check_shipment_num_unique';
903: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 919: x_shipment_num_unique_tbl := PO_TBL_VARCHAR1();

915: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
916: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
917: END IF;
918:
919: x_shipment_num_unique_tbl := PO_TBL_VARCHAR1();
920: x_shipment_num_unique_tbl.EXTEND(p_shipment_num_tbl.COUNT);
921:
922: -- pick a new key for temp table
923: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1304: p_draft_id_tbl IN PO_TBL_NUMBER,
1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
1306: p_dist_num_tbl IN PO_TBL_NUMBER,
1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1308: ) IS
1309:
1310: d_api_name CONSTANT VARCHAR2(30) := 'check_dist_num_unique';
1311: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1327: x_dist_num_unique_tbl := PO_TBL_VARCHAR1();

1323: PO_LOG.proc_begin(d_module, 'p_intf_dist_id_tbl', p_intf_dist_id_tbl);
1324: PO_LOG.proc_begin(d_module, 'p_dist_num_tbl', p_dist_num_tbl);
1325: END IF;
1326:
1327: x_dist_num_unique_tbl := PO_TBL_VARCHAR1();
1328: x_dist_num_unique_tbl.EXTEND(p_dist_num_tbl.COUNT);
1329:
1330: -- pick a new key from temp table
1331: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

1671: p_entity_id_tbl IN PO_TBL_NUMBER,
1672: p_draft_id_tbl IN PO_TBL_NUMBER,
1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,
1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1676: ) IS
1677:
1678: d_api_name CONSTANT VARCHAR2(30) := 'check_price_diff_num_unique';
1679: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1701: x_price_diff_num_unique_tbl := PO_TBL_VARCHAR1();

1697: p_intf_price_diff_id_tbl);
1698: PO_LOG.proc_begin(d_module, 'p_price_diff_num_tbl', p_price_diff_num_tbl);
1699: END IF;
1700:
1701: x_price_diff_num_unique_tbl := PO_TBL_VARCHAR1();
1702: x_price_diff_num_unique_tbl.EXTEND(p_price_diff_num_tbl.COUNT);
1703:
1704: -- pick a new key from temp table
1705: l_key := PO_CORE_S.get_session_gt_nextval;