DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_TBL_VARCHAR2000

Line 3642: l_err_msg_data_tbl po_tbl_varchar2000;

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;
3646: l_req_dist_id NUMBER;

Line 3773: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
3777: l_err_dist_id_tbl,

Line 4099: l_err_msg_data_tbl po_tbl_varchar2000;

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:
4103: CURSOR l_changes_csr(grp_id NUMBER) IS

Line 4561: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
4565: l_err_line_num_tbl,

Line 4646: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
4650: l_err_line_num_tbl,

Line 4746: l_canerr_msg_data_tbl po_tbl_varchar2000;

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;
4750: l_wf_status VARCHAR2(1);

Line 4773: l_canerr_msg_data_tbl := po_tbl_varchar2000();

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 ,
4777: l_canerr_line_num_tbl,

Line 5434: l_err_msg_data_tbl po_tbl_varchar2000;

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;
5438: l_req_dist_id NUMBER;

Line 5588: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
5592: l_err_dist_id_tbl,

Line 5689: l_canerr_msg_data_tbl po_tbl_varchar2000;

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;
5693: l_wf_status VARCHAR2(1);

Line 5719: l_canerr_msg_data_tbl := po_tbl_varchar2000();

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 ,
5723: l_canerr_line_num_tbl,

Line 6224: l_err_msg_data_tbl po_tbl_varchar2000;

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:
6228: CURSOR l_changes_csr(grp_id NUMBER) IS

Line 6565: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
6569: l_err_line_num_tbl,

Line 6650: l_err_msg_data_tbl := po_tbl_varchar2000();

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,
6654: l_err_line_num_tbl,