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_MODIFY_REQUISITION_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 23: * inserts records into po_requisition_lines_all and po_req_distributions_all table.

19: * req lines, update requisition_lines table to modified_by_agent_flag = 'Y' .
20: * Also sets prevent encumbrace flag to 'Y' in the po_req_distributions table.
21: * Effects: This api split the requisition lines, into two lines with specified quantity.
22: * This api uses a global temp.table to process the input given by autocreate(HTML) and
23: * inserts records into po_requisition_lines_all and po_req_distributions_all table.
24: * This api also handles the encumbrace effect of splitting requisition lines. This
25: * api would be called from Autocreate HTML.
26: *
27: * Returns:

Line 40: * 4. Using a for loop insert two records into the po_requisition_lines_all

36: * 2. Retrieve the quantity on the given line and split using
37: * split function.
38: * 3. Calculate the maximum line number of the lines that
39: * belong to the given requisition.
40: * 4. Using a for loop insert two records into the po_requisition_lines_all
41: * table and provide the correct line number by incrementing
42: * max line number by one in each iteration.
43: * 5. Update the split req line and set the modified flag
44: * and purchasing agent flag.

Line 275: FROM po_requisition_lines_all prl

271: -- locked till the transaction control happens.
272: CURSOR lock_req_lines_cs IS
273: SELECT prl.requisition_line_id,
274: prl.org_id
275: FROM po_requisition_lines_all prl
276: WHERE prl.requisition_line_id = p_req_line_id
277: FOR UPDATE OF prl.quantity NOWAIT;
278:
279: l_serial_num NUMBER;

Line 356: FROM po_requisition_lines_all prl

352: -- the new requisition lines
353:
354: SELECT MAX(prl.line_num)
355: INTO l_max_line_num
356: FROM po_requisition_lines_all prl
357: WHERE prl.requisition_header_id =
358: (SELECT requisition_header_id
359: FROM po_requisition_lines_all
360: WHERE requisition_line_id = p_req_Line_id);

Line 359: FROM po_requisition_lines_all

355: INTO l_max_line_num
356: FROM po_requisition_lines_all prl
357: WHERE prl.requisition_header_id =
358: (SELECT requisition_header_id
359: FROM po_requisition_lines_all
360: WHERE requisition_line_id = p_req_Line_id);
361:
362: IF PO_LOG.d_stmt THEN
363: PO_LOG.stmt(d_module_base,d_progress,'l_max_line_num',l_max_line_num);

Line 392: INSERT INTO po_requisition_lines_all

388: PO_LOG.stmt(d_module_base,d_progress,'l_serial_num',l_serial_num);
389: END IF;
390:
391:
392: INSERT INTO po_requisition_lines_all
393: (requisition_line_id,
394: requisition_header_id,
395: line_num,
396: line_type_id,

Line 663: FROM po_requisition_lines_all prl

659: prl.pcard_flag,
660: prl.new_supplier_flag,
661: prl.auto_receive_flag,
662: g_TAX_ATTRIBUTE_CREATE
663: FROM po_requisition_lines_all prl
664: WHERE prl.requisition_line_id = p_req_line_id);
665:
666: END LOOP;
667:

Line 689: UPDATE po_requisition_lines_all

685: -- If the original requisition line has a value for On RFQ flag
686: -- the On RFQ flag from the original requisition line should be
687: -- dropped.
688:
689: UPDATE po_requisition_lines_all
690: SET modified_by_agent_flag = 'Y',
691: purchasing_agent_id = p_agent_id,
692: reqs_in_pool_flag = NULL, --
693: on_rfq_flag = decode(p_calling_program,

Line 729: FROM PO_REQUISITION_LINES_ALL PRL1, PO_REQUISITION_LINES_ALL PRL2

725: --Performance fix for bug 4930487
726: SELECT PRL1.requisition_line_id
727: BULK COLLECT
728: INTO new_req_line_id_rslt_tbl
729: FROM PO_REQUISITION_LINES_ALL PRL1, PO_REQUISITION_LINES_ALL PRL2
730: WHERE PRL1.requisition_header_id = PRL2.requisition_header_id
731: AND PRL1.parent_req_line_id = p_req_line_id
732: AND PRL2.requisition_line_id = p_req_line_id;
733:

Line 882: FROM po_requisition_lines_all PRL1, po_requisition_lines_all PRL2

878: -- Performance fix for bug 4930487
879: SELECT PRL1.quantity
880: BULK COLLECT
881: INTO l_quantity_table
882: FROM po_requisition_lines_all PRL1, po_requisition_lines_all PRL2
883: WHERE PRL1.requisition_header_id = PRL2.requisition_header_id
884: AND PRL1.parent_req_line_id = p_req_line_id
885: AND PRL2.requisition_line_id = p_req_line_id;
886:

Line 933: from po_requisition_lines_all

929: d_progress := 60;
930: --Retrieve the value of l_requisition_header_id first
931: select requisition_header_id
932: into l_requisition_header_id
933: from po_requisition_lines_all
934: where requisition_line_id = p_req_line_id;
935:
936: IF PO_LOG.d_stmt THEN
937: PO_LOG.stmt(d_module_base,d_progress,'l_requisition_header_id',l_requisition_header_id);

Line 990: FROM PO_REQUISITION_LINES_ALL

986: THEN
987: begin
988: SELECT ENCUMBERED_FLAG
989: INTO l_req_encumbered_flag
990: FROM PO_REQUISITION_LINES_ALL
991: WHERE requisition_line_id = p_req_line_id;
992: exception
993: when others then
994: l_req_encumbered_flag :='N';

Line 1190: -- Prevented FTS on po_requisition_lines_all by adding an exists clause

1186: PO_LOG.stmt(d_module_base,d_progress,'Inserting values into po_req_split_lines_gt');
1187: END IF;
1188:
1189: -- Performance fix for bug 4930487
1190: -- Prevented FTS on po_requisition_lines_all by adding an exists clause
1191: INSERT INTO po_req_split_lines_gt
1192: (requisition_header_id,
1193: requisition_line_id,
1194: allocated_qty,

Line 1210: FROM po_requisition_lines_all PRL1

1206: WHERE (prl.requisition_line_id = p_req_line_id OR
1207: prl.parent_req_line_id = p_req_line_id)
1208: AND EXISTS(
1209: SELECT requisition_header_id
1210: FROM po_requisition_lines_all PRL1
1211: WHERE PRL1.requisition_header_id = prl.requisition_header_id
1212: AND PRL1.requisition_line_id = p_req_line_id);
1213:
1214: