DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_REQCHANGEREQUESTWF_PVT

Line 4836: po_reqchangerequestwf_pvt.submit_req_change(

4832: AND request_status = 'SYSTEMSAVE';
4833:
4834: --Kick Off Workflow
4835: x_retmsg := 'SMRCH009';
4836: po_reqchangerequestwf_pvt.submit_req_change(
4837: p_api_version => 1.0,
4838: p_commit => fnd_api.g_false,
4839:
4840: p_req_header_id => l_req_hdr_id,

Line 4955: po_reqchangerequestwf_pvt.submit_req_change(

4951: AND request_status = 'SYSTEMSAVE';
4952:
4953: IF (p_origin IS NULL AND l_workflow_needed = 'Y') THEN
4954:
4955: po_reqchangerequestwf_pvt.submit_req_change(
4956: p_api_version => 1.0,
4957: p_commit => fnd_api.g_false,
4958: x_return_status => l_wf_status,
4959: p_req_header_id => l_req_hdr_id,

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

5113: IF (p_req_line_id is null and p_req_header_id is not null ) then
5114: l_progress := '001';
5115:
5116:
5117: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_hdr_id => p_req_header_id);
5118:
5119: IF g_debug_stmt THEN
5120: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5121: END IF;

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

5138: , X_return_status =>x_return_status
5139: );
5140:
5141:
5142: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id);
5143:
5144: IF g_debug_stmt THEN
5145: po_debug.debug_var(l_log_head, l_progress, 'requisition l_orgid', l_orgid);
5146: END IF;

Line 5173: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org( p_req_line_id=> p_req_line_id);

5169: WHERE prl.requisition_line_id = p_req_line_id AND
5170: prh.requisition_header_id = prl.requisition_header_id ;
5171:
5172: l_progress := '002';
5173: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org( p_req_line_id=> p_req_line_id);
5174:
5175: IF g_debug_stmt THEN
5176: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5177: END IF;

Line 5198: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_line_id=> p_req_line_id );

5194: , X_return_status =>x_return_status
5195: );
5196:
5197:
5198: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_line_id=> p_req_line_id );
5199:
5200: IF g_debug_stmt THEN
5201: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
5202: END IF;

Line 5289: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_line_id => p_req_line_id);

5285: WHERE prl.requisition_line_id = p_req_line_id;
5286:
5287: l_progress := '001';
5288:
5289: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_line_id => p_req_line_id);
5290: IF g_debug_stmt THEN
5291: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
5292: END IF;
5293:

Line 5313: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org(p_req_line_id => p_req_line_id);

5309: , X_return_status =>x_return_status
5310: );
5311:
5312:
5313: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org(p_req_line_id => p_req_line_id);
5314: IF g_debug_stmt THEN
5315: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
5316: END IF;
5317:

Line 5925: po_reqchangerequestwf_pvt.submit_internal_req_change(

5921:
5922:
5923: IF (p_origin IS NULL AND l_workflow_needed = 'Y') THEN
5924:
5925: po_reqchangerequestwf_pvt.submit_internal_req_change(
5926: p_api_version => 1.0,
5927: p_commit => fnd_api.g_false,
5928: x_return_status => l_wf_status,
5929: p_req_header_id => l_req_hdr_id,

Line 6048: po_reqchangerequestwf_pvt.req_line_CANCEL(

6044: IF (p_req_line_id IS NOT NULL ) THEN
6045:
6046: IF p_req_cancel_all THEN
6047:
6048: po_reqchangerequestwf_pvt.req_line_CANCEL(
6049: p_req_line_id => p_req_line_id,
6050: x_return_status =>l_return_status);
6051: ELSE
6052:

Line 6079: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

6075: IF g_debug_stmt THEN
6076: po_debug.debug_var(l_log_head, l_progress, 'l_delta_quantity', l_delta_quantity);
6077: END IF;
6078:
6079: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
6080: p_req_line_id => p_req_line_id,
6081: p_delta_quantity=> l_delta_quantity,
6082: x_return_status =>l_return_status);
6083:

Line 6085: po_reqchangerequestwf_pvt.req_line_CANCEL(

6081: p_delta_quantity=> l_delta_quantity,
6082: x_return_status =>l_return_status);
6083:
6084: ELSE
6085: po_reqchangerequestwf_pvt.req_line_CANCEL(
6086: p_req_line_id => p_req_line_id,
6087: x_return_status =>l_return_status);
6088: END IF;
6089: END IF;

Line 6162: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

6158: -- both the tables
6159: IF p_req_line_id IS NOT NULL AND p_delta_quantity IS NOT NULL THEN
6160:
6161: BEGIN
6162: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
6163: p_req_line_id => p_req_line_id,
6164: p_delta_quantity=> p_delta_quantity,
6165: x_return_status =>l_return_status);
6166:

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

6180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
6181:
6182: IF ( l_sync_need_by = 'YES' ) THEN
6183:
6184: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,
6185: p_need_by_date=> p_new_need_by_date,
6186: x_return_status =>l_return_status);
6187:
6188: END IF;

