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_RCO_VALIDATION_PVT dependencies on PO_TBL_NUMBER

Line 3636: l_err_line_id_tbl po_tbl_number;

3632: l_dummy NUMBER;
3633: y NUMBER := 1;
3634: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3635: l_cancel_result VARCHAR2(1);
3636: l_err_line_id_tbl po_tbl_number;
3637: l_err_line_num_tbl po_tbl_number;
3638: l_err_dist_id_tbl po_tbl_number;
3639: l_err_dist_num_tbl po_tbl_number;
3640: l_err_error_attr_tbl po_tbl_varchar30;

Line 3637: l_err_line_num_tbl po_tbl_number;

3633: y NUMBER := 1;
3634: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3635: l_cancel_result VARCHAR2(1);
3636: l_err_line_id_tbl po_tbl_number;
3637: l_err_line_num_tbl po_tbl_number;
3638: l_err_dist_id_tbl po_tbl_number;
3639: l_err_dist_num_tbl po_tbl_number;
3640: l_err_error_attr_tbl po_tbl_varchar30;
3641: l_err_msg_count_tbl po_tbl_number;

Line 3638: l_err_dist_id_tbl po_tbl_number;

3634: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3635: l_cancel_result VARCHAR2(1);
3636: l_err_line_id_tbl po_tbl_number;
3637: l_err_line_num_tbl po_tbl_number;
3638: l_err_dist_id_tbl po_tbl_number;
3639: l_err_dist_num_tbl po_tbl_number;
3640: l_err_error_attr_tbl po_tbl_varchar30;
3641: l_err_msg_count_tbl po_tbl_number;
3642: l_err_msg_data_tbl po_tbl_varchar2000;

Line 3639: l_err_dist_num_tbl po_tbl_number;

3635: l_cancel_result VARCHAR2(1);
3636: l_err_line_id_tbl po_tbl_number;
3637: l_err_line_num_tbl po_tbl_number;
3638: l_err_dist_id_tbl po_tbl_number;
3639: l_err_dist_num_tbl po_tbl_number;
3640: l_err_error_attr_tbl po_tbl_varchar30;
3641: l_err_msg_count_tbl po_tbl_number;
3642: l_err_msg_data_tbl po_tbl_varchar2000;
3643: l_irc_status VARCHAR2(1);

Line 3641: l_err_msg_count_tbl po_tbl_number;

3637: l_err_line_num_tbl po_tbl_number;
3638: l_err_dist_id_tbl po_tbl_number;
3639: l_err_dist_num_tbl po_tbl_number;
3640: l_err_error_attr_tbl po_tbl_varchar30;
3641: l_err_msg_count_tbl po_tbl_number;
3642: l_err_msg_data_tbl po_tbl_varchar2000;
3643: l_irc_status VARCHAR2(1);
3644: l_irc_err_msg VARCHAR2(2000);
3645: l_catch_exception EXCEPTION;

Line 3767: l_err_line_id_tbl := po_tbl_number();

3763:
3764:
3765: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3766: --Initialize the Error Table
3767: l_err_line_id_tbl := po_tbl_number();
3768: l_err_line_num_tbl := po_tbl_number();
3769: l_err_dist_id_tbl := po_tbl_number();
3770: l_err_dist_num_tbl := po_tbl_number();
3771: l_err_error_attr_tbl := po_tbl_varchar30();

Line 3768: l_err_line_num_tbl := po_tbl_number();

3764:
3765: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3766: --Initialize the Error Table
3767: l_err_line_id_tbl := po_tbl_number();
3768: l_err_line_num_tbl := po_tbl_number();
3769: l_err_dist_id_tbl := po_tbl_number();
3770: l_err_dist_num_tbl := po_tbl_number();
3771: l_err_error_attr_tbl := po_tbl_varchar30();
3772: l_err_msg_count_tbl := po_tbl_number();

Line 3769: l_err_dist_id_tbl := po_tbl_number();

3765: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3766: --Initialize the Error Table
3767: l_err_line_id_tbl := po_tbl_number();
3768: l_err_line_num_tbl := po_tbl_number();
3769: l_err_dist_id_tbl := po_tbl_number();
3770: l_err_dist_num_tbl := po_tbl_number();
3771: l_err_error_attr_tbl := po_tbl_varchar30();
3772: l_err_msg_count_tbl := po_tbl_number();
3773: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 3770: l_err_dist_num_tbl := po_tbl_number();

3766: --Initialize the Error Table
3767: l_err_line_id_tbl := po_tbl_number();
3768: l_err_line_num_tbl := po_tbl_number();
3769: l_err_dist_id_tbl := po_tbl_number();
3770: l_err_dist_num_tbl := po_tbl_number();
3771: l_err_error_attr_tbl := po_tbl_varchar30();
3772: l_err_msg_count_tbl := po_tbl_number();
3773: l_err_msg_data_tbl := po_tbl_varchar2000();
3774: x_errtable := po_req_change_err_table(

Line 3772: l_err_msg_count_tbl := po_tbl_number();

3768: l_err_line_num_tbl := po_tbl_number();
3769: l_err_dist_id_tbl := po_tbl_number();
3770: l_err_dist_num_tbl := po_tbl_number();
3771: l_err_error_attr_tbl := po_tbl_varchar30();
3772: l_err_msg_count_tbl := po_tbl_number();
3773: l_err_msg_data_tbl := po_tbl_varchar2000();
3774: x_errtable := po_req_change_err_table(
3775: l_err_line_id_tbl,
3776: l_err_line_num_tbl,

Line 4093: l_err_line_id_tbl po_tbl_number;

4089: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
4090: l_po_to_req_rate NUMBER;
4091:
4092: l_po_return_code VARCHAR2(100) := '';
4093: l_err_line_id_tbl po_tbl_number;
4094: l_err_line_num_tbl po_tbl_number;
4095: l_err_dist_id_tbl po_tbl_number;
4096: l_err_dist_num_tbl po_tbl_number;
4097: l_err_error_attr_tbl po_tbl_varchar30;

Line 4094: l_err_line_num_tbl po_tbl_number;

4090: l_po_to_req_rate NUMBER;
4091:
4092: l_po_return_code VARCHAR2(100) := '';
4093: l_err_line_id_tbl po_tbl_number;
4094: l_err_line_num_tbl po_tbl_number;
4095: l_err_dist_id_tbl po_tbl_number;
4096: l_err_dist_num_tbl po_tbl_number;
4097: l_err_error_attr_tbl po_tbl_varchar30;
4098: l_err_msg_count_tbl po_tbl_number;

Line 4095: l_err_dist_id_tbl po_tbl_number;

4091:
4092: l_po_return_code VARCHAR2(100) := '';
4093: l_err_line_id_tbl po_tbl_number;
4094: l_err_line_num_tbl po_tbl_number;
4095: l_err_dist_id_tbl po_tbl_number;
4096: l_err_dist_num_tbl po_tbl_number;
4097: l_err_error_attr_tbl po_tbl_varchar30;
4098: l_err_msg_count_tbl po_tbl_number;
4099: l_err_msg_data_tbl po_tbl_varchar2000;

Line 4096: l_err_dist_num_tbl po_tbl_number;

4092: l_po_return_code VARCHAR2(100) := '';
4093: l_err_line_id_tbl po_tbl_number;
4094: l_err_line_num_tbl po_tbl_number;
4095: l_err_dist_id_tbl po_tbl_number;
4096: l_err_dist_num_tbl po_tbl_number;
4097: l_err_error_attr_tbl po_tbl_varchar30;
4098: l_err_msg_count_tbl po_tbl_number;
4099: l_err_msg_data_tbl po_tbl_varchar2000;
4100: l_wf_status VARCHAR2(1);

Line 4098: l_err_msg_count_tbl po_tbl_number;

4094: l_err_line_num_tbl po_tbl_number;
4095: l_err_dist_id_tbl po_tbl_number;
4096: l_err_dist_num_tbl po_tbl_number;
4097: l_err_error_attr_tbl po_tbl_varchar30;
4098: l_err_msg_count_tbl po_tbl_number;
4099: l_err_msg_data_tbl po_tbl_varchar2000;
4100: l_wf_status VARCHAR2(1);
4101: l_distribution_id_tbl po_tbl_number;
4102:

Line 4101: l_distribution_id_tbl po_tbl_number;

4097: l_err_error_attr_tbl po_tbl_varchar30;
4098: l_err_msg_count_tbl po_tbl_number;
4099: l_err_msg_data_tbl po_tbl_varchar2000;
4100: l_wf_status VARCHAR2(1);
4101: l_distribution_id_tbl po_tbl_number;
4102:
4103: CURSOR l_changes_csr(grp_id NUMBER) IS
4104: SELECT
4105: document_header_id,

Line 4284: l_distribution_id_tbl := po_tbl_number();

4280:
4281: IF (l_req_num IS NOT NULL) THEN
4282:
4283: -- initialize distributions list table
4284: l_distribution_id_tbl := po_tbl_number();
4285:
4286: -- insert NEW/OLD records of standard po distributions into PO_ENCUMBRANCE_GT
4287: OPEN l_changed_po_dists_csr(p_group_id);
4288:

Line 4555: l_err_line_id_tbl := po_tbl_number();

4551:
4552: -- populate x_errTable (output PLSQL table) with the corresponding
4553: -- funds check error messages.
4554:
4555: l_err_line_id_tbl := po_tbl_number();
4556: l_err_line_num_tbl := po_tbl_number();
4557: l_err_dist_id_tbl := po_tbl_number();
4558: l_err_dist_num_tbl := po_tbl_number();
4559: l_err_error_attr_tbl := po_tbl_varchar30();

Line 4556: l_err_line_num_tbl := po_tbl_number();

4552: -- populate x_errTable (output PLSQL table) with the corresponding
4553: -- funds check error messages.
4554:
4555: l_err_line_id_tbl := po_tbl_number();
4556: l_err_line_num_tbl := po_tbl_number();
4557: l_err_dist_id_tbl := po_tbl_number();
4558: l_err_dist_num_tbl := po_tbl_number();
4559: l_err_error_attr_tbl := po_tbl_varchar30();
4560: l_err_msg_count_tbl := po_tbl_number();

Line 4557: l_err_dist_id_tbl := po_tbl_number();

4553: -- funds check error messages.
4554:
4555: l_err_line_id_tbl := po_tbl_number();
4556: l_err_line_num_tbl := po_tbl_number();
4557: l_err_dist_id_tbl := po_tbl_number();
4558: l_err_dist_num_tbl := po_tbl_number();
4559: l_err_error_attr_tbl := po_tbl_varchar30();
4560: l_err_msg_count_tbl := po_tbl_number();
4561: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 4558: l_err_dist_num_tbl := po_tbl_number();

4554:
4555: l_err_line_id_tbl := po_tbl_number();
4556: l_err_line_num_tbl := po_tbl_number();
4557: l_err_dist_id_tbl := po_tbl_number();
4558: l_err_dist_num_tbl := po_tbl_number();
4559: l_err_error_attr_tbl := po_tbl_varchar30();
4560: l_err_msg_count_tbl := po_tbl_number();
4561: l_err_msg_data_tbl := po_tbl_varchar2000();
4562:

Line 4560: l_err_msg_count_tbl := po_tbl_number();

4556: l_err_line_num_tbl := po_tbl_number();
4557: l_err_dist_id_tbl := po_tbl_number();
4558: l_err_dist_num_tbl := po_tbl_number();
4559: l_err_error_attr_tbl := po_tbl_varchar30();
4560: l_err_msg_count_tbl := po_tbl_number();
4561: l_err_msg_data_tbl := po_tbl_varchar2000();
4562:
4563: x_errtable := po_req_change_err_table(
4564: l_err_line_id_tbl,

Line 4640: l_err_line_id_tbl := po_tbl_number();

4636: i := i + 1;
4637: END LOOP;
4638: CLOSE l_changes_csr;
4639: x_retmsg := 'SMRCH006';
4640: l_err_line_id_tbl := po_tbl_number();
4641: l_err_line_num_tbl := po_tbl_number();
4642: l_err_dist_id_tbl := po_tbl_number();
4643: l_err_dist_num_tbl := po_tbl_number();
4644: l_err_error_attr_tbl := po_tbl_varchar30();

Line 4641: l_err_line_num_tbl := po_tbl_number();

4637: END LOOP;
4638: CLOSE l_changes_csr;
4639: x_retmsg := 'SMRCH006';
4640: l_err_line_id_tbl := po_tbl_number();
4641: l_err_line_num_tbl := po_tbl_number();
4642: l_err_dist_id_tbl := po_tbl_number();
4643: l_err_dist_num_tbl := po_tbl_number();
4644: l_err_error_attr_tbl := po_tbl_varchar30();
4645: l_err_msg_count_tbl := po_tbl_number();

Line 4642: l_err_dist_id_tbl := po_tbl_number();

4638: CLOSE l_changes_csr;
4639: x_retmsg := 'SMRCH006';
4640: l_err_line_id_tbl := po_tbl_number();
4641: l_err_line_num_tbl := po_tbl_number();
4642: l_err_dist_id_tbl := po_tbl_number();
4643: l_err_dist_num_tbl := po_tbl_number();
4644: l_err_error_attr_tbl := po_tbl_varchar30();
4645: l_err_msg_count_tbl := po_tbl_number();
4646: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 4643: l_err_dist_num_tbl := po_tbl_number();

4639: x_retmsg := 'SMRCH006';
4640: l_err_line_id_tbl := po_tbl_number();
4641: l_err_line_num_tbl := po_tbl_number();
4642: l_err_dist_id_tbl := po_tbl_number();
4643: l_err_dist_num_tbl := po_tbl_number();
4644: l_err_error_attr_tbl := po_tbl_varchar30();
4645: l_err_msg_count_tbl := po_tbl_number();
4646: l_err_msg_data_tbl := po_tbl_varchar2000();
4647:

Line 4645: l_err_msg_count_tbl := po_tbl_number();

4641: l_err_line_num_tbl := po_tbl_number();
4642: l_err_dist_id_tbl := po_tbl_number();
4643: l_err_dist_num_tbl := po_tbl_number();
4644: l_err_error_attr_tbl := po_tbl_varchar30();
4645: l_err_msg_count_tbl := po_tbl_number();
4646: l_err_msg_data_tbl := po_tbl_varchar2000();
4647:
4648: x_errtable := po_req_change_err_table(
4649: l_err_line_id_tbl,

Line 4740: l_canerr_line_id_tbl po_tbl_number;

4736: l_api_name VARCHAR2(50) := 'Submit_ReqCancel';
4737: l_line_id NUMBER;
4738: l_result VARCHAR2(1);
4739: i NUMBER := 1;
4740: l_canerr_line_id_tbl po_tbl_number;
4741: l_canerr_line_num_tbl po_tbl_number;
4742: l_canerr_dist_id_tbl po_tbl_number;
4743: l_canerr_dist_num_tbl po_tbl_number;
4744: l_canerr_error_attr_tbl po_tbl_varchar30;

Line 4741: l_canerr_line_num_tbl po_tbl_number;

4737: l_line_id NUMBER;
4738: l_result VARCHAR2(1);
4739: i NUMBER := 1;
4740: l_canerr_line_id_tbl po_tbl_number;
4741: l_canerr_line_num_tbl po_tbl_number;
4742: l_canerr_dist_id_tbl po_tbl_number;
4743: l_canerr_dist_num_tbl po_tbl_number;
4744: l_canerr_error_attr_tbl po_tbl_varchar30;
4745: l_canerr_msg_count_tbl po_tbl_number;

Line 4742: l_canerr_dist_id_tbl po_tbl_number;

4738: l_result VARCHAR2(1);
4739: i NUMBER := 1;
4740: l_canerr_line_id_tbl po_tbl_number;
4741: l_canerr_line_num_tbl po_tbl_number;
4742: l_canerr_dist_id_tbl po_tbl_number;
4743: l_canerr_dist_num_tbl po_tbl_number;
4744: l_canerr_error_attr_tbl po_tbl_varchar30;
4745: l_canerr_msg_count_tbl po_tbl_number;
4746: l_canerr_msg_data_tbl po_tbl_varchar2000;

Line 4743: l_canerr_dist_num_tbl po_tbl_number;

4739: i NUMBER := 1;
4740: l_canerr_line_id_tbl po_tbl_number;
4741: l_canerr_line_num_tbl po_tbl_number;
4742: l_canerr_dist_id_tbl po_tbl_number;
4743: l_canerr_dist_num_tbl po_tbl_number;
4744: l_canerr_error_attr_tbl po_tbl_varchar30;
4745: l_canerr_msg_count_tbl po_tbl_number;
4746: l_canerr_msg_data_tbl po_tbl_varchar2000;
4747: l_line_location_id NUMBER;

Line 4745: l_canerr_msg_count_tbl po_tbl_number;

4741: l_canerr_line_num_tbl po_tbl_number;
4742: l_canerr_dist_id_tbl po_tbl_number;
4743: l_canerr_dist_num_tbl po_tbl_number;
4744: l_canerr_error_attr_tbl po_tbl_varchar30;
4745: l_canerr_msg_count_tbl po_tbl_number;
4746: l_canerr_msg_data_tbl po_tbl_varchar2000;
4747: l_line_location_id NUMBER;
4748: l_chn_req_id NUMBER;
4749: l_req_hdr_id NUMBER;

Line 4767: l_canerr_line_id_tbl := po_tbl_number();

4763: AND pcr.document_line_id = prla.requisition_line_id;
4764: BEGIN
4765:
4766:
4767: l_canerr_line_id_tbl := po_tbl_number();
4768: l_canerr_line_num_tbl := po_tbl_number();
4769: l_canerr_dist_id_tbl := po_tbl_number();
4770: l_canerr_dist_num_tbl := po_tbl_number();
4771: l_canerr_error_attr_tbl := po_tbl_varchar30();

Line 4768: l_canerr_line_num_tbl := po_tbl_number();

4764: BEGIN
4765:
4766:
4767: l_canerr_line_id_tbl := po_tbl_number();
4768: l_canerr_line_num_tbl := po_tbl_number();
4769: l_canerr_dist_id_tbl := po_tbl_number();
4770: l_canerr_dist_num_tbl := po_tbl_number();
4771: l_canerr_error_attr_tbl := po_tbl_varchar30();
4772: l_canerr_msg_count_tbl := po_tbl_number();

Line 4769: l_canerr_dist_id_tbl := po_tbl_number();

4765:
4766:
4767: l_canerr_line_id_tbl := po_tbl_number();
4768: l_canerr_line_num_tbl := po_tbl_number();
4769: l_canerr_dist_id_tbl := po_tbl_number();
4770: l_canerr_dist_num_tbl := po_tbl_number();
4771: l_canerr_error_attr_tbl := po_tbl_varchar30();
4772: l_canerr_msg_count_tbl := po_tbl_number();
4773: l_canerr_msg_data_tbl := po_tbl_varchar2000();

Line 4770: l_canerr_dist_num_tbl := po_tbl_number();

4766:
4767: l_canerr_line_id_tbl := po_tbl_number();
4768: l_canerr_line_num_tbl := po_tbl_number();
4769: l_canerr_dist_id_tbl := po_tbl_number();
4770: l_canerr_dist_num_tbl := po_tbl_number();
4771: l_canerr_error_attr_tbl := po_tbl_varchar30();
4772: l_canerr_msg_count_tbl := po_tbl_number();
4773: l_canerr_msg_data_tbl := po_tbl_varchar2000();
4774:

Line 4772: l_canerr_msg_count_tbl := po_tbl_number();

4768: l_canerr_line_num_tbl := po_tbl_number();
4769: l_canerr_dist_id_tbl := po_tbl_number();
4770: l_canerr_dist_num_tbl := po_tbl_number();
4771: l_canerr_error_attr_tbl := po_tbl_varchar30();
4772: l_canerr_msg_count_tbl := po_tbl_number();
4773: l_canerr_msg_data_tbl := po_tbl_varchar2000();
4774:
4775: p_errtable := po_req_change_err_table(
4776: l_canerr_line_id_tbl ,

Line 5428: l_err_line_id_tbl po_tbl_number;

5424: l_dummy NUMBER;
5425: y NUMBER := 1;
5426: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5427: l_cancel_result VARCHAR2(1);
5428: l_err_line_id_tbl po_tbl_number;
5429: l_err_line_num_tbl po_tbl_number;
5430: l_err_dist_id_tbl po_tbl_number;
5431: l_err_dist_num_tbl po_tbl_number;
5432: l_err_error_attr_tbl po_tbl_varchar30;

Line 5429: l_err_line_num_tbl po_tbl_number;

5425: y NUMBER := 1;
5426: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5427: l_cancel_result VARCHAR2(1);
5428: l_err_line_id_tbl po_tbl_number;
5429: l_err_line_num_tbl po_tbl_number;
5430: l_err_dist_id_tbl po_tbl_number;
5431: l_err_dist_num_tbl po_tbl_number;
5432: l_err_error_attr_tbl po_tbl_varchar30;
5433: l_err_msg_count_tbl po_tbl_number;

Line 5430: l_err_dist_id_tbl po_tbl_number;

5426: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5427: l_cancel_result VARCHAR2(1);
5428: l_err_line_id_tbl po_tbl_number;
5429: l_err_line_num_tbl po_tbl_number;
5430: l_err_dist_id_tbl po_tbl_number;
5431: l_err_dist_num_tbl po_tbl_number;
5432: l_err_error_attr_tbl po_tbl_varchar30;
5433: l_err_msg_count_tbl po_tbl_number;
5434: l_err_msg_data_tbl po_tbl_varchar2000;

Line 5431: l_err_dist_num_tbl po_tbl_number;

5427: l_cancel_result VARCHAR2(1);
5428: l_err_line_id_tbl po_tbl_number;
5429: l_err_line_num_tbl po_tbl_number;
5430: l_err_dist_id_tbl po_tbl_number;
5431: l_err_dist_num_tbl po_tbl_number;
5432: l_err_error_attr_tbl po_tbl_varchar30;
5433: l_err_msg_count_tbl po_tbl_number;
5434: l_err_msg_data_tbl po_tbl_varchar2000;
5435: l_irc_status VARCHAR2(1);

Line 5433: l_err_msg_count_tbl po_tbl_number;

5429: l_err_line_num_tbl po_tbl_number;
5430: l_err_dist_id_tbl po_tbl_number;
5431: l_err_dist_num_tbl po_tbl_number;
5432: l_err_error_attr_tbl po_tbl_varchar30;
5433: l_err_msg_count_tbl po_tbl_number;
5434: l_err_msg_data_tbl po_tbl_varchar2000;
5435: l_irc_status VARCHAR2(1);
5436: l_irc_err_msg VARCHAR2(2000);
5437: l_catch_exception EXCEPTION;

Line 5582: l_err_line_id_tbl := po_tbl_number();

5578:
5579:
5580: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5581: --Initialize the Error Table
5582: l_err_line_id_tbl := po_tbl_number();
5583: l_err_line_num_tbl := po_tbl_number();
5584: l_err_dist_id_tbl := po_tbl_number();
5585: l_err_dist_num_tbl := po_tbl_number();
5586: l_err_error_attr_tbl := po_tbl_varchar30();

Line 5583: l_err_line_num_tbl := po_tbl_number();

5579:
5580: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5581: --Initialize the Error Table
5582: l_err_line_id_tbl := po_tbl_number();
5583: l_err_line_num_tbl := po_tbl_number();
5584: l_err_dist_id_tbl := po_tbl_number();
5585: l_err_dist_num_tbl := po_tbl_number();
5586: l_err_error_attr_tbl := po_tbl_varchar30();
5587: l_err_msg_count_tbl := po_tbl_number();

Line 5584: l_err_dist_id_tbl := po_tbl_number();

5580: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5581: --Initialize the Error Table
5582: l_err_line_id_tbl := po_tbl_number();
5583: l_err_line_num_tbl := po_tbl_number();
5584: l_err_dist_id_tbl := po_tbl_number();
5585: l_err_dist_num_tbl := po_tbl_number();
5586: l_err_error_attr_tbl := po_tbl_varchar30();
5587: l_err_msg_count_tbl := po_tbl_number();
5588: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 5585: l_err_dist_num_tbl := po_tbl_number();

5581: --Initialize the Error Table
5582: l_err_line_id_tbl := po_tbl_number();
5583: l_err_line_num_tbl := po_tbl_number();
5584: l_err_dist_id_tbl := po_tbl_number();
5585: l_err_dist_num_tbl := po_tbl_number();
5586: l_err_error_attr_tbl := po_tbl_varchar30();
5587: l_err_msg_count_tbl := po_tbl_number();
5588: l_err_msg_data_tbl := po_tbl_varchar2000();
5589: x_errtable := po_req_change_err_table(

Line 5587: l_err_msg_count_tbl := po_tbl_number();

5583: l_err_line_num_tbl := po_tbl_number();
5584: l_err_dist_id_tbl := po_tbl_number();
5585: l_err_dist_num_tbl := po_tbl_number();
5586: l_err_error_attr_tbl := po_tbl_varchar30();
5587: l_err_msg_count_tbl := po_tbl_number();
5588: l_err_msg_data_tbl := po_tbl_varchar2000();
5589: x_errtable := po_req_change_err_table(
5590: l_err_line_id_tbl,
5591: l_err_line_num_tbl,

Line 5683: l_canerr_line_id_tbl po_tbl_number;

5679: l_line_id NUMBER;
5680: l_result VARCHAR2(1);
5681: l_progress VARCHAR2(3):='000';
5682: i NUMBER := 1;
5683: l_canerr_line_id_tbl po_tbl_number;
5684: l_canerr_line_num_tbl po_tbl_number;
5685: l_canerr_dist_id_tbl po_tbl_number;
5686: l_canerr_dist_num_tbl po_tbl_number;
5687: l_canerr_error_attr_tbl po_tbl_varchar30;

Line 5684: l_canerr_line_num_tbl po_tbl_number;

5680: l_result VARCHAR2(1);
5681: l_progress VARCHAR2(3):='000';
5682: i NUMBER := 1;
5683: l_canerr_line_id_tbl po_tbl_number;
5684: l_canerr_line_num_tbl po_tbl_number;
5685: l_canerr_dist_id_tbl po_tbl_number;
5686: l_canerr_dist_num_tbl po_tbl_number;
5687: l_canerr_error_attr_tbl po_tbl_varchar30;
5688: l_canerr_msg_count_tbl po_tbl_number;

Line 5685: l_canerr_dist_id_tbl po_tbl_number;

5681: l_progress VARCHAR2(3):='000';
5682: i NUMBER := 1;
5683: l_canerr_line_id_tbl po_tbl_number;
5684: l_canerr_line_num_tbl po_tbl_number;
5685: l_canerr_dist_id_tbl po_tbl_number;
5686: l_canerr_dist_num_tbl po_tbl_number;
5687: l_canerr_error_attr_tbl po_tbl_varchar30;
5688: l_canerr_msg_count_tbl po_tbl_number;
5689: l_canerr_msg_data_tbl po_tbl_varchar2000;

Line 5686: l_canerr_dist_num_tbl po_tbl_number;

5682: i NUMBER := 1;
5683: l_canerr_line_id_tbl po_tbl_number;
5684: l_canerr_line_num_tbl po_tbl_number;
5685: l_canerr_dist_id_tbl po_tbl_number;
5686: l_canerr_dist_num_tbl po_tbl_number;
5687: l_canerr_error_attr_tbl po_tbl_varchar30;
5688: l_canerr_msg_count_tbl po_tbl_number;
5689: l_canerr_msg_data_tbl po_tbl_varchar2000;
5690: l_line_location_id NUMBER;

Line 5688: l_canerr_msg_count_tbl po_tbl_number;

5684: l_canerr_line_num_tbl po_tbl_number;
5685: l_canerr_dist_id_tbl po_tbl_number;
5686: l_canerr_dist_num_tbl po_tbl_number;
5687: l_canerr_error_attr_tbl po_tbl_varchar30;
5688: l_canerr_msg_count_tbl po_tbl_number;
5689: l_canerr_msg_data_tbl po_tbl_varchar2000;
5690: l_line_location_id NUMBER;
5691: l_chn_req_id NUMBER;
5692: l_req_hdr_id NUMBER;

Line 5713: l_canerr_line_id_tbl := po_tbl_number();

5709: po_debug.debug_var(l_log_head, l_progress, 'p_group_id', p_group_id);
5710: END IF;
5711:
5712:
5713: l_canerr_line_id_tbl := po_tbl_number();
5714: l_canerr_line_num_tbl := po_tbl_number();
5715: l_canerr_dist_id_tbl := po_tbl_number();
5716: l_canerr_dist_num_tbl := po_tbl_number();
5717: l_canerr_error_attr_tbl := po_tbl_varchar30();

Line 5714: l_canerr_line_num_tbl := po_tbl_number();

5710: END IF;
5711:
5712:
5713: l_canerr_line_id_tbl := po_tbl_number();
5714: l_canerr_line_num_tbl := po_tbl_number();
5715: l_canerr_dist_id_tbl := po_tbl_number();
5716: l_canerr_dist_num_tbl := po_tbl_number();
5717: l_canerr_error_attr_tbl := po_tbl_varchar30();
5718: l_canerr_msg_count_tbl := po_tbl_number();

Line 5715: l_canerr_dist_id_tbl := po_tbl_number();

5711:
5712:
5713: l_canerr_line_id_tbl := po_tbl_number();
5714: l_canerr_line_num_tbl := po_tbl_number();
5715: l_canerr_dist_id_tbl := po_tbl_number();
5716: l_canerr_dist_num_tbl := po_tbl_number();
5717: l_canerr_error_attr_tbl := po_tbl_varchar30();
5718: l_canerr_msg_count_tbl := po_tbl_number();
5719: l_canerr_msg_data_tbl := po_tbl_varchar2000();

Line 5716: l_canerr_dist_num_tbl := po_tbl_number();

5712:
5713: l_canerr_line_id_tbl := po_tbl_number();
5714: l_canerr_line_num_tbl := po_tbl_number();
5715: l_canerr_dist_id_tbl := po_tbl_number();
5716: l_canerr_dist_num_tbl := po_tbl_number();
5717: l_canerr_error_attr_tbl := po_tbl_varchar30();
5718: l_canerr_msg_count_tbl := po_tbl_number();
5719: l_canerr_msg_data_tbl := po_tbl_varchar2000();
5720:

Line 5718: l_canerr_msg_count_tbl := po_tbl_number();

5714: l_canerr_line_num_tbl := po_tbl_number();
5715: l_canerr_dist_id_tbl := po_tbl_number();
5716: l_canerr_dist_num_tbl := po_tbl_number();
5717: l_canerr_error_attr_tbl := po_tbl_varchar30();
5718: l_canerr_msg_count_tbl := po_tbl_number();
5719: l_canerr_msg_data_tbl := po_tbl_varchar2000();
5720:
5721: p_errtable := po_req_change_err_table(
5722: l_canerr_line_id_tbl ,

Line 6218: l_err_line_id_tbl po_tbl_number;

6214: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
6215: l_po_to_req_rate NUMBER;
6216:
6217: l_po_return_code VARCHAR2(100) := '';
6218: l_err_line_id_tbl po_tbl_number;
6219: l_err_line_num_tbl po_tbl_number;
6220: l_err_dist_id_tbl po_tbl_number;
6221: l_err_dist_num_tbl po_tbl_number;
6222: l_err_error_attr_tbl po_tbl_varchar30;

Line 6219: l_err_line_num_tbl po_tbl_number;

6215: l_po_to_req_rate NUMBER;
6216:
6217: l_po_return_code VARCHAR2(100) := '';
6218: l_err_line_id_tbl po_tbl_number;
6219: l_err_line_num_tbl po_tbl_number;
6220: l_err_dist_id_tbl po_tbl_number;
6221: l_err_dist_num_tbl po_tbl_number;
6222: l_err_error_attr_tbl po_tbl_varchar30;
6223: l_err_msg_count_tbl po_tbl_number;

Line 6220: l_err_dist_id_tbl po_tbl_number;

6216:
6217: l_po_return_code VARCHAR2(100) := '';
6218: l_err_line_id_tbl po_tbl_number;
6219: l_err_line_num_tbl po_tbl_number;
6220: l_err_dist_id_tbl po_tbl_number;
6221: l_err_dist_num_tbl po_tbl_number;
6222: l_err_error_attr_tbl po_tbl_varchar30;
6223: l_err_msg_count_tbl po_tbl_number;
6224: l_err_msg_data_tbl po_tbl_varchar2000;

Line 6221: l_err_dist_num_tbl po_tbl_number;

6217: l_po_return_code VARCHAR2(100) := '';
6218: l_err_line_id_tbl po_tbl_number;
6219: l_err_line_num_tbl po_tbl_number;
6220: l_err_dist_id_tbl po_tbl_number;
6221: l_err_dist_num_tbl po_tbl_number;
6222: l_err_error_attr_tbl po_tbl_varchar30;
6223: l_err_msg_count_tbl po_tbl_number;
6224: l_err_msg_data_tbl po_tbl_varchar2000;
6225: l_wf_status VARCHAR2(1);

Line 6223: l_err_msg_count_tbl po_tbl_number;

6219: l_err_line_num_tbl po_tbl_number;
6220: l_err_dist_id_tbl po_tbl_number;
6221: l_err_dist_num_tbl po_tbl_number;
6222: l_err_error_attr_tbl po_tbl_varchar30;
6223: l_err_msg_count_tbl po_tbl_number;
6224: l_err_msg_data_tbl po_tbl_varchar2000;
6225: l_wf_status VARCHAR2(1);
6226: l_distribution_id_tbl po_tbl_number;
6227:

Line 6226: l_distribution_id_tbl po_tbl_number;

6222: l_err_error_attr_tbl po_tbl_varchar30;
6223: l_err_msg_count_tbl po_tbl_number;
6224: l_err_msg_data_tbl po_tbl_varchar2000;
6225: l_wf_status VARCHAR2(1);
6226: l_distribution_id_tbl po_tbl_number;
6227:
6228: CURSOR l_changes_csr(grp_id NUMBER) IS
6229: SELECT
6230: document_header_id,

Line 6420: l_distribution_id_tbl := po_tbl_number();

6416:
6417: IF (l_req_num IS NOT NULL) THEN
6418:
6419: -- initialize distributions list table
6420: l_distribution_id_tbl := po_tbl_number();
6421:
6422: -- insert NEW/OLD records of standard po distributions into PO_ENCUMBRANCE_GT
6423: OPEN l_changed_req_dists_csr(p_group_id);
6424:

Line 6559: l_err_line_id_tbl := po_tbl_number();

6555:
6556: -- populate x_errTable (output PLSQL table) with the corresponding
6557: -- funds check error messages.
6558:
6559: l_err_line_id_tbl := po_tbl_number();
6560: l_err_line_num_tbl := po_tbl_number();
6561: l_err_dist_id_tbl := po_tbl_number();
6562: l_err_dist_num_tbl := po_tbl_number();
6563: l_err_error_attr_tbl := po_tbl_varchar30();

Line 6560: l_err_line_num_tbl := po_tbl_number();

6556: -- populate x_errTable (output PLSQL table) with the corresponding
6557: -- funds check error messages.
6558:
6559: l_err_line_id_tbl := po_tbl_number();
6560: l_err_line_num_tbl := po_tbl_number();
6561: l_err_dist_id_tbl := po_tbl_number();
6562: l_err_dist_num_tbl := po_tbl_number();
6563: l_err_error_attr_tbl := po_tbl_varchar30();
6564: l_err_msg_count_tbl := po_tbl_number();

Line 6561: l_err_dist_id_tbl := po_tbl_number();

6557: -- funds check error messages.
6558:
6559: l_err_line_id_tbl := po_tbl_number();
6560: l_err_line_num_tbl := po_tbl_number();
6561: l_err_dist_id_tbl := po_tbl_number();
6562: l_err_dist_num_tbl := po_tbl_number();
6563: l_err_error_attr_tbl := po_tbl_varchar30();
6564: l_err_msg_count_tbl := po_tbl_number();
6565: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 6562: l_err_dist_num_tbl := po_tbl_number();

6558:
6559: l_err_line_id_tbl := po_tbl_number();
6560: l_err_line_num_tbl := po_tbl_number();
6561: l_err_dist_id_tbl := po_tbl_number();
6562: l_err_dist_num_tbl := po_tbl_number();
6563: l_err_error_attr_tbl := po_tbl_varchar30();
6564: l_err_msg_count_tbl := po_tbl_number();
6565: l_err_msg_data_tbl := po_tbl_varchar2000();
6566:

Line 6564: l_err_msg_count_tbl := po_tbl_number();

6560: l_err_line_num_tbl := po_tbl_number();
6561: l_err_dist_id_tbl := po_tbl_number();
6562: l_err_dist_num_tbl := po_tbl_number();
6563: l_err_error_attr_tbl := po_tbl_varchar30();
6564: l_err_msg_count_tbl := po_tbl_number();
6565: l_err_msg_data_tbl := po_tbl_varchar2000();
6566:
6567: x_errtable := po_req_change_err_table(
6568: l_err_line_id_tbl,

Line 6644: l_err_line_id_tbl := po_tbl_number();

6640: i := i + 1;
6641: END LOOP;
6642: CLOSE l_changes_csr;
6643: x_retmsg := 'SMRCH006';
6644: l_err_line_id_tbl := po_tbl_number();
6645: l_err_line_num_tbl := po_tbl_number();
6646: l_err_dist_id_tbl := po_tbl_number();
6647: l_err_dist_num_tbl := po_tbl_number();
6648: l_err_error_attr_tbl := po_tbl_varchar30();

Line 6645: l_err_line_num_tbl := po_tbl_number();

6641: END LOOP;
6642: CLOSE l_changes_csr;
6643: x_retmsg := 'SMRCH006';
6644: l_err_line_id_tbl := po_tbl_number();
6645: l_err_line_num_tbl := po_tbl_number();
6646: l_err_dist_id_tbl := po_tbl_number();
6647: l_err_dist_num_tbl := po_tbl_number();
6648: l_err_error_attr_tbl := po_tbl_varchar30();
6649: l_err_msg_count_tbl := po_tbl_number();

Line 6646: l_err_dist_id_tbl := po_tbl_number();

6642: CLOSE l_changes_csr;
6643: x_retmsg := 'SMRCH006';
6644: l_err_line_id_tbl := po_tbl_number();
6645: l_err_line_num_tbl := po_tbl_number();
6646: l_err_dist_id_tbl := po_tbl_number();
6647: l_err_dist_num_tbl := po_tbl_number();
6648: l_err_error_attr_tbl := po_tbl_varchar30();
6649: l_err_msg_count_tbl := po_tbl_number();
6650: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 6647: l_err_dist_num_tbl := po_tbl_number();

6643: x_retmsg := 'SMRCH006';
6644: l_err_line_id_tbl := po_tbl_number();
6645: l_err_line_num_tbl := po_tbl_number();
6646: l_err_dist_id_tbl := po_tbl_number();
6647: l_err_dist_num_tbl := po_tbl_number();
6648: l_err_error_attr_tbl := po_tbl_varchar30();
6649: l_err_msg_count_tbl := po_tbl_number();
6650: l_err_msg_data_tbl := po_tbl_varchar2000();
6651:

Line 6649: l_err_msg_count_tbl := po_tbl_number();

6645: l_err_line_num_tbl := po_tbl_number();
6646: l_err_dist_id_tbl := po_tbl_number();
6647: l_err_dist_num_tbl := po_tbl_number();
6648: l_err_error_attr_tbl := po_tbl_varchar30();
6649: l_err_msg_count_tbl := po_tbl_number();
6650: l_err_msg_data_tbl := po_tbl_varchar2000();
6651:
6652: x_errTable := po_req_change_err_table(
6653: l_err_line_id_tbl,