DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on POS_CHG_REC_TBL

Line 455: p_po_change_requests IN pos_chg_rec_tbl,

451: x_return_status OUT NOCOPY VARCHAR2,
452: p_po_header_id IN NUMBER,
453: p_po_release_id IN NUMBER,
454: p_revision_num IN NUMBER,
455: p_po_change_requests IN pos_chg_rec_tbl,
456: x_request_group_id OUT NOCOPY NUMBER,
457: p_chn_int_cont_num IN varchar2 default null,
458: p_chn_source IN varchar2 default null,
459: p_chn_requestor_username in varchar2 default null,

Line 628: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL

624: END save_request;
625:
626: /**
627: * Public Procedure: process_supplier_request
628: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL
629: * Modifies:
630: * Effects: Processes the change Request and calls PO Doc Submission Check
631: * Returns:
632: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

Line 642: p_po_change_requests IN pos_chg_rec_tbl,

638: procedure process_supplier_request (
639: p_po_header_id IN number,
640: p_po_release_id IN number,
641: p_revision_num IN number,
642: p_po_change_requests IN pos_chg_rec_tbl,
643: x_online_report_id OUT NOCOPY number,
644: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
645: p_chn_int_cont_num IN varchar2 default null,
646: p_chn_source IN varchar2 default null,

Line 670: l_po_change_requests pos_chg_rec_tbl := NULL;

666: x_return_status varchar2(20);
667: updatePoAttr boolean := false;
668: saveRequest boolean := false;
669: callWf boolean := false;
670: l_po_change_requests pos_chg_rec_tbl := NULL;
671: vAckTbl pos_ack_rec_tbl := pos_ack_rec_tbl();
672: ack_cnt number :=0;
673: callDocCheck boolean :=false;
674: accp_flag char(1);

Line 1341: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL

1337: END update_po_attributes;
1338:
1339: /**
1340: * Public Procedure: validate_change_request
1341: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL
1342: * Modifies:
1343: * Effects: Converts the Supplier Change Request To PO Change Request
1344: * Calls Doc Submission Check API
1345: * Also calls process_acknowledgements API to post Acknowledgements

Line 1360: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,

1356: x_msg_data OUT NOCOPY VARCHAR2,
1357: p_po_header_id IN number,
1358: p_po_release_id IN number,
1359: p_revision_num IN number,
1360: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
1361: x_online_report_id OUT NOCOPY number,
1362: x_pos_errors OUT NOCOPY pos_err_type,
1363: x_doc_check_error_msg OUT NOCOPY Doc_Check_Return_Type) is
1364:

Line 1837: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,

1833: x_msg_data OUT NOCOPY VARCHAR2,
1834: p_po_header_id IN number,
1835: p_po_release_id IN number,
1836: p_revision_num IN number,
1837: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
1838: x_online_report_id OUT NOCOPY number,
1839: x_pos_errors OUT NOCOPY pos_err_type) is
1840:
1841: l_doc_check_error_msg Doc_Check_Return_Type := NULL;

Line 2331: p_po_change_requests IN pos_chg_rec_tbl,

2327: x_return_status OUT NOCOPY VARCHAR2,
2328: p_po_header_id IN number,
2329: p_po_release_id IN number,
2330: p_revision_num IN number,
2331: p_po_change_requests IN pos_chg_rec_tbl,
2332: x_request_group_id OUT NOCOPY NUMBER) is
2333:
2334: l_api_name CONSTANT VARCHAR2(30) := 'save_cancel_request';
2335: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3164: p_po_change_requests IN pos_chg_rec_tbl,

3160: END;
3161:
3162: procedure validate_shipment_cancel (
3163: p_po_header_id IN number,
3164: p_po_change_requests IN pos_chg_rec_tbl,
3165: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3166: x_ret_sts OUT NOCOPY varchar2
3167: ) IS
3168:

Line 3169: l_po_change_requests pos_chg_rec_tbl := NULL;

3165: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3166: x_ret_sts OUT NOCOPY varchar2
3167: ) IS
3168:
3169: l_po_change_requests pos_chg_rec_tbl := NULL;
3170: l_count_asn NUMBER;
3171: l_err_msg_name_tbl po_tbl_varchar30;
3172: l_err_msg_text_tbl po_tbl_varchar2000;
3173: l_err_count NUMBER;

Line 3249: p_po_change_requests IN pos_chg_rec_tbl,

3245: END validate_shipment_cancel;
3246:
3247: procedure validate_ship_inv_cancel (
3248: p_po_header_id IN number,
3249: p_po_change_requests IN pos_chg_rec_tbl,
3250: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3251: x_ret_sts OUT NOCOPY varchar2
3252: ) IS
3253:

Line 3254: l_po_change_requests pos_chg_rec_tbl := NULL;

3250: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3251: x_ret_sts OUT NOCOPY varchar2
3252: ) IS
3253:
3254: l_po_change_requests pos_chg_rec_tbl := NULL;
3255: l_count_asn NUMBER;
3256: l_err_msg_name_tbl po_tbl_varchar30;
3257: l_err_msg_text_tbl po_tbl_varchar2000;
3258: l_err_count NUMBER;