DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on POS_CHG_REC_TBL

Line 558: p_po_change_requests IN pos_chg_rec_tbl,

554: x_return_status OUT NOCOPY VARCHAR2,
555: p_po_header_id IN NUMBER,
556: p_po_release_id IN NUMBER,
557: p_revision_num IN NUMBER,
558: p_po_change_requests IN pos_chg_rec_tbl,
559: x_request_group_id OUT NOCOPY NUMBER,
560: p_chn_int_cont_num IN varchar2 default null,
561: p_chn_source IN varchar2 default null,
562: p_chn_requestor_username in varchar2 default null,

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

727: END save_request;
728:
729: /**
730: * Public Procedure: process_supplier_request
731: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL
732: * Modifies:
733: * Effects: Processes the change Request and calls PO Doc Submission Check
734: * Returns:
735: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

Line 745: p_po_change_requests IN pos_chg_rec_tbl,

741: procedure process_supplier_request (
742: p_po_header_id IN number,
743: p_po_release_id IN number,
744: p_revision_num IN number,
745: p_po_change_requests IN pos_chg_rec_tbl,
746: x_online_report_id OUT NOCOPY number,
747: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
748: p_chn_int_cont_num IN varchar2 default null,
749: p_chn_source IN varchar2 default null,

Line 773: l_po_change_requests pos_chg_rec_tbl := NULL;

769: x_return_status varchar2(20);
770: updatePoAttr boolean := false;
771: saveRequest boolean := false;
772: callWf boolean := false;
773: l_po_change_requests pos_chg_rec_tbl := NULL;
774: vAckTbl pos_ack_rec_tbl := pos_ack_rec_tbl();
775: ack_cnt number :=0;
776: callDocCheck boolean :=false;
777: accp_flag char(1);

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

1451: END update_po_attributes;
1452:
1453: /**
1454: * Public Procedure: validate_change_request
1455: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL
1456: * Modifies:
1457: * Effects: Converts the Supplier Change Request To PO Change Request
1458: * Calls Doc Submission Check API
1459: * Also calls process_acknowledgements API to post Acknowledgements

Line 1474: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,

1470: x_msg_data OUT NOCOPY VARCHAR2,
1471: p_po_header_id IN number,
1472: p_po_release_id IN number,
1473: p_revision_num IN number,
1474: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
1475: x_online_report_id OUT NOCOPY number,
1476: x_pos_errors OUT NOCOPY pos_err_type,
1477: x_doc_check_error_msg OUT NOCOPY Doc_Check_Return_Type) is
1478:

Line 1984: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,

1980: x_msg_data OUT NOCOPY VARCHAR2,
1981: p_po_header_id IN number,
1982: p_po_release_id IN number,
1983: p_revision_num IN number,
1984: p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
1985: x_online_report_id OUT NOCOPY number,
1986: x_pos_errors OUT NOCOPY pos_err_type) is
1987:
1988: l_doc_check_error_msg Doc_Check_Return_Type := NULL;

Line 2478: p_po_change_requests IN pos_chg_rec_tbl,

2474: x_return_status OUT NOCOPY VARCHAR2,
2475: p_po_header_id IN number,
2476: p_po_release_id IN number,
2477: p_revision_num IN number,
2478: p_po_change_requests IN pos_chg_rec_tbl,
2479: x_request_group_id OUT NOCOPY NUMBER) is
2480:
2481: l_api_name CONSTANT VARCHAR2(30) := 'save_cancel_request';
2482: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3539: p_po_change_requests IN pos_chg_rec_tbl,

3535: /*Added release_id as part of fix for bug 12903291 */
3536: procedure validate_shipment_cancel (
3537: p_po_header_id IN number,
3538: p_po_release_id IN number,
3539: p_po_change_requests IN pos_chg_rec_tbl,
3540: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3541: x_ret_sts OUT NOCOPY varchar2
3542: ) IS
3543:

Line 3544: l_po_change_requests pos_chg_rec_tbl := NULL;

3540: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3541: x_ret_sts OUT NOCOPY varchar2
3542: ) IS
3543:
3544: l_po_change_requests pos_chg_rec_tbl := NULL;
3545: l_count_asn NUMBER;
3546: l_err_msg_name_tbl po_tbl_varchar30;
3547: l_err_msg_text_tbl po_tbl_varchar2000;
3548: l_err_count NUMBER;

Line 3650: p_po_change_requests IN pos_chg_rec_tbl,

3646: END validate_shipment_cancel;
3647:
3648: procedure validate_ship_inv_cancel (
3649: p_po_header_id IN number,
3650: p_po_change_requests IN pos_chg_rec_tbl,
3651: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3652: x_ret_sts OUT NOCOPY varchar2
3653: ) IS
3654:

Line 3655: l_po_change_requests pos_chg_rec_tbl := NULL;

3651: x_pos_errors OUT NOCOPY POS_ERR_TYPE,
3652: x_ret_sts OUT NOCOPY varchar2
3653: ) IS
3654:
3655: l_po_change_requests pos_chg_rec_tbl := NULL;
3656: l_count_asn NUMBER;
3657: l_err_msg_name_tbl po_tbl_varchar30;
3658: l_err_msg_text_tbl po_tbl_varchar2000;
3659: l_err_count NUMBER;

Line 3746: p_po_change_requests IN POS_CHG_REC_TBL,

3742:
3743: /*Added for bug#14155598*/
3744: PROCEDURE IS_ASN_EXIST(p_po_header_id IN NUMBER,
3745: p_po_release_id IN NUMBER,
3746: p_po_change_requests IN POS_CHG_REC_TBL,
3747: x_pos_errors OUT nocopy POS_ERR_TYPE,
3748: x_ret_sts OUT nocopy VARCHAR2)
3749: IS
3750: l_po_change_requests POS_CHG_REC_TBL := NULL;

Line 3750: l_po_change_requests POS_CHG_REC_TBL := NULL;

3746: p_po_change_requests IN POS_CHG_REC_TBL,
3747: x_pos_errors OUT nocopy POS_ERR_TYPE,
3748: x_ret_sts OUT nocopy VARCHAR2)
3749: IS
3750: l_po_change_requests POS_CHG_REC_TBL := NULL;
3751: l_count_asn NUMBER;
3752: l_err_msg_name_tbl PO_TBL_VARCHAR30;
3753: l_err_msg_text_tbl PO_TBL_VARCHAR2000;
3754: l_err_count NUMBER;