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 3717: l_err_line_id_tbl po_tbl_number;

3713: l_dummy NUMBER;
3714: y NUMBER := 1;
3715: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3716: l_cancel_result VARCHAR2(1);
3717: l_err_line_id_tbl po_tbl_number;
3718: l_err_line_num_tbl po_tbl_number;
3719: l_err_dist_id_tbl po_tbl_number;
3720: l_err_dist_num_tbl po_tbl_number;
3721: l_err_error_attr_tbl po_tbl_varchar30;

Line 3718: l_err_line_num_tbl po_tbl_number;

3714: y NUMBER := 1;
3715: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3716: l_cancel_result VARCHAR2(1);
3717: l_err_line_id_tbl po_tbl_number;
3718: l_err_line_num_tbl po_tbl_number;
3719: l_err_dist_id_tbl po_tbl_number;
3720: l_err_dist_num_tbl po_tbl_number;
3721: l_err_error_attr_tbl po_tbl_varchar30;
3722: l_err_msg_count_tbl po_tbl_number;

Line 3719: l_err_dist_id_tbl po_tbl_number;

3715: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
3716: l_cancel_result VARCHAR2(1);
3717: l_err_line_id_tbl po_tbl_number;
3718: l_err_line_num_tbl po_tbl_number;
3719: l_err_dist_id_tbl po_tbl_number;
3720: l_err_dist_num_tbl po_tbl_number;
3721: l_err_error_attr_tbl po_tbl_varchar30;
3722: l_err_msg_count_tbl po_tbl_number;
3723: l_err_msg_data_tbl po_tbl_varchar2000;

Line 3720: l_err_dist_num_tbl po_tbl_number;

3716: l_cancel_result VARCHAR2(1);
3717: l_err_line_id_tbl po_tbl_number;
3718: l_err_line_num_tbl po_tbl_number;
3719: l_err_dist_id_tbl po_tbl_number;
3720: l_err_dist_num_tbl po_tbl_number;
3721: l_err_error_attr_tbl po_tbl_varchar30;
3722: l_err_msg_count_tbl po_tbl_number;
3723: l_err_msg_data_tbl po_tbl_varchar2000;
3724: l_irc_status VARCHAR2(1);

Line 3722: l_err_msg_count_tbl po_tbl_number;

3718: l_err_line_num_tbl po_tbl_number;
3719: l_err_dist_id_tbl po_tbl_number;
3720: l_err_dist_num_tbl po_tbl_number;
3721: l_err_error_attr_tbl po_tbl_varchar30;
3722: l_err_msg_count_tbl po_tbl_number;
3723: l_err_msg_data_tbl po_tbl_varchar2000;
3724: l_irc_status VARCHAR2(1);
3725: l_irc_err_msg VARCHAR2(2000);
3726: l_catch_exception EXCEPTION;

Line 3848: l_err_line_id_tbl := po_tbl_number();

3844:
3845:
3846: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3847: --Initialize the Error Table
3848: l_err_line_id_tbl := po_tbl_number();
3849: l_err_line_num_tbl := po_tbl_number();
3850: l_err_dist_id_tbl := po_tbl_number();
3851: l_err_dist_num_tbl := po_tbl_number();
3852: l_err_error_attr_tbl := po_tbl_varchar30();

Line 3849: l_err_line_num_tbl := po_tbl_number();

3845:
3846: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3847: --Initialize the Error Table
3848: l_err_line_id_tbl := po_tbl_number();
3849: l_err_line_num_tbl := po_tbl_number();
3850: l_err_dist_id_tbl := po_tbl_number();
3851: l_err_dist_num_tbl := po_tbl_number();
3852: l_err_error_attr_tbl := po_tbl_varchar30();
3853: l_err_msg_count_tbl := po_tbl_number();

Line 3850: l_err_dist_id_tbl := po_tbl_number();

3846: --Validate the Change Requests, by passing in l_req_change_table, a table of records
3847: --Initialize the Error Table
3848: l_err_line_id_tbl := po_tbl_number();
3849: l_err_line_num_tbl := po_tbl_number();
3850: l_err_dist_id_tbl := po_tbl_number();
3851: l_err_dist_num_tbl := po_tbl_number();
3852: l_err_error_attr_tbl := po_tbl_varchar30();
3853: l_err_msg_count_tbl := po_tbl_number();
3854: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 3851: l_err_dist_num_tbl := po_tbl_number();

