DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on POS_CHG_REC_TBL

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 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 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: