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 69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,

65: --CLM PDOI Integration Starts
66: PROCEDURE derive_line_num;
67:
68: PROCEDURE default_group_line_id
69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,

66: PROCEDURE derive_line_num;
67:
68: PROCEDURE default_group_line_id
69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
74: );

Line 73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
74: );
75:
76: PROCEDURE validate_line_num_display
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,

Line 77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,

73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
74: );
75:
76: PROCEDURE validate_line_num_display
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,

Line 78: p_intf_line_id_tbl IN PO_TBL_NUMBER,

74: );
75:
76: PROCEDURE validate_line_num_display
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
82: p_po_line_id_tbl IN PO_TBL_NUMBER

Line 82: p_po_line_id_tbl IN PO_TBL_NUMBER

78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
82: p_po_line_id_tbl IN PO_TBL_NUMBER
83: );
84: --CLM PDOI Integration Ends
85:
86: -------------------------------------------------------

Line 211: l_intf_line_id_tbl PO_TBL_NUMBER;

207: d_api_name CONSTANT VARCHAR2(30) := 'update_dependent_line_acc_flag';
208: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
209: d_position NUMBER;
210:
211: l_intf_line_id_tbl PO_TBL_NUMBER;
212: l_price_chg_accept_flag_tbl PO_TBL_VARCHAR1;
213: l_price_break_flag_tbl PO_TBL_VARCHAR1;
214:
215: l_current_flag VARCHAR2(1);

Line 396: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

392: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
393: 1, 2));
394:
395:
396: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
397: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
398: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
399:
400: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 398: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

394:
395:
396: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
397: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
398: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
399:
400: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
401: BEGIN
402: d_position := 0;

Line 400: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

396: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
397: l_process_code_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
398: l_request_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
399:
400: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
401: BEGIN
402: d_position := 0;
403:
404: IF (PO_LOG.d_proc) THEN

Line 606: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

602: --OUT:
603: --End of Comments
604: ------------------------------------------------------------------------
605: PROCEDURE get_processable_records
606: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
607: p_process_code_tbl IN PO_TBL_VARCHAR30,
608: p_request_id_tbl IN PO_TBL_NUMBER
609: ) IS
610:

Line 608: p_request_id_tbl IN PO_TBL_NUMBER

604: ------------------------------------------------------------------------
605: PROCEDURE get_processable_records
606: ( x_intf_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
607: p_process_code_tbl IN PO_TBL_VARCHAR30,
608: p_request_id_tbl IN PO_TBL_NUMBER
609: ) IS
610:
611: d_api_name CONSTANT VARCHAR2(30) := 'get_processable_records';
612: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 615: l_tmp_intf_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

611: d_api_name CONSTANT VARCHAR2(30) := 'get_processable_records';
612: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
613: d_position NUMBER;
614:
615: l_tmp_intf_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
616:
617: l_old_request_complete VARCHAR2(1);
618:
619: BEGIN

Line 686: l_reject_tbl PO_TBL_NUMBER;

682: d_api_name CONSTANT VARCHAR2(30) := 'validate_interface_values';
683: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
684: d_position NUMBER;
685:
686: l_reject_tbl PO_TBL_NUMBER;
687: l_action_tbl PO_TBL_VARCHAR25;
688:
689: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
690: BEGIN

Line 786: l_intf_header_id_tbl PO_TBL_NUMBER;

782: d_position NUMBER;
783:
784: l_key NUMBER;
785:
786: l_intf_header_id_tbl PO_TBL_NUMBER;
787: l_vendor_name_tbl PO_TBL_VARCHAR2000;
788: l_vendor_num_tbl PO_TBL_VARCHAR30;
789: l_vendor_id_tbl PO_TBL_NUMBER;
790: --CLM PDOI Project

Line 789: l_vendor_id_tbl PO_TBL_NUMBER;

785:
786: l_intf_header_id_tbl PO_TBL_NUMBER;
787: l_vendor_name_tbl PO_TBL_VARCHAR2000;
788: l_vendor_num_tbl PO_TBL_VARCHAR30;
789: l_vendor_id_tbl PO_TBL_NUMBER;
790: --CLM PDOI Project
791: l_clm_source_document_disp_tbl PO_TBL_VARCHAR240;
792: l_clm_source_document_id_tbl PO_TBL_NUMBER;
793: l_doc_type_tbl PO_TBL_VARCHAR30;

Line 792: l_clm_source_document_id_tbl PO_TBL_NUMBER;

788: l_vendor_num_tbl PO_TBL_VARCHAR30;
789: l_vendor_id_tbl PO_TBL_NUMBER;
790: --CLM PDOI Project
791: l_clm_source_document_disp_tbl PO_TBL_VARCHAR240;
792: l_clm_source_document_id_tbl PO_TBL_NUMBER;
793: l_doc_type_tbl PO_TBL_VARCHAR30;
794:
795: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
796:

Line 795: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

791: l_clm_source_document_disp_tbl PO_TBL_VARCHAR240;
792: l_clm_source_document_id_tbl PO_TBL_NUMBER;
793: l_doc_type_tbl PO_TBL_VARCHAR30;
794:
795: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
796:
797: l_column_name VARCHAR2(30);
798: l_token_value VARCHAR2(200);
799:

Line 949: l_interface_header_id_tbl PO_TBL_NUMBER;

945: d_api_name CONSTANT VARCHAR2(30) := 'verify_action_replace';
946: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
947: d_position NUMBER;
948:
949: l_interface_header_id_tbl PO_TBL_NUMBER;
950: l_vendor_id_tbl PO_TBL_NUMBER;
951: l_start_date_tbl PO_TBL_DATE;
952: l_end_date_tbl PO_TBL_DATE;
953: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;

Line 950: l_vendor_id_tbl PO_TBL_NUMBER;

946: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
947: d_position NUMBER;
948:
949: l_interface_header_id_tbl PO_TBL_NUMBER;
950: l_vendor_id_tbl PO_TBL_NUMBER;
951: l_start_date_tbl PO_TBL_DATE;
952: l_end_date_tbl PO_TBL_DATE;
953: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
954:

Line 955: l_orig_po_header_id_tbl PO_TBL_NUMBER;

951: l_start_date_tbl PO_TBL_DATE;
952: l_end_date_tbl PO_TBL_DATE;
953: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
954:
955: l_orig_po_header_id_tbl PO_TBL_NUMBER;
956: l_orig_closed_code_tbl PO_TBL_VARCHAR25;
957: l_orig_cancel_flag_tbl PO_TBL_VARCHAR1;
958: l_orig_ga_tbl PO_TBL_VARCHAR1;
959:

Line 968: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

964: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
965:
966: l_valid VARCHAR2(1);
967:
968: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
969: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
970: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
971: BEGIN
972: d_position := 0;

Line 969: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

965:
966: l_valid VARCHAR2(1);
967:
968: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
969: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
970: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
971: BEGIN
972: d_position := 0;
973:

Line 970: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

966: l_valid VARCHAR2(1);
967:
968: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
969: l_final_orig_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
970: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
971: BEGIN
972: d_position := 0;
973:
974: IF (PO_LOG.d_proc) THEN

Line 1349: l_interface_header_id_tbl PO_TBL_NUMBER;

1345: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
1346: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1347:
1348:
1349: l_interface_header_id_tbl PO_TBL_NUMBER;
1350: l_vendor_id_tbl PO_TBL_NUMBER;
1351: l_start_date_tbl PO_TBL_DATE;
1352: l_end_date_tbl PO_TBL_DATE;
1353: l_po_header_id_tbl PO_TBL_NUMBER;

Line 1350: l_vendor_id_tbl PO_TBL_NUMBER;

1346: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1347:
1348:
1349: l_interface_header_id_tbl PO_TBL_NUMBER;
1350: l_vendor_id_tbl PO_TBL_NUMBER;
1351: l_start_date_tbl PO_TBL_DATE;
1352: l_end_date_tbl PO_TBL_DATE;
1353: l_po_header_id_tbl PO_TBL_NUMBER;
1354: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;

Line 1353: l_po_header_id_tbl PO_TBL_NUMBER;

1349: l_interface_header_id_tbl PO_TBL_NUMBER;
1350: l_vendor_id_tbl PO_TBL_NUMBER;
1351: l_start_date_tbl PO_TBL_DATE;
1352: l_end_date_tbl PO_TBL_DATE;
1353: l_po_header_id_tbl PO_TBL_NUMBER;
1354: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
1355: l_document_num_tbl PO_TBL_VARCHAR25;
1356:
1357: l_message_name FND_NEW_MESSAGES.message_name%TYPE;

Line 1369: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1365:
1366: l_status_rec PO_STATUS_REC_TYPE;
1367: l_return_status VARCHAR2(1);
1368:
1369: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:

Line 1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1376:
1377: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1378: BEGIN

Line 1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1376:
1377: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1378: BEGIN
1379: d_position := 0;

Line 1377: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1376:
1377: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1378: BEGIN
1379: d_position := 0;
1380:
1381: IF (PO_LOG.d_proc) THEN

Line 1809: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1805: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1806: d_position NUMBER;
1807:
1808:
1809: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1810: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1811: l_vendor_doc_num_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
1812: BEGIN
1813: d_position := 0;

Line 1810: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

1806: d_position NUMBER;
1807:
1808:
1809: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1810: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1811: l_vendor_doc_num_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
1812: BEGIN
1813: d_position := 0;
1814:

