APPS.PO_INTERFACE_S dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 9834: DELETE po_line_locations_interface

9830: WHERE interface_header_id = x_interface_header_id;
9831: --
9832:
9833: --
9834: DELETE po_line_locations_interface
9835: WHERE interface_header_id = x_interface_header_id;
9836: --
9837:
9838: DELETE po_lines_interface

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

13973: -- PO_LINE_LOCATIONS_ALL
13974: --Locks:
13975: -- None.
13976: --Function:
13977: -- Create all payitems for a PO Line. If PO_LINE_LOCATIONS_INTERFACE is
13978: -- populated, use that information. Otherwise, create a default
13979: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
13980: --Parameters:
13981: -- IN:

Line 14074: FROM po_line_locations_interface polli

14070: polli.description,
14071: polli.work_approver_id,
14072: polli.bid_payment_id,
14073: polli.unit_of_measure
14074: FROM po_line_locations_interface polli
14075: WHERE polli.interface_line_id = p_interface_line_id
14076: ORDER BY polli.shipment_num;
14077:
14078: line_location_rec poll_interface_cursor%ROWTYPE;

Line 14147: -- po_line_locations interface table

14143:
14144: d_progress := 50;
14145:
14146: --SQL WHAT: Insert information for default payitem into
14147: -- po_line_locations interface table
14148: --SQL WHY : We will use line_locations_interface as a
14149: -- common entry point for payitems - whether they come from
14150: -- sourcing or we default them from scratch here.
14151:

Line 14152: INSERT INTO po_line_locations_interface

14148: --SQL WHY : We will use line_locations_interface as a
14149: -- common entry point for payitems - whether they come from
14150: -- sourcing or we default them from scratch here.
14151:
14152: INSERT INTO po_line_locations_interface
14153: (
14154: interface_line_location_id
14155: , interface_header_id
14156: , interface_line_id

Line 14167: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL

14163: , need_by_date
14164: )
14165: VALUES
14166: (
14167: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
14168: , interface.interface_header_id
14169: , p_interface_line_id
14170: , l_payitem_quantity
14171: , l_payitem_amount

Line 14191: -- po_line_locations_interface table

14187: -- if financing case, create actual delivery payitem
14188: -- this payitem has a shipment_type of STANDARD and payment_type of DELIVERY
14189:
14190: --SQL WHAT: Insert information for delivery payitem into
14191: -- po_line_locations_interface table
14192: --SQL WHY : We will use line_locations_interface as a
14193: -- common entry point for payitems, including ones we create
14194: -- behind the scenes
14195:

Line 14196: INSERT INTO po_line_locations_interface

14192: --SQL WHY : We will use line_locations_interface as a
14193: -- common entry point for payitems, including ones we create
14194: -- behind the scenes
14195:
14196: INSERT INTO po_line_locations_interface
14197: (
14198: interface_line_location_id
14199: , interface_header_id
14200: , interface_line_id

Line 14213: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL

14209: , promised_date
14210: )
14211: VALUES
14212: (
14213: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
14214: , interface.interface_header_id
14215: , p_interface_line_id
14216: , l_line_quantity
14217: , l_line_amount

Line 14249: -- po_line_locations_interface table

14245: value => interface.item_description);
14246: l_advance_desc := substrb(FND_MESSAGE.get, 1, 240);
14247:
14248: --SQL WHAT: Insert information for advance payitem into
14249: -- po_line_locations_interface table
14250: --SQL WHY : We will use line_locations_interface as a
14251: -- common entry point for payitems, including ones we create
14252: -- behind the scenes
14253:

Line 14254: INSERT INTO po_line_locations_interface

14250: --SQL WHY : We will use line_locations_interface as a
14251: -- common entry point for payitems, including ones we create
14252: -- behind the scenes
14253:
14254: INSERT INTO po_line_locations_interface
14255: (
14256: interface_line_location_id
14257: , interface_header_id
14258: , interface_line_id

Line 14270: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL

14266: , need_by_date
14267: )
14268: VALUES
14269: (
14270: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
14271: , interface.interface_header_id
14272: , p_interface_line_id
14273: , NULL
14274: , interface.advance_amount

Line 14309: UPDATE po_line_locations_interface polli

14305: --SQL WHAT: Default/update values for scratch payitems in interface table
14306: --SQL WHY : This allows us to update all new payitems' values at once,
14307: -- including payitems from sourcing or ones we've created in autocreate
14308:
14309: UPDATE po_line_locations_interface polli
14310: SET polli.value_basis =
14311: DECODE(polli.payment_type,
14312: 'RATE', 'QUANTITY',
14313: 'LUMPSUM', 'FIXED PRICE',

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

14424: END IF;
14425:
14426: -- insert payitem into po_line_locations_all
14427:
14428: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
14429: --SQL WHY : This allows us to insert all payitems in one location.
14430:
14431: INSERT INTO po_line_locations_all
14432: (

Line 14620: UPDATE po_line_locations_interface polli

14616:
14617: d_progress := 230;
14618:
14619: -- create link between interface row and transaction row
14620: UPDATE po_line_locations_interface polli
14621: SET polli.line_location_id = l_line_loc_id
14622: WHERE polli.interface_line_location_id =
14623: line_location_rec.interface_line_location_id;
14624:

Line 15127: , po_line_locations_interface polli

15123: , poll.amount
15124: , params.sob_id
15125: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15126: FROM po_line_locations_all poll
15127: , po_line_locations_interface polli
15128: WHERE poll.po_line_id = p_po_line_id
15129: AND poll.line_location_id = polli.line_location_id
15130: AND poll.payment_type <> 'ADVANCE';
15131: