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 PO_LINE_LOCATIONS_INTERFACE

Line 1036: -- Create all payitems for a PO Line. If PO_LINE_LOCATIONS_INTERFACE is

1032: -- PO_LINE_LOCATIONS_DRAFT
1033: --Locks:
1034: -- None.
1035: --Function:
1036: -- Create all payitems for a PO Line. If PO_LINE_LOCATIONS_INTERFACE is
1037: -- populated, use that information. Otherwise, create a default
1038: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
1039: --Parameters:
1040: -- IN OUT: p_lines Lines data

Line 1112: FROM po_line_locations_interface polli

1108: polli.description,
1109: polli.work_approver_id,
1110: polli.bid_payment_id,
1111: polli.unit_of_measure
1112: FROM po_line_locations_interface polli
1113: WHERE polli.interface_line_id = p_interface_line_id
1114: ORDER BY polli.shipment_num;
1115:
1116: line_location_rec poll_interface_cursor%ROWTYPE;

Line 1218: -- po_line_locations interface table

1214:
1215: d_progress := 60;
1216:
1217: --SQL WHAT: Insert information for default payitem into
1218: -- po_line_locations interface table
1219: --SQL WHY : We will use line_locations_interface as a
1220: -- common entry point for payitems - whether they come from
1221: -- sourcing or we default them from scratch here.
1222: INSERT

Line 1223: INTO po_line_locations_interface

1219: --SQL WHY : We will use line_locations_interface as a
1220: -- common entry point for payitems - whether they come from
1221: -- sourcing or we default them from scratch here.
1222: INSERT
1223: INTO po_line_locations_interface
1224: (
1225: interface_line_location_id ,
1226: interface_header_id ,
1227: interface_line_id ,

Line 1239: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,

1235: promised_date
1236: )
1237: VALUES
1238: (
1239: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,
1240: p_lines.intf_header_id_tbl(i) ,
1241: p_lines.intf_line_id_tbl(i) ,
1242: l_payitem_quantity ,
1243: l_payitem_amount ,

Line 1261: -- po_line_locations_interface table

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
1264: -- behind the scenes
1265: INSERT

Line 1266: INTO po_line_locations_interface

1262: --SQL WHY : We will use line_locations_interface as a
1263: -- common entry point for payitems, including ones we create
1264: -- behind the scenes
1265: INSERT
1266: INTO po_line_locations_interface
1267: (
1268: interface_line_location_id ,
1269: interface_header_id ,
1270: interface_line_id ,

Line 1283: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,

1279: promised_date
1280: )
1281: VALUES
1282: (
1283: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,
1284: p_lines.intf_header_id_tbl(i) ,
1285: p_lines.intf_line_id_tbl(i) ,
1286: l_line_quantity ,
1287: l_line_amount ,

Line 1316: -- po_line_locations_interface table

1312:
1313: l_advance_desc := substrb(FND_MESSAGE.get, 1, 240);
1314:
1315: --SQL WHAT: Insert information for advance payitem into
1316: -- po_line_locations_interface table
1317: --SQL WHY : We will use line_locations_interface as a
1318: -- common entry point for payitems, including ones we create
1319: -- behind the scenes
1320: INSERT

Line 1321: INTO po_line_locations_interface

1317: --SQL WHY : We will use line_locations_interface as a
1318: -- common entry point for payitems, including ones we create
1319: -- behind the scenes
1320: INSERT
1321: INTO po_line_locations_interface
1322: (
1323: interface_line_location_id ,
1324: interface_header_id ,
1325: interface_line_id ,

Line 1337: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,

1333: need_by_date
1334: )
1335: VALUES
1336: (
1337: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL ,
1338: p_lines.intf_header_id_tbl(i) ,
1339: p_lines.intf_line_id_tbl(i) ,
1340: NULL ,
1341: p_lines.advance_amount_tbl(i) ,

Line 1370: UPDATE po_line_locations_interface polli

1366: d_progress := 110;
1367: --SQL WHAT: Default/update values for scratch payitems in interface table
1368: --SQL WHY : This allows us to update all new payitems' values at once,
1369: -- including payitems from sourcing or ones we've created in autocreate
1370: UPDATE po_line_locations_interface polli
1371: SET polli.value_basis = DECODE(polli.payment_type,
1372: 'RATE', 'QUANTITY',
1373: 'LUMPSUM', 'FIXED PRICE',
1374: 'MILESTONE', l_line_value_basis,

Line 1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface

1462: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
1463: END IF;
1464:
1465: -- insert payitem into po_line_locations_all
1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
1467: --SQL WHY : This allows us to insert all payitems in one location.
1468: INSERT
1469: INTO po_line_locations_draft_all
1470: (

Line 1707: UPDATE po_line_locations_interface polli

1703:
1704: d_progress := 230;
1705:
1706: -- create link between interface row and transaction row
1707: UPDATE po_line_locations_interface polli
1708: SET polli.line_location_id = l_line_loc_id
1709: WHERE polli.interface_line_location_id = line_location_rec.interface_line_location_id;
1710:
1711: d_progress := 240;