DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_REQ_CHANGE_ERR_TABLE

Line 28: p_errortable IN OUT NOCOPY po_req_change_err_table,

24:
25: PROCEDURE Validate_Quantity(p_header_id IN NUMBER,
26: p_release_id IN NUMBER,
27: p_po_change_table IN pos_chg_rec_tbl,
28: p_errortable IN OUT NOCOPY po_req_change_err_table,
29: p_error_index IN OUT NOCOPY NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_return_msg OUT NOCOPY VARCHAR2);
32:

Line 38: p_errortable IN OUT NOCOPY po_req_change_err_table,

34: p_release_id IN NUMBER,
35: p_err_po_msg IN VARCHAR2,
36: p_doc_check_rec_type IN doc_check_return_type,
37: p_po_error_index IN NUMBER,
38: p_errortable IN OUT NOCOPY po_req_change_err_table,
39: p_error_index IN OUT NOCOPY NUMBER,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_return_msg OUT NOCOPY VARCHAR2);
42:

Line 52: p_errortable IN OUT NOCOPY po_req_change_err_table);

48: PROCEDURE validate_changes(p_req_hdr_id IN NUMBER,
49: p_req_change_table IN OUT NOCOPY change_tbl_type,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_retmsg OUT NOCOPY VARCHAR,
52: p_errortable IN OUT NOCOPY po_req_change_err_table);
53:
54:
55: PROCEDURE update_recordswithtax(p_chn_req_grp_id NUMBER);
56:

Line 623: p_errortable IN OUT NOCOPY po_req_change_err_table,

619:
620: PROCEDURE validate_quantity(p_header_id IN NUMBER,
621: p_release_id IN NUMBER,
622: p_po_change_table IN pos_chg_rec_tbl,
623: p_errortable IN OUT NOCOPY po_req_change_err_table,
624: p_error_index IN OUT NOCOPY NUMBER,
625: x_return_status OUT NOCOPY VARCHAR2,
626: x_return_msg OUT NOCOPY VARCHAR2)
627: IS

Line 866: p_errortable IN OUT NOCOPY po_req_change_err_table,

862: p_release_id IN NUMBER,
863: p_err_po_msg IN VARCHAR2,
864: p_doc_check_rec_type IN doc_check_return_type,
865: p_po_error_index IN NUMBER,
866: p_errortable IN OUT NOCOPY po_req_change_err_table,
867: p_error_index IN OUT NOCOPY NUMBER,
868: x_return_status OUT NOCOPY VARCHAR2,
869: x_return_msg OUT NOCOPY VARCHAR2)
870: IS

Line 1348: p_errortable IN OUT NOCOPY po_req_change_err_table)

1344: PROCEDURE validate_changes(p_req_hdr_id IN NUMBER,
1345: p_req_change_table IN OUT NOCOPY change_tbl_type,
1346: x_return_status OUT NOCOPY VARCHAR2,
1347: x_retmsg OUT NOCOPY VARCHAR,
1348: p_errortable IN OUT NOCOPY po_req_change_err_table)
1349: IS
1350: l_api_name VARCHAR2(50) := 'Validate_Changes';
1351: l_po_change_table pos_chg_rec_tbl;
1352: l_error_table error_tbl_type;

Line 3628: x_errtable OUT NOCOPY po_req_change_err_table)

3624: p_change_table IN po_req_change_table,
3625: p_cancel_table IN po_req_cancel_table,
3626: p_change_request_group_id OUT NOCOPY NUMBER,
3627: x_retmsg OUT NOCOPY VARCHAR2,
3628: x_errtable OUT NOCOPY po_req_change_err_table)
3629: IS
3630: l_api_name VARCHAR2(50) := 'Save_ReqChange';
3631: l_req_change_table change_tbl_type;
3632: l_dummy NUMBER;

Line 3774: x_errtable := po_req_change_err_table(

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,
3778: l_err_dist_num_tbl,

Line 4028: x_errtable OUT NOCOPY po_req_change_err_table)

4024: p_note_to_approver IN VARCHAR2,
4025: p_initiator IN VARCHAR2,
4026: x_retmsg OUT NOCOPY VARCHAR2,
4027: x_errcode OUT NOCOPY VARCHAR2,
4028: x_errtable OUT NOCOPY po_req_change_err_table)
4029: IS
4030: l_api_name VARCHAR2(50) := 'Submit_ReqChange';
4031: i NUMBER := 1;
4032: l_cancelerrorsize NUMBER;

