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 1385: p_errortable IN OUT NOCOPY po_req_change_err_table)

1381: PROCEDURE validate_changes(p_req_hdr_id IN NUMBER,
1382: p_req_change_table IN OUT NOCOPY change_tbl_type,
1383: x_return_status OUT NOCOPY VARCHAR2,
1384: x_retmsg OUT NOCOPY VARCHAR,
1385: p_errortable IN OUT NOCOPY po_req_change_err_table)
1386: IS
1387: l_api_name VARCHAR2(50) := 'Validate_Changes';
1388: l_po_change_table pos_chg_rec_tbl;
1389: l_error_table error_tbl_type;

Line 3709: x_errtable OUT NOCOPY po_req_change_err_table)

3705: p_change_table IN po_req_change_table,
3706: p_cancel_table IN po_req_cancel_table,
3707: p_change_request_group_id OUT NOCOPY NUMBER,
3708: x_retmsg OUT NOCOPY VARCHAR2,
3709: x_errtable OUT NOCOPY po_req_change_err_table)
3710: IS
3711: l_api_name VARCHAR2(50) := 'Save_ReqChange';
3712: l_req_change_table change_tbl_type;
3713: l_dummy NUMBER;

Line 3855: x_errtable := po_req_change_err_table(

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

Line 4109: x_errtable OUT NOCOPY po_req_change_err_table)

4105: p_note_to_approver IN VARCHAR2,
4106: p_initiator IN VARCHAR2,
4107: x_retmsg OUT NOCOPY VARCHAR2,
4108: x_errcode OUT NOCOPY VARCHAR2,
4109: x_errtable OUT NOCOPY po_req_change_err_table)
4110: IS
4111: l_api_name VARCHAR2(50) := 'Submit_ReqChange';
4112: i NUMBER := 1;
4113: l_cancelerrorsize NUMBER;

Line 4168: l_cancel_errtable po_req_change_err_table;

4164: -- l_set_of_books_id NUMBER;
4165: -- l_gl_period GL_PERIOD_STATUSES.PERIOD_NAME%TYPE;
4166:
4167: l_request_reason po_change_requests.request_reason%TYPE;
4168: l_cancel_errtable po_req_change_err_table;
4169: l_cal_disttax_status VARCHAR2(1);
4170: l_item_id NUMBER;
4171: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
4172: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 4699: x_errtable := po_req_change_err_table(

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,
4702: l_err_dist_id_tbl,
4703: l_err_dist_num_tbl,

Line 4784: x_errtable := po_req_change_err_table(

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,
4787: l_err_dist_id_tbl,
4788: l_err_dist_num_tbl,

Line 4869: p_errtable OUT NOCOPY po_req_change_err_table,

4865: p_api_version IN NUMBER,
4866: x_return_status OUT NOCOPY VARCHAR2,
4867: p_group_id IN NUMBER,
4868: x_retmsg OUT NOCOPY VARCHAR2,
4869: p_errtable OUT NOCOPY po_req_change_err_table,
4870: p_origin IN VARCHAR2)
4871: IS
4872: l_api_name VARCHAR2(50) := 'Submit_ReqCancel';
4873: l_line_id NUMBER;

Line 4911: p_errtable := po_req_change_err_table(

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,
4914: l_canerr_dist_id_tbl ,
4915: l_canerr_dist_num_tbl,

Line 5578: x_errtable OUT NOCOPY po_req_change_err_table)

5574: p_change_table IN po_req_change_table,
5575: p_cancel_table IN po_req_cancel_table,
5576: p_change_request_group_id OUT NOCOPY NUMBER,
5577: x_retmsg OUT NOCOPY VARCHAR2,
5578: x_errtable OUT NOCOPY po_req_change_err_table)
5579: IS
5580: l_api_name VARCHAR2(50) := 'Save_IReqChange';
5581: l_req_change_table change_tbl_type;
5582: l_dummy NUMBER;

Line 5747: x_errtable := po_req_change_err_table(

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

Line 5832: p_errtable OUT NOCOPY po_req_change_err_table,

5828: p_api_version IN NUMBER,
5829: x_return_status OUT NOCOPY VARCHAR2,
5830: p_group_id IN NUMBER,
5831: x_retmsg OUT NOCOPY VARCHAR2,
5832: p_errtable OUT NOCOPY po_req_change_err_table,
5833: p_origin IN VARCHAR2)
5834: IS
5835: l_api_name VARCHAR2(50) := 'Submit_IReqCancel';
5836: l_log_head CONSTANT VARCHAR2(100) := c_log_head || l_api_name;

Line 5879: p_errtable := po_req_change_err_table(

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,
5882: l_canerr_dist_id_tbl ,
5883: l_canerr_dist_num_tbl,

Line 6214: x_errtable OUT NOCOPY po_req_change_err_table)

6210: p_note_to_approver IN VARCHAR2,
6211: p_initiator IN VARCHAR2,
6212: x_retmsg OUT NOCOPY VARCHAR2,
6213: x_errcode OUT NOCOPY VARCHAR2,
6214: x_errtable OUT NOCOPY po_req_change_err_table)
6215: IS
6216: l_api_name VARCHAR2(50) := 'Submit_IReqChange';
6217: l_log_head CONSTANT VARCHAR2(100) := c_log_head || l_api_name;
6218:

Line 6261: l_cancel_errtable po_req_change_err_table;

6257: l_new_amount NUMBER;
6258: l_new_price NUMBER;
6259: l_distribution_id NUMBER;
6260: l_request_reason po_change_requests.request_reason%TYPE;
6261: l_cancel_errtable po_req_change_err_table;
6262: l_cal_disttax_status VARCHAR2(1);
6263: l_item_id NUMBER;
6264: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
6265: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 6618: x_errtable := po_req_change_err_table(

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,
6621: l_err_dist_id_tbl,
6622: l_err_dist_num_tbl,

Line 6703: x_errTable := po_req_change_err_table(

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,
6706: l_err_dist_id_tbl,
6707: l_err_dist_num_tbl,