APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on POS_CHG_REC

Line 236: p_po_change_requests in out nocopy pos_chg_rec_tbl);

232: procedure ValidateAndSaveRequest(
233: p_po_header_id in number,
234: p_po_release_id in number,
235: p_revision_num in number,
236: p_po_change_requests in out nocopy pos_chg_rec_tbl);
237:
238: /*************************************************************************
239: * Private Procedure: UpdateReqLine
240: * Effects: update the need by date and/or price of a requisition line

Line 561: p_po_change_requests in out nocopy pos_chg_rec_tbl) is

557: procedure ValidateAndSaveRequest(
558: p_po_header_id in number,
559: p_po_release_id in number,
560: p_revision_num in number,
561: p_po_change_requests in out nocopy pos_chg_rec_tbl) is
562:
563: l_doc_check_rec_type Doc_Check_Return_Type;
564: l_pos_errors pos_err_type;
565: l_online_report_id number;

Line 1300: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();

1296: l_return_status varchar2(100);
1297: l_error_code varchar2(100);
1298: l_change_request_group_id number;
1299: temp number;
1300: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();
1301:
1302:
1303: ll_document_header_id number;
1304: ll_document_type varchar2(30);

Line 1433: my_chg_rec_tbl := pos_chg_rec_tbl();

1429:
1430: x_progress :='008';
1431: open l_pending_change_csr(p_change_request_group_id);
1432: temp:=1;
1433: my_chg_rec_tbl := pos_chg_rec_tbl();
1434:
1435: loop
1436: fetch l_pending_change_csr into
1437: l_document_header_id,

Line 1468: my_chg_rec_tbl(temp) := pos_chg_rec(

1464: l_parent_change_request_id;
1465: exit when l_pending_change_csr%NOTFOUND;
1466:
1467: my_chg_rec_tbl.extend;
1468: my_chg_rec_tbl(temp) := pos_chg_rec(
1469: Action_Type =>l_action_type,
1470: Initiator =>'REQUESTER',
1471: Request_Reason =>l_request_reason,
1472: Document_Type =>l_document_type,

Line 3231: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();

3227: )
3228: order by document_header_id, po_release_id, document_line_id,
3229: document_line_location_id, document_distribution_id;
3230:
3231: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();
3232:
3233: l_SHIP_TO_ORGANIZATION_ID number;
3234: l_SHIP_TO_LOCATION_ID number;
3235: temp number;

Line 3345: my_chg_rec_tbl(temp) := pos_chg_rec(

3341: -- add a new shipment quantity change
3342: -- figure out whether we need set the old price
3343: -- use the l_new_ship_quantity and need_by_date from po_ship
3344: my_chg_rec_tbl.extend;
3345: my_chg_rec_tbl(temp) := pos_chg_rec(
3346: Action_Type =>'MODIFICATION',
3347: Initiator =>'REQUESTER',
3348: Request_Reason =>my_chg_rec_tbl(temp-1).Request_reason,
3349: Document_Type =>my_chg_rec_tbl(temp-1).document_type,

Line 3451: my_chg_rec_tbl := pos_chg_rec_tbl();

3447: p_revision_num =>l_document_revision_num,
3448: p_po_change_requests =>my_chg_rec_tbl);
3449:
3450: temp:=1;
3451: my_chg_rec_tbl := pos_chg_rec_tbl();
3452: l_current_header_id:=l_document_header_id;
3453: l_current_release_id:=l_po_release_id;
3454: end if;
3455:

Line 3460: my_chg_rec_tbl(temp) := pos_chg_rec(

3456: l_current_ship_id:=l_document_line_location_id;
3457: l_current_matching_basis :=l_matching_basis;
3458: my_chg_rec_tbl.extend;
3459:
3460: my_chg_rec_tbl(temp) := pos_chg_rec(
3461: Action_Type =>l_action_type,
3462: Initiator =>'REQUESTER',
3463: Request_Reason =>l_request_reason,
3464: Document_Type =>l_document_type,

Line 3537: my_chg_rec_tbl(temp) := pos_chg_rec(

3533: l_new_ship_amount:= null;
3534: end if;
3535:
3536: my_chg_rec_tbl.extend;
3537: my_chg_rec_tbl(temp) := pos_chg_rec(
3538: Action_Type =>'MODIFICATION',
3539: Initiator =>'REQUESTER',
3540: Request_Reason =>my_chg_rec_tbl(temp-1).Request_reason,
3541: Document_Type =>my_chg_rec_tbl(temp-1).document_type,