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