Line 2002: l_intf_line_tbl PO_TBL_NUMBER;

1998: AND PLLI.interface_line_id = PLI.interface_line_id
1999: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
2000:
2001: l_rowid_tbl DBMS_SQL.urowid_table;
2002: l_intf_line_tbl PO_TBL_NUMBER;
2003: l_intf_line_loc_tbl PO_TBL_NUMBER;
2004: -- << PDOI for Complex PO Project: Start >>
2005: l_is_complex_work_style BOOLEAN;
2006: l_is_financing_style BOOLEAN;

Line 2003: l_intf_line_loc_tbl PO_TBL_NUMBER;

1999: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
2000:
2001: l_rowid_tbl DBMS_SQL.urowid_table;
2002: l_intf_line_tbl PO_TBL_NUMBER;
2003: l_intf_line_loc_tbl PO_TBL_NUMBER;
2004: -- << PDOI for Complex PO Project: Start >>
2005: l_is_complex_work_style BOOLEAN;
2006: l_is_financing_style BOOLEAN;
2007: l_style_id NUMBER := 1;

Line 3124: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3120: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_num';
3121: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3122: d_position NUMBER;
3123:
3124: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3121: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3122: d_position NUMBER;
3123:
3124: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3135: -- table used to save the index of the each row
3136: l_num_list DBMS_SQL.NUMBER_TABLE;
3137: -- key of temp table used to identify the derived result

Line 3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3135: -- table used to save the index of the each row
3136: l_num_list DBMS_SQL.NUMBER_TABLE;
3137: -- key of temp table used to identify the derived result
3138: l_key po_session_gt.key%TYPE;

Line 3139: l_index_tbl PO_TBL_NUMBER;

3135: -- table used to save the index of the each row
3136: l_num_list DBMS_SQL.NUMBER_TABLE;
3137: -- key of temp table used to identify the derived result
3138: l_key po_session_gt.key%TYPE;
3139: l_index_tbl PO_TBL_NUMBER;
3140: l_index NUMBER;
3141: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
3142: max_line_num NUMBER;
3143:

Line 3141: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

3137: -- key of temp table used to identify the derived result
3138: l_key po_session_gt.key%TYPE;
3139: l_index_tbl PO_TBL_NUMBER;
3140: l_index NUMBER;
3141: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
3142: max_line_num NUMBER;
3143:
3144:
3145: BEGIN

Line 3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,

3262:
3263:
3264:
3265: PROCEDURE default_group_line_id
3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,

3263:
3264:
3265: PROCEDURE default_group_line_id
3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
3271: )

Line 3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
3271: )
3272: IS
3273:
3274: d_api_name CONSTANT VARCHAR2(30) := 'default_group_line_id';

Line 3277: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3273:
3274: d_api_name CONSTANT VARCHAR2(30) := 'default_group_line_id';
3275: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3276: d_position NUMBER;
3277: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3278: -- table used to save the index of the each row
3279: l_num_list DBMS_SQL.NUMBER_TABLE;
3280: -- key of temp table used to identify the derived result
3281: l_key po_session_gt.key%TYPE;

Line 3282: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3278: -- table used to save the index of the each row
3279: l_num_list DBMS_SQL.NUMBER_TABLE;
3280: -- key of temp table used to identify the derived result
3281: l_key po_session_gt.key%TYPE;
3282: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3283: l_index NUMBER;
3284: BEGIN
3285:
3286: d_position := 0;

Line 3291: p_group_line_id_tbl := PO_TBL_NUMBER();

3287:
3288: IF (PO_LOG.d_proc) THEN
3289: PO_LOG.proc_begin (d_module);
3290: END IF;
3291: p_group_line_id_tbl := PO_TBL_NUMBER();
3292:
3293: -- initialize table containing the row number(index)
3294: PO_PDOI_UTL.generate_ordered_num_list
3295: (

Line 3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,

3360:
3361:
3362:
3363: PROCEDURE validate_line_num_display
3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,

Line 3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,

3361:
3362:
3363: PROCEDURE validate_line_num_display
3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
3369: p_po_line_id_tbl IN PO_TBL_NUMBER

Line 3369: p_po_line_id_tbl IN PO_TBL_NUMBER

3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
3369: p_po_line_id_tbl IN PO_TBL_NUMBER
3370: )
3371: IS
3372:
3373: d_api_name CONSTANT VARCHAR2(30) := 'validate_line_num_display';

Line 3376: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3372:
3373: d_api_name CONSTANT VARCHAR2(30) := 'validate_line_num_display';
3374: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3375: d_position NUMBER;
3376: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3377: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3378: -- table used to save the index of the each row
3379: l_num_list DBMS_SQL.NUMBER_TABLE;
3380: -- key of temp table used to identify the derived result