DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_REQCHANGEREQUESTWF_PVT

Line 4700: po_reqchangerequestwf_pvt.submit_req_change(

4696: AND request_status = 'SYSTEMSAVE';
4697:
4698: --Kick Off Workflow
4699: x_retmsg := 'SMRCH009';
4700: po_reqchangerequestwf_pvt.submit_req_change(
4701: p_api_version => 1.0,
4702: p_commit => fnd_api.g_false,
4703:
4704: p_req_header_id => l_req_hdr_id,

Line 4819: po_reqchangerequestwf_pvt.submit_req_change(

4815: AND request_status = 'SYSTEMSAVE';
4816:
4817: IF (p_origin IS NULL AND l_workflow_needed = 'Y') THEN
4818:
4819: po_reqchangerequestwf_pvt.submit_req_change(
4820: p_api_version => 1.0,
4821: p_commit => fnd_api.g_false,
4822: x_return_status => l_wf_status,
4823: p_req_header_id => l_req_hdr_id,

Line 4981: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => p_req_header_id);

4977: IF (p_req_line_id is null and p_req_header_id is not null ) then
4978: l_progress := '001';
4979:
4980:
4981: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => p_req_header_id);
4982:
4983: IF l_orgid is NOT NULL THEN
4984: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4985: END IF;

Line 5002: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);

4998: , X_return_status =>x_return_status
4999: );
5000:
5001:
5002: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);
5003:
5004: IF l_orgid is NOT NULL THEN
5005: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5006: END IF;

Line 5029: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => l_req_header_id);

5025: WHERE prl.requisition_line_id = p_req_line_id AND
5026: prh.requisition_header_id = prl.requisition_header_id ;
5027:
5028: l_progress := '001';
5029: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => l_req_header_id);
5030:
5031: IF l_orgid is NOT NULL THEN
5032: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5033: END IF;

Line 5050: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);

5046: , X_return_status =>x_return_status
5047: );
5048:
5049:
5050: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);
5051:
5052: IF l_orgid is NOT NULL THEN
5053: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5054: END IF;

Line 5137: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => l_req_header_id);

5133: WHERE prl.requisition_line_id = p_req_line_id;
5134:
5135: l_progress := '001';
5136:
5137: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => l_req_header_id);
5138:
5139: IF l_orgid is NOT NULL THEN
5140: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5141: END IF;

Line 5158: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => l_req_header_id);

5154: , X_return_status =>x_return_status
5155: );
5156:
5157:
5158: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => l_req_header_id);
5159:
5160: IF l_orgid is NOT NULL THEN
5161: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5162: END IF;

Line 5767: po_reqchangerequestwf_pvt.submit_internal_req_change(

5763:
5764:
5765: IF (p_origin IS NULL AND l_workflow_needed = 'Y') THEN
5766:
5767: po_reqchangerequestwf_pvt.submit_internal_req_change(
5768: p_api_version => 1.0,
5769: p_commit => fnd_api.g_false,
5770: x_return_status => l_wf_status,
5771: p_req_header_id => l_req_hdr_id,

Line 5951: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

5947: po_debug.debug_var(l_log_head, l_progress, 'l_delta_quantity', l_delta_quantity);
5948: END IF;
5949: l_progress:='004';
5950:
5951: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
5952: p_req_line_id => p_req_line_id,
5953: p_delta_quantity=> l_delta_quantity,
5954: x_return_status =>l_return_status);
5955:

Line 5957: po_reqchangerequestwf_pvt.req_line_CANCEL(

5953: p_delta_quantity=> l_delta_quantity,
5954: x_return_status =>l_return_status);
5955:
5956: else
5957: po_reqchangerequestwf_pvt.req_line_CANCEL(
5958: p_req_line_id => l_req_line_id,
5959: x_return_status =>l_return_status);
5960: END IF;
5961: END IF;

Line 6028: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

6024: l_delta_quantity := l_open_quantity-l_quantity ;
6025: IF g_debug_stmt THEN
6026: po_debug.debug_var(l_log_head, l_progress, 'l_delta_quantity', l_delta_quantity);
6027: END IF;
6028: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
6029: p_req_line_id => p_req_line_id,
6030: p_delta_quantity=> l_delta_quantity,
6031: x_return_status =>l_return_status);
6032:

Line 6034: po_reqchangerequestwf_pvt.req_line_CANCEL(

6030: p_delta_quantity=> l_delta_quantity,
6031: x_return_status =>l_return_status);
6032:
6033: else
6034: po_reqchangerequestwf_pvt.req_line_CANCEL(
6035: p_req_line_id => p_req_line_id,
6036: x_return_status =>l_return_status);
6037: END IF;
6038: END IF;

Line 6111: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

6107: -- both the tables
6108: IF p_req_line_id IS NOT NULL AND p_delta_quantity IS NOT NULL THEN
6109:
6110: BEGIN
6111: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
6112: p_req_line_id => p_req_line_id,
6113: p_delta_quantity=> p_delta_quantity,
6114: x_return_status =>l_return_status);
6115:

Line 6133: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,

6129: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
6130:
6131: IF ( l_sync_need_by = 'YES' ) THEN
6132:
6133: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,
6134: p_need_by_date=> p_new_need_by_date,
6135: x_return_status =>l_return_status);
6136:
6137: END IF;

Line 6715: po_reqchangerequestwf_pvt.submit_internal_req_change(

6711:
6712: --Kick Off Workflow
6713: x_retmsg := 'SMRCH009';
6714:
6715: po_reqchangerequestwf_pvt.submit_internal_req_change(
6716: p_api_version => 1.0,
6717: p_commit => fnd_api.g_false,
6718: p_req_header_id => l_req_hdr_id,
6719: p_note_to_approver => p_note_to_approver,

Line 6822: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => p_req_header_id);

6818:
6819: l_progress :='001';
6820:
6821:
6822: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => p_req_header_id);
6823:
6824: IF l_orgid is NOT NULL THEN
6825: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6826: END IF;

Line 6848: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);

6844: IF g_debug_stmt THEN
6845: po_debug.debug_stmt(l_log_head, l_progress, 'returning from OM API Validating the changes');
6846: END IF;
6847:
6848: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);
6849:
6850: IF l_orgid is NOT NULL THEN
6851: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6852: END IF;