Line 6766: po_reqchangerequestwf_pvt.submit_internal_req_change(

6762:
6763: --Kick Off Workflow
6764: x_retmsg := 'SMRCH009';
6765:
6766: po_reqchangerequestwf_pvt.submit_internal_req_change(
6767: p_api_version => 1.0,
6768: p_commit => fnd_api.g_false,
6769: p_req_header_id => l_req_hdr_id,
6770: p_note_to_approver => p_note_to_approver,

Line 6877: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_line_id =>p_req_line_id);

6873:
6874: l_progress :='001';
6875:
6876:
6877: l_orgid := PO_ReqChangeRequestWF_PVT.get_sales_order_org(p_req_line_id =>p_req_line_id);
6878:
6879: IF g_debug_stmt THEN
6880: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
6881: END IF;

Line 6907: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id,

6903: IF g_debug_stmt THEN
6904: po_debug.debug_stmt(l_log_head, l_progress, 'returning from OM API Validating the changes');
6905: END IF;
6906:
6907: l_orgid := PO_ReqChangeRequestWF_PVT.get_requisition_org( p_req_hdr_id => p_req_header_id,
6908: p_req_line_id =>p_req_line_id);
6909:
6910: IF g_debug_stmt THEN
6911: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);

Line 7029: po_reqchangerequestwf_pvt.req_line_CANCEL(

7025: IF (p_req_line_id IS NOT NULL ) THEN
7026:
7027: IF p_req_cancel_all THEN
7028:
7029: po_reqchangerequestwf_pvt.req_line_CANCEL(
7030: p_req_line_id => p_req_line_id,
7031: x_return_status =>l_return_status);
7032: ELSE
7033:

Line 7070: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

7066: po_debug.debug_var(l_log_head, l_progress, 'l_delta_prim_quantity', l_delta_prim_quantity);
7067: po_debug.debug_var(l_log_head, l_progress, 'l_delta_sec_quantity', l_delta_sec_quantity);
7068: END IF;
7069:
7070: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
7071: p_req_line_id => p_req_line_id,
7072: p_delta_prim_quantity=> l_delta_prim_quantity,
7073: p_delta_sec_quantity=> l_delta_sec_quantity,
7074: x_return_status =>l_return_status);

Line 7077: po_reqchangerequestwf_pvt.req_line_CANCEL(

7073: p_delta_sec_quantity=> l_delta_sec_quantity,
7074: x_return_status =>l_return_status);
7075:
7076: ELSE
7077: po_reqchangerequestwf_pvt.req_line_CANCEL(
7078: p_req_line_id => p_req_line_id,
7079: x_return_status =>l_return_status);
7080: END IF;
7081: END IF;

Line 7161: po_reqchangerequestwf_pvt.update_reqline_quan_changes(

7157: -- both the tables
7158: IF p_req_line_id IS NOT NULL AND (p_delta_quantity_prim IS NOT NULL OR p_delta_quantity_sec IS NOT NULL )THEN
7159:
7160: BEGIN
7161: po_reqchangerequestwf_pvt.update_reqline_quan_changes(
7162: p_req_line_id => p_req_line_id,
7163: p_delta_prim_quantity=> p_delta_quantity_prim,
7164: p_delta_sec_quantity=> p_delta_quantity_sec,
7165: x_return_status =>l_return_status);

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

7180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
7181:
7182: IF ( l_sync_need_by = 'YES' ) THEN
7183:
7184: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,
7185: p_need_by_date=> p_new_need_by_date,
7186: x_return_status =>l_return_status);
7187:
7188: END IF;