DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_TBL_VARCHAR2000

Line 3723: l_err_msg_data_tbl po_tbl_varchar2000;

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

Line 3854: l_err_msg_data_tbl := po_tbl_varchar2000();

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

Line 4182: l_err_msg_data_tbl po_tbl_varchar2000;

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

Line 4697: l_err_msg_data_tbl := po_tbl_varchar2000();

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

Line 4782: l_err_msg_data_tbl := po_tbl_varchar2000();

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

Line 4882: l_canerr_msg_data_tbl po_tbl_varchar2000;

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

Line 4909: l_canerr_msg_data_tbl := po_tbl_varchar2000();

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

Line 5592: l_err_msg_data_tbl po_tbl_varchar2000;

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

Line 5746: l_err_msg_data_tbl := po_tbl_varchar2000();

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

Line 5847: l_canerr_msg_data_tbl po_tbl_varchar2000;

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

Line 5877: l_canerr_msg_data_tbl := po_tbl_varchar2000();

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

Line 6275: l_err_msg_data_tbl po_tbl_varchar2000;

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

Line 6616: l_err_msg_data_tbl := po_tbl_varchar2000();

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

Line 6701: l_err_msg_data_tbl := po_tbl_varchar2000();

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