APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_TBL_VARCHAR1

Line 468: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 488: x_line_num_unique_tbl := PO_TBL_VARCHAR1();

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

Line 896: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 916: x_shipment_num_unique_tbl := PO_TBL_VARCHAR1();

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

Line 1304: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 1324: x_dist_num_unique_tbl := PO_TBL_VARCHAR1();

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

Line 1672: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 1698: x_price_diff_num_unique_tbl := PO_TBL_VARCHAR1();

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