eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_PREPROC_PVT dependencies on PO_TBL_NUMBER

Line 15: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

11:
12: PROCEDURE assign_processing_id;
13:
14: PROCEDURE get_processable_records
15: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
16: p_process_code_tbl IN PO_TBL_VARCHAR30,
17: p_request_id_tbl IN PO_TBL_NUMBER
18: );
19:

Line 17: p_request_id_tbl IN PO_TBL_NUMBER

13:
14: PROCEDURE get_processable_records
15: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
16: p_process_code_tbl IN PO_TBL_VARCHAR30,
17: p_request_id_tbl IN PO_TBL_NUMBER
18: );
19:
20: PROCEDURE validate_interface_values;
21:

Line 163: l_intf_line_id_tbl PO_TBL_NUMBER;

159: d_api_name CONSTANT VARCHAR2(30) := 'update_dependent_line_acc_flag';
160: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
161: d_position NUMBER;
162:
163: l_intf_line_id_tbl PO_TBL_NUMBER;
164: l_price_chg_accept_flag_tbl PO_TBL_VARCHAR1;
165: l_price_break_flag_tbl PO_TBL_VARCHAR1;
166:
167: l_current_flag VARCHAR2(1);

Line 348: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

344: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
345: 1, 2));
346:
347:
348: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
349: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
350: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
351:
352: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 350: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

346:
347:
348: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
349: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
350: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
351:
352: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
353: BEGIN
354: d_position := 0;

Line 352: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

348: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
349: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
350: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
351:
352: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
353: BEGIN
354: d_position := 0;
355:
356: IF (PO_LOG.d_proc) THEN

Line 558: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

554: --OUT:
555: --End of Comments
556: ------------------------------------------------------------------------
557: PROCEDURE get_processable_records
558: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
559: p_process_code_tbl IN PO_TBL_VARCHAR30,
560: p_request_id_tbl IN PO_TBL_NUMBER
561: ) IS
562:

Line 560: p_request_id_tbl IN PO_TBL_NUMBER

556: ------------------------------------------------------------------------
557: PROCEDURE get_processable_records
558: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
559: p_process_code_tbl IN PO_TBL_VARCHAR30,
560: p_request_id_tbl IN PO_TBL_NUMBER
561: ) IS
562:
563: d_api_name CONSTANT VARCHAR2(30) := 'get_processable_records';
564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 567: l_tmp_intf_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

563: d_api_name CONSTANT VARCHAR2(30) := 'get_processable_records';
564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
565: d_position NUMBER;
566:
567: l_tmp_intf_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
568:
569: l_old_request_complete VARCHAR2(1);
570:
571: BEGIN

Line 638: l_reject_tbl PO_TBL_NUMBER;

634: d_api_name CONSTANT VARCHAR2(30) := 'validate_interface_values';
635: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
636: d_position NUMBER;
637:
638: l_reject_tbl PO_TBL_NUMBER;
639: l_action_tbl PO_TBL_VARCHAR25;
640:
641: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
642: BEGIN

Line 738: l_intf_header_id_tbl PO_TBL_NUMBER;

734: d_position NUMBER;
735:
736: l_key NUMBER;
737:
738: l_intf_header_id_tbl PO_TBL_NUMBER;
739: l_vendor_name_tbl PO_TBL_VARCHAR2000;
740: l_vendor_num_tbl PO_TBL_VARCHAR30;
741: l_vendor_id_tbl PO_TBL_NUMBER;
742:

Line 741: l_vendor_id_tbl PO_TBL_NUMBER;

737:
738: l_intf_header_id_tbl PO_TBL_NUMBER;
739: l_vendor_name_tbl PO_TBL_VARCHAR2000;
740: l_vendor_num_tbl PO_TBL_VARCHAR30;
741: l_vendor_id_tbl PO_TBL_NUMBER;
742:
743: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
744:
745: l_column_name VARCHAR2(30);

Line 743: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

739: l_vendor_name_tbl PO_TBL_VARCHAR2000;
740: l_vendor_num_tbl PO_TBL_VARCHAR30;
741: l_vendor_id_tbl PO_TBL_NUMBER;
742:
743: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
744:
745: l_column_name VARCHAR2(30);
746: l_token_value VARCHAR2(200);
747:

Line 868: l_interface_header_id_tbl PO_TBL_NUMBER;

864: d_api_name CONSTANT VARCHAR2(30) := 'verify_action_replace';
865: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
866: d_position NUMBER;
867:
868: l_interface_header_id_tbl PO_TBL_NUMBER;
869: l_vendor_id_tbl PO_TBL_NUMBER;
870: l_start_date_tbl PO_TBL_DATE;
871: l_end_date_tbl PO_TBL_DATE;
872: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;

