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_AUTO_LINE_LOC_PROCESS_PVT dependencies on STANDARD

Line 226: IF (p_lines.from_line_id_tbl(i) IS NOT NULL) AND (po_autocreate_params.g_document_subtype = 'STANDARD') THEN

222: p_message => 'from line id :'||p_lines.from_line_id_tbl(i)||'from header id:'||p_lines.from_header_id_tbl(i));
223: END IF;
224:
225: l_progress :='030';
226: IF (p_lines.from_line_id_tbl(i) IS NOT NULL) AND (po_autocreate_params.g_document_subtype = 'STANDARD') THEN
227: l_progress := '040';
228:
229: BEGIN
230: SELECT poh.type_lookup_code

Line 261: IF ((po_autocreate_params.g_document_subtype='STANDARD') AND (p_lines.from_line_id_tbl(i) IS NOT NULL)) THEN

257: END IF;
258:
259: IF (NVL(x_uom_convert,'N') = 'Y') THEN
260: -- Convert UOM when autocreating a PO that references a GA
261: IF ((po_autocreate_params.g_document_subtype='STANDARD') AND (p_lines.from_line_id_tbl(i) IS NOT NULL)) THEN
262: /* Get the uom from the PO . This will be used for uom conversion */
263: BEGIN
264: --Autocreating a PO that references a GA
265: l_progress := '050';

Line 320: IF(po_autocreate_params.g_document_subtype='STANDARD' OR po_autocreate_params.g_document_subtype='PLANNED' )THEN

316: */
317:
318: x_ship_to_location_id := po_autocreate_mainproc_pvt.get_ship_to_loc(p_lines.deliver_to_loc_id_tbl(i)); -- FPI
319:
320: IF(po_autocreate_params.g_document_subtype='STANDARD' OR po_autocreate_params.g_document_subtype='PLANNED' )THEN
321: l_progress := '070';
322:
323: BEGIN
324: SELECT poll.line_location_id,

Line 335: AND poll.shipment_type IN ('STANDARD','PLANNED', 'RFQ')

331: AND pol.draft_id =po_autocreate_params.g_draft_id
332: AND poll.po_line_id = p_lines.po_line_id_tbl(i)
333: AND poll.shipment_num = p_lines.shipment_num_tbl(i)
334: AND pol.line_num = p_lines.line_num_tbl(i)
335: AND poll.shipment_type IN ('STANDARD','PLANNED', 'RFQ')
336: --
337: AND pol.po_line_id = poll.po_line_id
338: AND pol.draft_id = poll.draft_id;
339: --

Line 1259: -- this payitem has a shipment_type of STANDARD and payment_type of DELIVERY

1255: IF(l_isFinancing) THEN
1256:
1257: d_progress := 70;
1258: -- if financing case, create actual delivery payitem
1259: -- this payitem has a shipment_type of STANDARD and payment_type of DELIVERY
1260: --SQL WHAT: Insert information for delivery payitem into
1261: -- po_line_locations_interface table
1262: --SQL WHY : We will use line_locations_interface as a
1263: -- common entry point for payitems, including ones we create

Line 1290: 'STANDARD' ,

1286: l_line_quantity ,
1287: l_line_amount ,
1288: l_line_unit_price ,
1289: 'DELIVERY' ,
1290: 'STANDARD' ,
1291: p_lines.item_desc_tbl(i) ,
1292: 1 ,
1293: p_lines.need_by_date_tbl(i) ,
1294: p_lines.promised_date_tbl(i)

Line 1363: l_shipment_type := 'STANDARD';

1359:
1360: IF(l_isFinancing) THEN
1361: l_shipment_type := 'PREPAYMENT';
1362: ELSE
1363: l_shipment_type := 'STANDARD';
1364: END IF;
1365:
1366: d_progress := 110;
1367: --SQL WHAT: Default/update values for scratch payitems in interface table

Line 1717: IF (PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET')) THEN

1713: SELECT PO_LINE_LOCATIONS_S.currval
1714: INTO x_line_location_id
1715: FROM sys.dual;
1716:
1717: IF (PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET')) THEN
1718: d_progress := 250;
1719: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'SHIPMENT', x_line_location_id);
1720: END IF;
1721:

Line 1731: -- set x_line_location_id to id of first actual (STANDARD) payitem

1727: l_payitem_tax_code_id_tbl.EXTEND;
1728: l_payitem_tax_code_id_tbl(l_payitems_created) := l_tax_code_id;
1729: p_lines.line_loc_id_tbl(i) := l_line_loc_id;
1730:
1731: -- set x_line_location_id to id of first actual (STANDARD) payitem
1732: IF ((x_line_location_id IS NULL) AND (line_location_rec.shipment_type = 'STANDARD')) THEN
1733: x_line_location_id := l_line_loc_id;
1734: END IF;
1735:

Line 1732: IF ((x_line_location_id IS NULL) AND (line_location_rec.shipment_type = 'STANDARD')) THEN

1728: l_payitem_tax_code_id_tbl(l_payitems_created) := l_tax_code_id;
1729: p_lines.line_loc_id_tbl(i) := l_line_loc_id;
1730:
1731: -- set x_line_location_id to id of first actual (STANDARD) payitem
1732: IF ((x_line_location_id IS NULL) AND (line_location_rec.shipment_type = 'STANDARD')) THEN
1733: x_line_location_id := l_line_loc_id;
1734: END IF;
1735:
1736: END LOOP; -- poll_interface_cursor loop

Line 1820: -- Standard start of API savepoint

1816: l_progress := '020';
1817: l_outsourced_assembly := po_core_s.get_outsourced_assembly(p_lines.item_id_tbl(i), p_lines.dest_organization_id_tbl(i));
1818: END IF;
1819:
1820: -- Standard start of API savepoint
1821: SAVEPOINT create_price_break_pvt;
1822:
1823: IF g_debug_stmt THEN
1824: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

Line 1876: IF p_lines.Shipment_Type_tbl(i) IN ('STANDARD', 'PLANNED', 'BLANKET', 'SCHEDULED') THEN

1872:
1873: l_progress := '070';
1874: --
1875: --
1876: IF p_lines.Shipment_Type_tbl(i) IN ('STANDARD', 'PLANNED', 'BLANKET', 'SCHEDULED') THEN
1877: l_tax_attribute_update_code := 'CREATE';
1878: END IF;
1879:
1880: BEGIN