Line 4085: l_cancel_errtable po_req_change_err_table;

4081: l_new_amount NUMBER;
4082: l_price_break VARCHAR2(1);
4083:
4084: l_request_reason po_change_requests.request_reason%TYPE;
4085: l_cancel_errtable po_req_change_err_table;
4086: l_cal_disttax_status VARCHAR2(1);
4087: l_item_id NUMBER;
4088: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
4089: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 4563: x_errtable := po_req_change_err_table(

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,
4566: l_err_dist_id_tbl,
4567: l_err_dist_num_tbl,

Line 4648: x_errtable := po_req_change_err_table(

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,
4651: l_err_dist_id_tbl,
4652: l_err_dist_num_tbl,

Line 4733: p_errtable OUT NOCOPY po_req_change_err_table,

4729: p_api_version IN NUMBER,
4730: x_return_status OUT NOCOPY VARCHAR2,
4731: p_group_id IN NUMBER,
4732: x_retmsg OUT NOCOPY VARCHAR2,
4733: p_errtable OUT NOCOPY po_req_change_err_table,
4734: p_origin IN VARCHAR2)
4735: IS
4736: l_api_name VARCHAR2(50) := 'Submit_ReqCancel';
4737: l_line_id NUMBER;

Line 4775: p_errtable := po_req_change_err_table(

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,
4778: l_canerr_dist_id_tbl ,
4779: l_canerr_dist_num_tbl,

Line 5420: x_errtable OUT NOCOPY po_req_change_err_table)

5416: p_change_table IN po_req_change_table,
5417: p_cancel_table IN po_req_cancel_table,
5418: p_change_request_group_id OUT NOCOPY NUMBER,
5419: x_retmsg OUT NOCOPY VARCHAR2,
5420: x_errtable OUT NOCOPY po_req_change_err_table)
5421: IS
5422: l_api_name VARCHAR2(50) := 'Save_IReqChange';
5423: l_req_change_table change_tbl_type;
5424: l_dummy NUMBER;

Line 5589: x_errtable := po_req_change_err_table(

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,
5593: l_err_dist_num_tbl,

Line 5674: p_errtable OUT NOCOPY po_req_change_err_table,

5670: p_api_version IN NUMBER,
5671: x_return_status OUT NOCOPY VARCHAR2,
5672: p_group_id IN NUMBER,
5673: x_retmsg OUT NOCOPY VARCHAR2,
5674: p_errtable OUT NOCOPY po_req_change_err_table,
5675: p_origin IN VARCHAR2)
5676: IS
5677: l_api_name VARCHAR2(50) := 'Submit_IReqCancel';
5678: l_log_head CONSTANT VARCHAR2(100) := c_log_head || l_api_name;

Line 5721: p_errtable := po_req_change_err_table(

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,
5724: l_canerr_dist_id_tbl ,
5725: l_canerr_dist_num_tbl,

Line 6163: x_errtable OUT NOCOPY po_req_change_err_table)

6159: p_note_to_approver IN VARCHAR2,
6160: p_initiator IN VARCHAR2,
6161: x_retmsg OUT NOCOPY VARCHAR2,
6162: x_errcode OUT NOCOPY VARCHAR2,
6163: x_errtable OUT NOCOPY po_req_change_err_table)
6164: IS
6165: l_api_name VARCHAR2(50) := 'Submit_IReqChange';
6166: l_log_head CONSTANT VARCHAR2(100) := c_log_head || l_api_name;
6167:

Line 6210: l_cancel_errtable po_req_change_err_table;

6206: l_new_amount NUMBER;
6207: l_new_price NUMBER;
6208: l_distribution_id NUMBER;
6209: l_request_reason po_change_requests.request_reason%TYPE;
6210: l_cancel_errtable po_req_change_err_table;
6211: l_cal_disttax_status VARCHAR2(1);
6212: l_item_id NUMBER;
6213: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
6214: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 6567: x_errtable := po_req_change_err_table(

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,
6570: l_err_dist_id_tbl,
6571: l_err_dist_num_tbl,

Line 6652: x_errTable := po_req_change_err_table(

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,
6655: l_err_dist_id_tbl,
6656: l_err_dist_num_tbl,