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 544: p_po_change_requests in out nocopy pos_chg_rec_tbl) is

540: procedure ValidateAndSaveRequest(
541: p_po_header_id in number,
542: p_po_release_id in number,
543: p_revision_num in number,
544: p_po_change_requests in out nocopy pos_chg_rec_tbl) is
545:
546: l_doc_check_rec_type Doc_Check_Return_Type;
547: l_pos_errors pos_err_type;
548: l_online_report_id number;

Line 1283: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();

1279: l_return_status varchar2(100);
1280: l_error_code varchar2(100);
1281: l_change_request_group_id number;
1282: temp number;
1283: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();
1284:
1285:
1286: ll_document_header_id number;
1287: ll_document_type varchar2(30);

Line 1416: my_chg_rec_tbl := pos_chg_rec_tbl();

1412:
1413: x_progress :='008';
1414: open l_pending_change_csr(p_change_request_group_id);
1415: temp:=1;
1416: my_chg_rec_tbl := pos_chg_rec_tbl();
1417:
1418: loop
1419: fetch l_pending_change_csr into
1420: l_document_header_id,

Line 1451: my_chg_rec_tbl(temp) := pos_chg_rec(

1447: l_parent_change_request_id;
1448: exit when l_pending_change_csr%NOTFOUND;
1449:
1450: my_chg_rec_tbl.extend;
1451: my_chg_rec_tbl(temp) := pos_chg_rec(
1452: Action_Type =>l_action_type,
1453: Initiator =>'REQUESTER',
1454: Request_Reason =>l_request_reason,
1455: Document_Type =>l_document_type,

Line 3100: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();

3096: )
3097: order by document_header_id, po_release_id, document_line_id,
3098: document_line_location_id, document_distribution_id;
3099:
3100: my_chg_rec_tbl pos_chg_rec_tbl := pos_chg_rec_tbl();
3101:
3102: l_SHIP_TO_ORGANIZATION_ID number;
3103: l_SHIP_TO_LOCATION_ID number;
3104: temp number;

Line 3214: my_chg_rec_tbl(temp) := pos_chg_rec(

3210: -- add a new shipment quantity change
3211: -- figure out whether we need set the old price
3212: -- use the l_new_ship_quantity and need_by_date from po_ship
3213: my_chg_rec_tbl.extend;
3214: my_chg_rec_tbl(temp) := pos_chg_rec(
3215: Action_Type =>'MODIFICATION',
3216: Initiator =>'REQUESTER',
3217: Request_Reason =>my_chg_rec_tbl(temp-1).Request_reason,
3218: Document_Type =>my_chg_rec_tbl(temp-1).document_type,

Line 3320: my_chg_rec_tbl := pos_chg_rec_tbl();

3316: p_revision_num =>l_document_revision_num,
3317: p_po_change_requests =>my_chg_rec_tbl);
3318:
3319: temp:=1;
3320: my_chg_rec_tbl := pos_chg_rec_tbl();
3321: l_current_header_id:=l_document_header_id;
3322: l_current_release_id:=l_po_release_id;
3323: end if;
3324:

Line 3329: my_chg_rec_tbl(temp) := pos_chg_rec(

3325: l_current_ship_id:=l_document_line_location_id;
3326: l_current_matching_basis :=l_matching_basis;
3327: my_chg_rec_tbl.extend;
3328:
3329: my_chg_rec_tbl(temp) := pos_chg_rec(
3330: Action_Type =>l_action_type,
3331: Initiator =>'REQUESTER',
3332: Request_Reason =>l_request_reason,
3333: Document_Type =>l_document_type,

Line 3406: my_chg_rec_tbl(temp) := pos_chg_rec(

3402: l_new_ship_amount:= null;
3403: end if;
3404:
3405: my_chg_rec_tbl.extend;
3406: my_chg_rec_tbl(temp) := pos_chg_rec(
3407: Action_Type =>'MODIFICATION',
3408: Initiator =>'REQUESTER',
3409: Request_Reason =>my_chg_rec_tbl(temp-1).Request_reason,
3410: Document_Type =>my_chg_rec_tbl(temp-1).document_type,