eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 119: * po_requisition_lines_all and po_req_distributions_all table. This api also

115: * Also sets prevent encumbrace flag to 'Y' in the po_req_distributions table.
116: * Effects: This api split the requisition lines, if needed, depending on the
117: * allocation done by the sourcing user. This api uses a global temp. table
118: * to massage the input given by sourcing and inserts records into
119: * po_requisition_lines_all and po_req_distributions_all table. This api also
120: * handles the encumbrace effect of splitting requisition lines. This api would
121: * be called from ORacle sourcing workflow.
122: *
123: * Returns:

Line 203: FROM po_requisition_lines_all prl, --

199: -- transactions.Opening the cursor keeps the records locked till the
200: -- transaction control happens.
201: CURSOR LockReqLines_Cursor IS
202: SELECT prl.requisition_line_id,quantity
203: FROM po_requisition_lines_all prl, --
204: po_req_split_lines_gt prs
205: WHERE prl.requisition_line_id = prs.requisition_line_id
206: FOR UPDATE OF prl.quantity NOWAIT;
207:

Line 217: l_old_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

213: --
214: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
215:
216: -- Define variables needed for context switching
217: l_old_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
218: l_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
219: l_current_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
220: l_org_context_changed VARCHAR2(1) := 'N';
221:

Line 218: l_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

214: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
215:
216: -- Define variables needed for context switching
217: l_old_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
218: l_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
219: l_current_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
220: l_org_context_changed VARCHAR2(1) := 'N';
221:
222: -- bug 5249299

Line 219: l_current_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

215:
216: -- Define variables needed for context switching
217: l_old_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
218: l_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
219: l_current_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
220: l_org_context_changed VARCHAR2(1) := 'N';
221:
222: -- bug 5249299
223: l_project_id po_req_distributions_all.project_id%TYPE;

Line 322: FROM po_requisition_lines_all prl --

318: (SELECT quantity,
319: --decode(cancel_flag,'Y','C',null)
320: decode(cancel_flag,'Y','C',decode(closed_code,'FINALLY CLOSED',
321: 'C',NULL))
322: FROM po_requisition_lines_all prl --
323: WHERE prl.requisition_line_id=prs.requisition_line_id
324: );
325:
326: l_progress :='031';

Line 375: FROM po_requisition_lines_all prl --

371: UPDATE po_req_split_lines_gt prs
372: SET prs.record_status='C'
373: WHERE NOT EXISTS
374: (SELECT requisition_line_id
375: FROM po_requisition_lines_all prl --
376: WHERE prl.requisition_line_id= prs.requisition_line_id
377: );
378:
379: l_progress :='036';

Line 424: FROM po_requisition_lines_all PRL