3847: --Initialize the Error Table
3848: l_err_line_id_tbl := po_tbl_number();
3849: l_err_line_num_tbl := po_tbl_number();
3850: l_err_dist_id_tbl := po_tbl_number();
3851: l_err_dist_num_tbl := po_tbl_number();
3852: l_err_error_attr_tbl := po_tbl_varchar30();
3853: l_err_msg_count_tbl := po_tbl_number();
3854: l_err_msg_data_tbl := po_tbl_varchar2000();
3855: x_errtable := po_req_change_err_table(

Line 3853: l_err_msg_count_tbl := po_tbl_number();

3849: l_err_line_num_tbl := po_tbl_number();
3850: l_err_dist_id_tbl := po_tbl_number();
3851: l_err_dist_num_tbl := po_tbl_number();
3852: l_err_error_attr_tbl := po_tbl_varchar30();
3853: l_err_msg_count_tbl := po_tbl_number();
3854: l_err_msg_data_tbl := po_tbl_varchar2000();
3855: x_errtable := po_req_change_err_table(
3856: l_err_line_id_tbl,
3857: l_err_line_num_tbl,

Line 4176: l_err_line_id_tbl po_tbl_number;

4172: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
4173: l_po_to_req_rate NUMBER;
4174:
4175: l_po_return_code VARCHAR2(100) := '';
4176: l_err_line_id_tbl po_tbl_number;
4177: l_err_line_num_tbl po_tbl_number;
4178: l_err_dist_id_tbl po_tbl_number;
4179: l_err_dist_num_tbl po_tbl_number;
4180: l_err_error_attr_tbl po_tbl_varchar30;

Line 4177: l_err_line_num_tbl po_tbl_number;

4173: l_po_to_req_rate NUMBER;
4174:
4175: l_po_return_code VARCHAR2(100) := '';
4176: l_err_line_id_tbl po_tbl_number;
4177: l_err_line_num_tbl po_tbl_number;
4178: l_err_dist_id_tbl po_tbl_number;
4179: l_err_dist_num_tbl po_tbl_number;
4180: l_err_error_attr_tbl po_tbl_varchar30;
4181: l_err_msg_count_tbl po_tbl_number;

Line 4178: l_err_dist_id_tbl po_tbl_number;

4174:
4175: l_po_return_code VARCHAR2(100) := '';
4176: l_err_line_id_tbl po_tbl_number;
4177: l_err_line_num_tbl po_tbl_number;
4178: l_err_dist_id_tbl po_tbl_number;
4179: l_err_dist_num_tbl po_tbl_number;
4180: l_err_error_attr_tbl po_tbl_varchar30;
4181: l_err_msg_count_tbl po_tbl_number;
4182: l_err_msg_data_tbl po_tbl_varchar2000;

Line 4179: l_err_dist_num_tbl po_tbl_number;

4175: l_po_return_code VARCHAR2(100) := '';
4176: l_err_line_id_tbl po_tbl_number;
4177: l_err_line_num_tbl po_tbl_number;
4178: l_err_dist_id_tbl po_tbl_number;
4179: l_err_dist_num_tbl po_tbl_number;
4180: l_err_error_attr_tbl po_tbl_varchar30;
4181: l_err_msg_count_tbl po_tbl_number;
4182: l_err_msg_data_tbl po_tbl_varchar2000;
4183: l_wf_status VARCHAR2(1);

Line 4181: l_err_msg_count_tbl po_tbl_number;

4177: l_err_line_num_tbl po_tbl_number;
4178: l_err_dist_id_tbl po_tbl_number;
4179: l_err_dist_num_tbl po_tbl_number;
4180: l_err_error_attr_tbl po_tbl_varchar30;
4181: l_err_msg_count_tbl po_tbl_number;
4182: l_err_msg_data_tbl po_tbl_varchar2000;
4183: l_wf_status VARCHAR2(1);
4184: l_distribution_id_tbl po_tbl_number;
4185:

Line 4184: l_distribution_id_tbl po_tbl_number;

4180: l_err_error_attr_tbl po_tbl_varchar30;
4181: l_err_msg_count_tbl po_tbl_number;
4182: l_err_msg_data_tbl po_tbl_varchar2000;
4183: l_wf_status VARCHAR2(1);
4184: l_distribution_id_tbl po_tbl_number;
4185:
4186: CURSOR l_changes_csr(grp_id NUMBER) IS
4187: SELECT
4188: document_header_id,

Line 4367: l_distribution_id_tbl := po_tbl_number();

4363:
4364: IF (l_req_num IS NOT NULL) THEN
4365:
4366: -- initialize distributions list table
4367: l_distribution_id_tbl := po_tbl_number();
4368:
4369: -- insert NEW/OLD records of standard po distributions into PO_ENCUMBRANCE_GT
4370: OPEN l_changed_po_dists_csr(p_group_id);
4371:

Line 4691: l_err_line_id_tbl := po_tbl_number();

4687:
4688: -- populate x_errTable (output PLSQL table) with the corresponding
4689: -- funds check error messages.
4690:
4691: l_err_line_id_tbl := po_tbl_number();
4692: l_err_line_num_tbl := po_tbl_number();
4693: l_err_dist_id_tbl := po_tbl_number();
4694: l_err_dist_num_tbl := po_tbl_number();
4695: l_err_error_attr_tbl := po_tbl_varchar30();

Line 4692: l_err_line_num_tbl := po_tbl_number();

4688: -- populate x_errTable (output PLSQL table) with the corresponding
4689: -- funds check error messages.
4690:
4691: l_err_line_id_tbl := po_tbl_number();
4692: l_err_line_num_tbl := po_tbl_number();
4693: l_err_dist_id_tbl := po_tbl_number();
4694: l_err_dist_num_tbl := po_tbl_number();
4695: l_err_error_attr_tbl := po_tbl_varchar30();
4696: l_err_msg_count_tbl := po_tbl_number();

Line 4693: l_err_dist_id_tbl := po_tbl_number();

4689: -- funds check error messages.
4690:
4691: l_err_line_id_tbl := po_tbl_number();
4692: l_err_line_num_tbl := po_tbl_number();
4693: l_err_dist_id_tbl := po_tbl_number();
4694: l_err_dist_num_tbl := po_tbl_number();
4695: l_err_error_attr_tbl := po_tbl_varchar30();
4696: l_err_msg_count_tbl := po_tbl_number();
4697: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 4694: l_err_dist_num_tbl := po_tbl_number();

4690:
4691: l_err_line_id_tbl := po_tbl_number();
4692: l_err_line_num_tbl := po_tbl_number();
4693: l_err_dist_id_tbl := po_tbl_number();
4694: l_err_dist_num_tbl := po_tbl_number();
4695: l_err_error_attr_tbl := po_tbl_varchar30();
4696: l_err_msg_count_tbl := po_tbl_number();
4697: l_err_msg_data_tbl := po_tbl_varchar2000();
4698:

Line 4696: l_err_msg_count_tbl := po_tbl_number();

4692: l_err_line_num_tbl := po_tbl_number();
4693: l_err_dist_id_tbl := po_tbl_number();
4694: l_err_dist_num_tbl := po_tbl_number();
4695: l_err_error_attr_tbl := po_tbl_varchar30();
4696: l_err_msg_count_tbl := po_tbl_number();
4697: l_err_msg_data_tbl := po_tbl_varchar2000();
4698:
4699: x_errtable := po_req_change_err_table(
4700: l_err_line_id_tbl,

Line 4776: l_err_line_id_tbl := po_tbl_number();

4772: i := i + 1;
4773: END LOOP;
4774: CLOSE l_changes_csr;
4775: x_retmsg := 'SMRCH006';
4776: l_err_line_id_tbl := po_tbl_number();
4777: l_err_line_num_tbl := po_tbl_number();
4778: l_err_dist_id_tbl := po_tbl_number();
4779: l_err_dist_num_tbl := po_tbl_number();
4780: l_err_error_attr_tbl := po_tbl_varchar30();

Line 4777: l_err_line_num_tbl := po_tbl_number();

4773: END LOOP;
4774: CLOSE l_changes_csr;
4775: x_retmsg := 'SMRCH006';
4776: l_err_line_id_tbl := po_tbl_number();
4777: l_err_line_num_tbl := po_tbl_number();
4778: l_err_dist_id_tbl := po_tbl_number();
4779: l_err_dist_num_tbl := po_tbl_number();
4780: l_err_error_attr_tbl := po_tbl_varchar30();
4781: l_err_msg_count_tbl := po_tbl_number();

Line 4778: l_err_dist_id_tbl := po_tbl_number();

4774: CLOSE l_changes_csr;
4775: x_retmsg := 'SMRCH006';
4776: l_err_line_id_tbl := po_tbl_number();
4777: l_err_line_num_tbl := po_tbl_number();
4778: l_err_dist_id_tbl := po_tbl_number();
4779: l_err_dist_num_tbl := po_tbl_number();
4780: l_err_error_attr_tbl := po_tbl_varchar30();
4781: l_err_msg_count_tbl := po_tbl_number();
4782: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 4779: l_err_dist_num_tbl := po_tbl_number();

4775: x_retmsg := 'SMRCH006';
4776: l_err_line_id_tbl := po_tbl_number();
4777: l_err_line_num_tbl := po_tbl_number();
4778: l_err_dist_id_tbl := po_tbl_number();
4779: l_err_dist_num_tbl := po_tbl_number();
4780: l_err_error_attr_tbl := po_tbl_varchar30();
4781: l_err_msg_count_tbl := po_tbl_number();
4782: l_err_msg_data_tbl := po_tbl_varchar2000();
4783:

Line 4781: l_err_msg_count_tbl := po_tbl_number();

4777: l_err_line_num_tbl := po_tbl_number();
4778: l_err_dist_id_tbl := po_tbl_number();
4779: l_err_dist_num_tbl := po_tbl_number();
4780: l_err_error_attr_tbl := po_tbl_varchar30();
4781: l_err_msg_count_tbl := po_tbl_number();
4782: l_err_msg_data_tbl := po_tbl_varchar2000();
4783:
4784: x_errtable := po_req_change_err_table(
4785: l_err_line_id_tbl,

Line 4876: l_canerr_line_id_tbl po_tbl_number;

4872: l_api_name VARCHAR2(50) := 'Submit_ReqCancel';
4873: l_line_id NUMBER;
4874: l_result VARCHAR2(1);
4875: i NUMBER := 1;
4876: l_canerr_line_id_tbl po_tbl_number;
4877: l_canerr_line_num_tbl po_tbl_number;
4878: l_canerr_dist_id_tbl po_tbl_number;
4879: l_canerr_dist_num_tbl po_tbl_number;
4880: l_canerr_error_attr_tbl po_tbl_varchar30;

Line 4877: l_canerr_line_num_tbl po_tbl_number;

4873: l_line_id NUMBER;
4874: l_result VARCHAR2(1);
4875: i NUMBER := 1;
4876: l_canerr_line_id_tbl po_tbl_number;
4877: l_canerr_line_num_tbl po_tbl_number;
4878: l_canerr_dist_id_tbl po_tbl_number;
4879: l_canerr_dist_num_tbl po_tbl_number;
4880: l_canerr_error_attr_tbl po_tbl_varchar30;
4881: l_canerr_msg_count_tbl po_tbl_number;

Line 4878: l_canerr_dist_id_tbl po_tbl_number;

4874: l_result VARCHAR2(1);
4875: i NUMBER := 1;
4876: l_canerr_line_id_tbl po_tbl_number;
4877: l_canerr_line_num_tbl po_tbl_number;
4878: l_canerr_dist_id_tbl po_tbl_number;
4879: l_canerr_dist_num_tbl po_tbl_number;
4880: l_canerr_error_attr_tbl po_tbl_varchar30;
4881: l_canerr_msg_count_tbl po_tbl_number;
4882: l_canerr_msg_data_tbl po_tbl_varchar2000;

Line 4879: l_canerr_dist_num_tbl po_tbl_number;

4875: i NUMBER := 1;
4876: l_canerr_line_id_tbl po_tbl_number;
4877: l_canerr_line_num_tbl po_tbl_number;
4878: l_canerr_dist_id_tbl po_tbl_number;
4879: l_canerr_dist_num_tbl po_tbl_number;
4880: l_canerr_error_attr_tbl po_tbl_varchar30;
4881: l_canerr_msg_count_tbl po_tbl_number;
4882: l_canerr_msg_data_tbl po_tbl_varchar2000;
4883: l_line_location_id NUMBER;

Line 4881: l_canerr_msg_count_tbl po_tbl_number;

4877: l_canerr_line_num_tbl po_tbl_number;
4878: l_canerr_dist_id_tbl po_tbl_number;
4879: l_canerr_dist_num_tbl po_tbl_number;
4880: l_canerr_error_attr_tbl po_tbl_varchar30;
4881: l_canerr_msg_count_tbl po_tbl_number;
4882: l_canerr_msg_data_tbl po_tbl_varchar2000;
4883: l_line_location_id NUMBER;
4884: l_chn_req_id NUMBER;
4885: l_req_hdr_id NUMBER;

Line 4903: l_canerr_line_id_tbl := po_tbl_number();

4899: AND pcr.document_line_id = prla.requisition_line_id;
4900: BEGIN
4901:
4902:
4903: l_canerr_line_id_tbl := po_tbl_number();
4904: l_canerr_line_num_tbl := po_tbl_number();
4905: l_canerr_dist_id_tbl := po_tbl_number();
4906: l_canerr_dist_num_tbl := po_tbl_number();
4907: l_canerr_error_attr_tbl := po_tbl_varchar30();

Line 4904: l_canerr_line_num_tbl := po_tbl_number();

4900: BEGIN
4901:
4902:
4903: l_canerr_line_id_tbl := po_tbl_number();
4904: l_canerr_line_num_tbl := po_tbl_number();
4905: l_canerr_dist_id_tbl := po_tbl_number();
4906: l_canerr_dist_num_tbl := po_tbl_number();
4907: l_canerr_error_attr_tbl := po_tbl_varchar30();
4908: l_canerr_msg_count_tbl := po_tbl_number();

Line 4905: l_canerr_dist_id_tbl := po_tbl_number();

4901:
4902:
4903: l_canerr_line_id_tbl := po_tbl_number();
4904: l_canerr_line_num_tbl := po_tbl_number();
4905: l_canerr_dist_id_tbl := po_tbl_number();
4906: l_canerr_dist_num_tbl := po_tbl_number();
4907: l_canerr_error_attr_tbl := po_tbl_varchar30();
4908: l_canerr_msg_count_tbl := po_tbl_number();
4909: l_canerr_msg_data_tbl := po_tbl_varchar2000();

Line 4906: l_canerr_dist_num_tbl := po_tbl_number();

4902:
4903: l_canerr_line_id_tbl := po_tbl_number();
4904: l_canerr_line_num_tbl := po_tbl_number();
4905: l_canerr_dist_id_tbl := po_tbl_number();
4906: l_canerr_dist_num_tbl := po_tbl_number();
4907: l_canerr_error_attr_tbl := po_tbl_varchar30();
4908: l_canerr_msg_count_tbl := po_tbl_number();
4909: l_canerr_msg_data_tbl := po_tbl_varchar2000();
4910:

Line 4908: l_canerr_msg_count_tbl := po_tbl_number();

4904: l_canerr_line_num_tbl := po_tbl_number();
4905: l_canerr_dist_id_tbl := po_tbl_number();
4906: l_canerr_dist_num_tbl := po_tbl_number();
4907: l_canerr_error_attr_tbl := po_tbl_varchar30();
4908: l_canerr_msg_count_tbl := po_tbl_number();
4909: l_canerr_msg_data_tbl := po_tbl_varchar2000();
4910:
4911: p_errtable := po_req_change_err_table(
4912: l_canerr_line_id_tbl ,

Line 5586: l_err_line_id_tbl po_tbl_number;

5582: l_dummy NUMBER;
5583: y NUMBER := 1;
5584: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5585: l_cancel_result VARCHAR2(1);
5586: l_err_line_id_tbl po_tbl_number;
5587: l_err_line_num_tbl po_tbl_number;
5588: l_err_dist_id_tbl po_tbl_number;
5589: l_err_dist_num_tbl po_tbl_number;
5590: l_err_error_attr_tbl po_tbl_varchar30;

Line 5587: l_err_line_num_tbl po_tbl_number;

5583: y NUMBER := 1;
5584: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5585: l_cancel_result VARCHAR2(1);
5586: l_err_line_id_tbl po_tbl_number;
5587: l_err_line_num_tbl po_tbl_number;
5588: l_err_dist_id_tbl po_tbl_number;
5589: l_err_dist_num_tbl po_tbl_number;
5590: l_err_error_attr_tbl po_tbl_varchar30;
5591: l_err_msg_count_tbl po_tbl_number;

Line 5588: l_err_dist_id_tbl po_tbl_number;

5584: l_change_result VARCHAR2(1) := fnd_api.g_ret_sts_success;
5585: l_cancel_result VARCHAR2(1);
5586: l_err_line_id_tbl po_tbl_number;
5587: l_err_line_num_tbl po_tbl_number;
5588: l_err_dist_id_tbl po_tbl_number;
5589: l_err_dist_num_tbl po_tbl_number;
5590: l_err_error_attr_tbl po_tbl_varchar30;
5591: l_err_msg_count_tbl po_tbl_number;
5592: l_err_msg_data_tbl po_tbl_varchar2000;

Line 5589: l_err_dist_num_tbl po_tbl_number;

5585: l_cancel_result VARCHAR2(1);
5586: l_err_line_id_tbl po_tbl_number;
5587: l_err_line_num_tbl po_tbl_number;
5588: l_err_dist_id_tbl po_tbl_number;
5589: l_err_dist_num_tbl po_tbl_number;
5590: l_err_error_attr_tbl po_tbl_varchar30;
5591: l_err_msg_count_tbl po_tbl_number;
5592: l_err_msg_data_tbl po_tbl_varchar2000;
5593: l_irc_status VARCHAR2(1);

Line 5591: l_err_msg_count_tbl po_tbl_number;

5587: l_err_line_num_tbl po_tbl_number;
5588: l_err_dist_id_tbl po_tbl_number;
5589: l_err_dist_num_tbl po_tbl_number;
5590: l_err_error_attr_tbl po_tbl_varchar30;
5591: l_err_msg_count_tbl po_tbl_number;
5592: l_err_msg_data_tbl po_tbl_varchar2000;
5593: l_irc_status VARCHAR2(1);
5594: l_irc_err_msg VARCHAR2(2000);
5595: l_catch_exception EXCEPTION;

Line 5740: l_err_line_id_tbl := po_tbl_number();

5736:
5737:
5738: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5739: --Initialize the Error Table
5740: l_err_line_id_tbl := po_tbl_number();
5741: l_err_line_num_tbl := po_tbl_number();
5742: l_err_dist_id_tbl := po_tbl_number();
5743: l_err_dist_num_tbl := po_tbl_number();
5744: l_err_error_attr_tbl := po_tbl_varchar30();

Line 5741: l_err_line_num_tbl := po_tbl_number();

5737:
5738: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5739: --Initialize the Error Table
5740: l_err_line_id_tbl := po_tbl_number();
5741: l_err_line_num_tbl := po_tbl_number();
5742: l_err_dist_id_tbl := po_tbl_number();
5743: l_err_dist_num_tbl := po_tbl_number();
5744: l_err_error_attr_tbl := po_tbl_varchar30();
5745: l_err_msg_count_tbl := po_tbl_number();

Line 5742: l_err_dist_id_tbl := po_tbl_number();

5738: --Validate the Change Requests, by passing in l_req_change_table, a table of records
5739: --Initialize the Error Table
5740: l_err_line_id_tbl := po_tbl_number();
5741: l_err_line_num_tbl := po_tbl_number();
5742: l_err_dist_id_tbl := po_tbl_number();
5743: l_err_dist_num_tbl := po_tbl_number();
5744: l_err_error_attr_tbl := po_tbl_varchar30();
5745: l_err_msg_count_tbl := po_tbl_number();
5746: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 5743: l_err_dist_num_tbl := po_tbl_number();

5739: --Initialize the Error Table
5740: l_err_line_id_tbl := po_tbl_number();
5741: l_err_line_num_tbl := po_tbl_number();
5742: l_err_dist_id_tbl := po_tbl_number();
5743: l_err_dist_num_tbl := po_tbl_number();
5744: l_err_error_attr_tbl := po_tbl_varchar30();
5745: l_err_msg_count_tbl := po_tbl_number();
5746: l_err_msg_data_tbl := po_tbl_varchar2000();
5747: x_errtable := po_req_change_err_table(

Line 5745: l_err_msg_count_tbl := po_tbl_number();

5741: l_err_line_num_tbl := po_tbl_number();
5742: l_err_dist_id_tbl := po_tbl_number();
5743: l_err_dist_num_tbl := po_tbl_number();
5744: l_err_error_attr_tbl := po_tbl_varchar30();
5745: l_err_msg_count_tbl := po_tbl_number();
5746: l_err_msg_data_tbl := po_tbl_varchar2000();
5747: x_errtable := po_req_change_err_table(
5748: l_err_line_id_tbl,
5749: l_err_line_num_tbl,

Line 5841: l_canerr_line_id_tbl po_tbl_number;

5837: l_line_id NUMBER;
5838: l_result VARCHAR2(1);
5839: l_progress VARCHAR2(3):='000';
5840: i NUMBER := 1;
5841: l_canerr_line_id_tbl po_tbl_number;
5842: l_canerr_line_num_tbl po_tbl_number;
5843: l_canerr_dist_id_tbl po_tbl_number;
5844: l_canerr_dist_num_tbl po_tbl_number;
5845: l_canerr_error_attr_tbl po_tbl_varchar30;

Line 5842: l_canerr_line_num_tbl po_tbl_number;

5838: l_result VARCHAR2(1);
5839: l_progress VARCHAR2(3):='000';
5840: i NUMBER := 1;
5841: l_canerr_line_id_tbl po_tbl_number;
5842: l_canerr_line_num_tbl po_tbl_number;
5843: l_canerr_dist_id_tbl po_tbl_number;
5844: l_canerr_dist_num_tbl po_tbl_number;
5845: l_canerr_error_attr_tbl po_tbl_varchar30;
5846: l_canerr_msg_count_tbl po_tbl_number;

Line 5843: l_canerr_dist_id_tbl po_tbl_number;

5839: l_progress VARCHAR2(3):='000';
5840: i NUMBER := 1;
5841: l_canerr_line_id_tbl po_tbl_number;
5842: l_canerr_line_num_tbl po_tbl_number;
5843: l_canerr_dist_id_tbl po_tbl_number;
5844: l_canerr_dist_num_tbl po_tbl_number;
5845: l_canerr_error_attr_tbl po_tbl_varchar30;
5846: l_canerr_msg_count_tbl po_tbl_number;
5847: l_canerr_msg_data_tbl po_tbl_varchar2000;

Line 5844: l_canerr_dist_num_tbl po_tbl_number;

5840: i NUMBER := 1;
5841: l_canerr_line_id_tbl po_tbl_number;
5842: l_canerr_line_num_tbl po_tbl_number;
5843: l_canerr_dist_id_tbl po_tbl_number;
5844: l_canerr_dist_num_tbl po_tbl_number;
5845: l_canerr_error_attr_tbl po_tbl_varchar30;
5846: l_canerr_msg_count_tbl po_tbl_number;
5847: l_canerr_msg_data_tbl po_tbl_varchar2000;
5848: l_line_location_id NUMBER;

Line 5846: l_canerr_msg_count_tbl po_tbl_number;

5842: l_canerr_line_num_tbl po_tbl_number;
5843: l_canerr_dist_id_tbl po_tbl_number;
5844: l_canerr_dist_num_tbl po_tbl_number;
5845: l_canerr_error_attr_tbl po_tbl_varchar30;
5846: l_canerr_msg_count_tbl po_tbl_number;
5847: l_canerr_msg_data_tbl po_tbl_varchar2000;
5848: l_line_location_id NUMBER;
5849: l_chn_req_id NUMBER;
5850: l_req_hdr_id NUMBER;

Line 5871: l_canerr_line_id_tbl := po_tbl_number();

5867: po_debug.debug_var(l_log_head, l_progress, 'p_group_id', p_group_id);
5868: END IF;
5869:
5870:
5871: l_canerr_line_id_tbl := po_tbl_number();
5872: l_canerr_line_num_tbl := po_tbl_number();
5873: l_canerr_dist_id_tbl := po_tbl_number();
5874: l_canerr_dist_num_tbl := po_tbl_number();
5875: l_canerr_error_attr_tbl := po_tbl_varchar30();

Line 5872: l_canerr_line_num_tbl := po_tbl_number();

5868: END IF;
5869:
5870:
5871: l_canerr_line_id_tbl := po_tbl_number();
5872: l_canerr_line_num_tbl := po_tbl_number();
5873: l_canerr_dist_id_tbl := po_tbl_number();
5874: l_canerr_dist_num_tbl := po_tbl_number();
5875: l_canerr_error_attr_tbl := po_tbl_varchar30();
5876: l_canerr_msg_count_tbl := po_tbl_number();

Line 5873: l_canerr_dist_id_tbl := po_tbl_number();

5869:
5870:
5871: l_canerr_line_id_tbl := po_tbl_number();
5872: l_canerr_line_num_tbl := po_tbl_number();
5873: l_canerr_dist_id_tbl := po_tbl_number();
5874: l_canerr_dist_num_tbl := po_tbl_number();
5875: l_canerr_error_attr_tbl := po_tbl_varchar30();
5876: l_canerr_msg_count_tbl := po_tbl_number();
5877: l_canerr_msg_data_tbl := po_tbl_varchar2000();

Line 5874: l_canerr_dist_num_tbl := po_tbl_number();

5870:
5871: l_canerr_line_id_tbl := po_tbl_number();
5872: l_canerr_line_num_tbl := po_tbl_number();
5873: l_canerr_dist_id_tbl := po_tbl_number();
5874: l_canerr_dist_num_tbl := po_tbl_number();
5875: l_canerr_error_attr_tbl := po_tbl_varchar30();
5876: l_canerr_msg_count_tbl := po_tbl_number();
5877: l_canerr_msg_data_tbl := po_tbl_varchar2000();
5878:

Line 5876: l_canerr_msg_count_tbl := po_tbl_number();

5872: l_canerr_line_num_tbl := po_tbl_number();
5873: l_canerr_dist_id_tbl := po_tbl_number();
5874: l_canerr_dist_num_tbl := po_tbl_number();
5875: l_canerr_error_attr_tbl := po_tbl_varchar30();
5876: l_canerr_msg_count_tbl := po_tbl_number();
5877: l_canerr_msg_data_tbl := po_tbl_varchar2000();
5878:
5879: p_errtable := po_req_change_err_table(
5880: l_canerr_line_id_tbl ,

Line 6269: l_err_line_id_tbl po_tbl_number;

6265: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
6266: l_po_to_req_rate NUMBER;
6267:
6268: l_po_return_code VARCHAR2(100) := '';
6269: l_err_line_id_tbl po_tbl_number;
6270: l_err_line_num_tbl po_tbl_number;
6271: l_err_dist_id_tbl po_tbl_number;
6272: l_err_dist_num_tbl po_tbl_number;
6273: l_err_error_attr_tbl po_tbl_varchar30;

Line 6270: l_err_line_num_tbl po_tbl_number;

6266: l_po_to_req_rate NUMBER;
6267:
6268: l_po_return_code VARCHAR2(100) := '';
6269: l_err_line_id_tbl po_tbl_number;
6270: l_err_line_num_tbl po_tbl_number;
6271: l_err_dist_id_tbl po_tbl_number;
6272: l_err_dist_num_tbl po_tbl_number;
6273: l_err_error_attr_tbl po_tbl_varchar30;
6274: l_err_msg_count_tbl po_tbl_number;

Line 6271: l_err_dist_id_tbl po_tbl_number;

6267:
6268: l_po_return_code VARCHAR2(100) := '';
6269: l_err_line_id_tbl po_tbl_number;
6270: l_err_line_num_tbl po_tbl_number;
6271: l_err_dist_id_tbl po_tbl_number;
6272: l_err_dist_num_tbl po_tbl_number;
6273: l_err_error_attr_tbl po_tbl_varchar30;
6274: l_err_msg_count_tbl po_tbl_number;
6275: l_err_msg_data_tbl po_tbl_varchar2000;

Line 6272: l_err_dist_num_tbl po_tbl_number;

6268: l_po_return_code VARCHAR2(100) := '';
6269: l_err_line_id_tbl po_tbl_number;
6270: l_err_line_num_tbl po_tbl_number;
6271: l_err_dist_id_tbl po_tbl_number;
6272: l_err_dist_num_tbl po_tbl_number;
6273: l_err_error_attr_tbl po_tbl_varchar30;
6274: l_err_msg_count_tbl po_tbl_number;
6275: l_err_msg_data_tbl po_tbl_varchar2000;
6276: l_wf_status VARCHAR2(1);

Line 6274: l_err_msg_count_tbl po_tbl_number;

6270: l_err_line_num_tbl po_tbl_number;
6271: l_err_dist_id_tbl po_tbl_number;
6272: l_err_dist_num_tbl po_tbl_number;
6273: l_err_error_attr_tbl po_tbl_varchar30;
6274: l_err_msg_count_tbl po_tbl_number;
6275: l_err_msg_data_tbl po_tbl_varchar2000;
6276: l_wf_status VARCHAR2(1);
6277: l_distribution_id_tbl po_tbl_number;
6278:

Line 6277: l_distribution_id_tbl po_tbl_number;

6273: l_err_error_attr_tbl po_tbl_varchar30;
6274: l_err_msg_count_tbl po_tbl_number;
6275: l_err_msg_data_tbl po_tbl_varchar2000;
6276: l_wf_status VARCHAR2(1);
6277: l_distribution_id_tbl po_tbl_number;
6278:
6279: CURSOR l_changes_csr(grp_id NUMBER) IS
6280: SELECT
6281: document_header_id,

Line 6471: l_distribution_id_tbl := po_tbl_number();

6467:
6468: IF (l_req_num IS NOT NULL) THEN
6469:
6470: -- initialize distributions list table
6471: l_distribution_id_tbl := po_tbl_number();
6472:
6473: -- insert NEW/OLD records of standard po distributions into PO_ENCUMBRANCE_GT
6474: OPEN l_changed_req_dists_csr(p_group_id);
6475:

Line 6610: l_err_line_id_tbl := po_tbl_number();

6606:
6607: -- populate x_errTable (output PLSQL table) with the corresponding
6608: -- funds check error messages.
6609:
6610: l_err_line_id_tbl := po_tbl_number();
6611: l_err_line_num_tbl := po_tbl_number();
6612: l_err_dist_id_tbl := po_tbl_number();
6613: l_err_dist_num_tbl := po_tbl_number();
6614: l_err_error_attr_tbl := po_tbl_varchar30();

Line 6611: l_err_line_num_tbl := po_tbl_number();

6607: -- populate x_errTable (output PLSQL table) with the corresponding
6608: -- funds check error messages.
6609:
6610: l_err_line_id_tbl := po_tbl_number();
6611: l_err_line_num_tbl := po_tbl_number();
6612: l_err_dist_id_tbl := po_tbl_number();
6613: l_err_dist_num_tbl := po_tbl_number();
6614: l_err_error_attr_tbl := po_tbl_varchar30();
6615: l_err_msg_count_tbl := po_tbl_number();

Line 6612: l_err_dist_id_tbl := po_tbl_number();

6608: -- funds check error messages.
6609:
6610: l_err_line_id_tbl := po_tbl_number();
6611: l_err_line_num_tbl := po_tbl_number();
6612: l_err_dist_id_tbl := po_tbl_number();
6613: l_err_dist_num_tbl := po_tbl_number();
6614: l_err_error_attr_tbl := po_tbl_varchar30();
6615: l_err_msg_count_tbl := po_tbl_number();
6616: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 6613: l_err_dist_num_tbl := po_tbl_number();

6609:
6610: l_err_line_id_tbl := po_tbl_number();
6611: l_err_line_num_tbl := po_tbl_number();
6612: l_err_dist_id_tbl := po_tbl_number();
6613: l_err_dist_num_tbl := po_tbl_number();
6614: l_err_error_attr_tbl := po_tbl_varchar30();
6615: l_err_msg_count_tbl := po_tbl_number();
6616: l_err_msg_data_tbl := po_tbl_varchar2000();
6617:

Line 6615: l_err_msg_count_tbl := po_tbl_number();

6611: l_err_line_num_tbl := po_tbl_number();
6612: l_err_dist_id_tbl := po_tbl_number();
6613: l_err_dist_num_tbl := po_tbl_number();
6614: l_err_error_attr_tbl := po_tbl_varchar30();
6615: l_err_msg_count_tbl := po_tbl_number();
6616: l_err_msg_data_tbl := po_tbl_varchar2000();
6617:
6618: x_errtable := po_req_change_err_table(
6619: l_err_line_id_tbl,

Line 6695: l_err_line_id_tbl := po_tbl_number();

6691: i := i + 1;
6692: END LOOP;
6693: CLOSE l_changes_csr;
6694: x_retmsg := 'SMRCH006';
6695: l_err_line_id_tbl := po_tbl_number();
6696: l_err_line_num_tbl := po_tbl_number();
6697: l_err_dist_id_tbl := po_tbl_number();
6698: l_err_dist_num_tbl := po_tbl_number();
6699: l_err_error_attr_tbl := po_tbl_varchar30();

Line 6696: l_err_line_num_tbl := po_tbl_number();

6692: END LOOP;
6693: CLOSE l_changes_csr;
6694: x_retmsg := 'SMRCH006';
6695: l_err_line_id_tbl := po_tbl_number();
6696: l_err_line_num_tbl := po_tbl_number();
6697: l_err_dist_id_tbl := po_tbl_number();
6698: l_err_dist_num_tbl := po_tbl_number();
6699: l_err_error_attr_tbl := po_tbl_varchar30();
6700: l_err_msg_count_tbl := po_tbl_number();

Line 6697: l_err_dist_id_tbl := po_tbl_number();

6693: CLOSE l_changes_csr;
6694: x_retmsg := 'SMRCH006';
6695: l_err_line_id_tbl := po_tbl_number();
6696: l_err_line_num_tbl := po_tbl_number();
6697: l_err_dist_id_tbl := po_tbl_number();
6698: l_err_dist_num_tbl := po_tbl_number();
6699: l_err_error_attr_tbl := po_tbl_varchar30();
6700: l_err_msg_count_tbl := po_tbl_number();
6701: l_err_msg_data_tbl := po_tbl_varchar2000();

Line 6698: l_err_dist_num_tbl := po_tbl_number();

6694: x_retmsg := 'SMRCH006';
6695: l_err_line_id_tbl := po_tbl_number();
6696: l_err_line_num_tbl := po_tbl_number();
6697: l_err_dist_id_tbl := po_tbl_number();
6698: l_err_dist_num_tbl := po_tbl_number();
6699: l_err_error_attr_tbl := po_tbl_varchar30();
6700: l_err_msg_count_tbl := po_tbl_number();
6701: l_err_msg_data_tbl := po_tbl_varchar2000();
6702:

Line 6700: l_err_msg_count_tbl := po_tbl_number();

6696: l_err_line_num_tbl := po_tbl_number();
6697: l_err_dist_id_tbl := po_tbl_number();
6698: l_err_dist_num_tbl := po_tbl_number();
6699: l_err_error_attr_tbl := po_tbl_varchar30();
6700: l_err_msg_count_tbl := po_tbl_number();
6701: l_err_msg_data_tbl := po_tbl_varchar2000();
6702:
6703: x_errTable := po_req_change_err_table(
6704: l_err_line_id_tbl,