Line 869: l_vendor_id_tbl PO_TBL_NUMBER;

865: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
866: d_position NUMBER;
867:
868: l_interface_header_id_tbl PO_TBL_NUMBER;
869: l_vendor_id_tbl PO_TBL_NUMBER;
870: l_start_date_tbl PO_TBL_DATE;
871: l_end_date_tbl PO_TBL_DATE;
872: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
873:

Line 874: l_orig_po_header_id_tbl PO_TBL_NUMBER;

870: l_start_date_tbl PO_TBL_DATE;
871: l_end_date_tbl PO_TBL_DATE;
872: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
873:
874: l_orig_po_header_id_tbl PO_TBL_NUMBER;
875: l_orig_closed_code_tbl PO_TBL_VARCHAR25;
876: l_orig_cancel_flag_tbl PO_TBL_VARCHAR1;
877: l_orig_ga_tbl PO_TBL_VARCHAR1;
878:

Line 887: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

883: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
884:
885: l_valid VARCHAR2(1);
886:
887: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
888: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
889: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
890: BEGIN
891: d_position := 0;

Line 888: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

884:
885: l_valid VARCHAR2(1);
886:
887: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
888: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
889: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
890: BEGIN
891: d_position := 0;
892:

Line 889: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

885: l_valid VARCHAR2(1);
886:
887: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
888: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
889: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
890: BEGIN
891: d_position := 0;
892:
893: IF (PO_LOG.d_proc) THEN

Line 1267: l_interface_header_id_tbl PO_TBL_NUMBER;

1263: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
1264: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1265:
1266:
1267: l_interface_header_id_tbl PO_TBL_NUMBER;
1268: l_vendor_id_tbl PO_TBL_NUMBER;
1269: l_start_date_tbl PO_TBL_DATE;
1270: l_end_date_tbl PO_TBL_DATE;
1271: l_po_header_id_tbl PO_TBL_NUMBER;

Line 1268: l_vendor_id_tbl PO_TBL_NUMBER;

1264: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1265:
1266:
1267: l_interface_header_id_tbl PO_TBL_NUMBER;
1268: l_vendor_id_tbl PO_TBL_NUMBER;
1269: l_start_date_tbl PO_TBL_DATE;
1270: l_end_date_tbl PO_TBL_DATE;
1271: l_po_header_id_tbl PO_TBL_NUMBER;
1272: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;

Line 1271: l_po_header_id_tbl PO_TBL_NUMBER;

1267: l_interface_header_id_tbl PO_TBL_NUMBER;
1268: l_vendor_id_tbl PO_TBL_NUMBER;
1269: l_start_date_tbl PO_TBL_DATE;
1270: l_end_date_tbl PO_TBL_DATE;
1271: l_po_header_id_tbl PO_TBL_NUMBER;
1272: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
1273: l_document_num_tbl PO_TBL_VARCHAR25;
1274:
1275: l_message_name FND_NEW_MESSAGES.message_name%TYPE;

Line 1287: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1283:
1284: l_status_rec PO_STATUS_REC_TYPE;
1285: l_return_status VARCHAR2(1);
1286:
1287: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1288: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1289:
1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1291:

Line 1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1288: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1289:
1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1291:
1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1294:
1295: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1296: BEGIN

Line 1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1289:
1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1291:
1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1294:
1295: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1296: BEGIN
1297: d_position := 0;

Line 1295: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

1291:
1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1294:
1295: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1296: BEGIN
1297: d_position := 0;
1298:
1299: IF (PO_LOG.d_proc) THEN

Line 1727: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1723: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1724: d_position NUMBER;
1725:
1726:
1727: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1728: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1729: l_vendor_doc_num_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
1730: BEGIN
1731: d_position := 0;

Line 1728: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

1724: d_position NUMBER;
1725:
1726:
1727: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1728: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1729: l_vendor_doc_num_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
1730: BEGIN
1731: d_position := 0;
1732:

Line 1920: l_intf_line_tbl PO_TBL_NUMBER;

1916: AND PLLI.interface_line_id = PLI.interface_line_id
1917: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
1918:
1919: l_rowid_tbl DBMS_SQL.urowid_table;
1920: l_intf_line_tbl PO_TBL_NUMBER;
1921: l_intf_line_loc_tbl PO_TBL_NUMBER;
1922: BEGIN
1923: d_position := 0;
1924:

Line 1921: l_intf_line_loc_tbl PO_TBL_NUMBER;

1917: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
1918:
1919: l_rowid_tbl DBMS_SQL.urowid_table;
1920: l_intf_line_tbl PO_TBL_NUMBER;
1921: l_intf_line_loc_tbl PO_TBL_NUMBER;
1922: BEGIN
1923: d_position := 0;
1924:
1925: IF (PO_LOG.d_proc) THEN