420: UPDATE po_req_split_lines_gt PRS
421: SET ( PRS.record_status
422: , PRS.new_req_line_id ) = ( SELECT 'T'
423: , PRL.requisition_line_id
424: FROM po_requisition_lines_all PRL
425: , po_line_types_b PLT
426: WHERE PRL.requisition_line_id = PRS.requisition_line_id
427: AND PRL.line_type_id = PLT.line_type_id
428: AND PLT.order_type_lookup_code IN ('RATE','FIXED PRICE')

Line 476: FROM po_requisition_lines_all PRL

472: UPDATE po_req_split_lines_gt PRS
473: SET ( PRS.record_status
474: , PRS.new_req_line_id ) = ( SELECT 'T'
475: , PRL.requisition_line_id
476: FROM po_requisition_lines_all PRL
477: , po_requisition_headers_all PRH
478: WHERE PRL.requisition_line_id = PRS.requisition_line_id
479: AND PRH.requisition_header_id = PRS.requisition_header_id
480: AND Nvl(PRH.FEDERAL_FLAG,'N') = 'Y'

Line 634: -- in the po_requisition_lines_all table.

630:
631: -- SQL What: Make entry for the new remainder req lines in the temp table
632: -- ( which are not consumed or Services Lines )
633: -- SQL Why : These rows stand for the remainder req lines to be created
634: -- in the po_requisition_lines_all table.
635: --
636: -- For Amount based lines, new req line should be created only if profile
637: -- PO_RECRT_POST_AWRD_AMT_REQ_BAL value is Y.
638: -- Added join conditions with tables po_requisition_lines_all and

Line 638: -- Added join conditions with tables po_requisition_lines_all and

634: -- in the po_requisition_lines_all table.
635: --
636: -- For Amount based lines, new req line should be created only if profile
637: -- PO_RECRT_POST_AWRD_AMT_REQ_BAL value is Y.
638: -- Added join conditions with tables po_requisition_lines_all and
639: -- po_line_types_b.
640: INSERT INTO po_req_split_lines_gt
641: ( auction_header_id,
642: bid_number,

Line 665: po_requisition_lines_all prl,

661: prsl.requisition_line_qty,
662: NULL,
663: 'N'
664: FROM po_req_split_lines_gt prsl,
665: po_requisition_lines_all prl,
666: po_line_types_b plt
667: WHERE prsl.total_alloc_req_line_qty < prsl.requisition_line_qty
668: AND prsl.record_status NOT IN ('I','T') --
669: AND prsl.bid_number = prsl.min_bid_number

Line 708: -- SQL What:update the po_requisition_lines_all table to stamp bid info for

704: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
705: 'before stamping bid info for equal allocation ');
706: END IF;
707:
708: -- SQL What:update the po_requisition_lines_all table to stamp bid info for
709: -- lines with Equal allocation (include Services Lines)
710: -- SQL Why :We need this update only for equal award. For other cases
711: -- we pass in the bid info through the insert statement.
712: UPDATE po_requisition_lines_all prl --

Line 712: UPDATE po_requisition_lines_all prl --

708: -- SQL What:update the po_requisition_lines_all table to stamp bid info for
709: -- lines with Equal allocation (include Services Lines)
710: -- SQL Why :We need this update only for equal award. For other cases
711: -- we pass in the bid info through the insert statement.
712: UPDATE po_requisition_lines_all prl --
713: SET (bid_number,
714: bid_line_number)=
715: (SELECT prs.bid_number,
716: prs.bid_line_number

Line 766: FROM po_requisition_lines_all prl --

762: -- the new requisition lines
763: UPDATE po_req_split_lines_gt prs
764: SET prs.new_line_num=
765: (SELECT max(prl.line_num)
766: FROM po_requisition_lines_all prl --
767: WHERE prl.requisition_header_id=prs.requisition_header_id)
768: WHERE prs.record_status in ('S','N');
769:
770: l_progress :='081';

Line 993: po_requisition_lines_all prl, --

989: min_bid_number_rslt_tbl,
990: record_status_rslt_tbl,
991: encumbrance_flag_rslt_tbl -- Bug 4723367
992: FROM po_req_split_lines_gt prs,
993: po_requisition_lines_all prl, --
994: financials_system_parameters fsp -- Bug 4723367
995: -- Bug 5467617: Removed the joins to PO_VENDORS and PO_VENDOR_SITES_ALL
996: -- These are not required anymore because they we used to fetch the
997: -- rounding rule from the site level. Now the tax rounding is done by

Line 1042: INSERT INTO po_requisition_lines_all --

1038: END IF;
1039:
1040: FORALL l_insert_line_index IN
1041: 1.. requisition_line_id_rslt_tbl.COUNT
1042: INSERT INTO po_requisition_lines_all --
1043: (
1044: requisition_line_id,
1045: requisition_header_id,
1046: line_num,

Line 1284: FROM po_requisition_lines_all prl --

1280: prl.purchase_basis,
1281: prl.matching_basis,
1282: prl.org_id, --
1283: 'CREATE' --
1284: FROM po_requisition_lines_all prl --
1285: WHERE prl.requisition_line_id=
1286: requisition_line_id_rslt_tbl(l_insert_line_index);
1287:
1288: l_progress :='131';

Line 1330: UPDATE po_requisition_lines_all --

1326:
1327: -- : added update of reqs_in_pool_flag and of
1328: -- WHO columns.
1329: FORALL l_mod_buyer_index in 1.. requisition_line_id_rslt_tbl.COUNT
1330: UPDATE po_requisition_lines_all --
1331: SET modified_by_agent_flag = 'Y',
1332: reqs_in_pool_flag = NULL, --
1333: last_update_date = SYSDATE,
1334: last_updated_by = FND_GLOBAL.USER_ID,

Line 1441: FROM po_requisition_lines_all prl, --

1437: null,
1438: prl.unit_meas_lookup_code,
1439: decode(prl.item_id, null, null, prl.need_by_date + nvl(msi.postprocessing_lead_time,0)),
1440: DECODE(PO_CLM_INTG_GRP.IS_CLM_DOCUMENT('REQUISITION',prl.Requisition_header_id),'Y','Y','N',NULL,NULL) --
1441: FROM po_requisition_lines_all prl, --
1442: mtl_system_items msi
1443: WHERE prl.requisition_line_id =
1444: new_req_line_id_rslt_tbl(l_update_mtl_supply_index)
1445: AND prl.destination_organization_id = msi.organization_id(+)

Line 1573: FROM po_requisition_lines_all

1569: -- SQL Why: Need to set org context to the OU where the
1570: -- requisition line is raised
1571: SELECT nvl(org_id, -99)
1572: INTO l_line_requesting_ou_id
1573: FROM po_requisition_lines_all
1574: WHERE requisition_line_id = requisition_line_id_rslt_tbl(l_create_dist_index);
1575:
1576: IF l_line_requesting_ou_id <> l_old_line_requesting_ou_id THEN
1577: PO_MOAC_UTILS_PVT.set_org_context(l_line_requesting_ou_id) ; --