[Home] [Help]
10460: WHERE interface_header_id = x_interface_header_id;
10461: --
10462:
10463: --
10464: DELETE po_line_locations_interface
10465: WHERE interface_header_id = x_interface_header_id;
10466: --
10467:
10468: DELETE po_lines_interface
14879: -- PO_LINE_LOCATIONS_ALL
14880: --Locks:
14881: -- None.
14882: --Function:
14883: -- Create all payitems for a PO Line. If PO_LINE_LOCATIONS_INTERFACE is
14884: -- populated, use that information. Otherwise, create a default
14885: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
14886: --Parameters:
14887: -- IN:
14976: polli.description,
14977: polli.work_approver_id,
14978: polli.bid_payment_id,
14979: polli.unit_of_measure
14980: FROM po_line_locations_interface polli
14981: WHERE polli.interface_line_id = p_interface_line_id
14982: ORDER BY polli.shipment_num;
14983:
14984: line_location_rec poll_interface_cursor%ROWTYPE;
15049:
15050: d_progress := 50;
15051:
15052: --SQL WHAT: Insert information for default payitem into
15053: -- po_line_locations interface table
15054: --SQL WHY : We will use line_locations_interface as a
15055: -- common entry point for payitems - whether they come from
15056: -- sourcing or we default them from scratch here.
15057:
15054: --SQL WHY : We will use line_locations_interface as a
15055: -- common entry point for payitems - whether they come from
15056: -- sourcing or we default them from scratch here.
15057:
15058: INSERT INTO po_line_locations_interface
15059: (
15060: interface_line_location_id
15061: , interface_header_id
15062: , interface_line_id
15070: , promised_date
15071: )
15072: VALUES
15073: (
15074: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
15075: , interface.interface_header_id
15076: , p_interface_line_id
15077: , l_payitem_quantity
15078: , l_payitem_amount
15095: -- if financing case, create actual delivery payitem
15096: -- this payitem has a shipment_type of STANDARD and payment_type of DELIVERY
15097:
15098: --SQL WHAT: Insert information for delivery payitem into
15099: -- po_line_locations_interface table
15100: --SQL WHY : We will use line_locations_interface as a
15101: -- common entry point for payitems, including ones we create
15102: -- behind the scenes
15103:
15100: --SQL WHY : We will use line_locations_interface as a
15101: -- common entry point for payitems, including ones we create
15102: -- behind the scenes
15103:
15104: INSERT INTO po_line_locations_interface
15105: (
15106: interface_line_location_id
15107: , interface_header_id
15108: , interface_line_id
15117: , promised_date
15118: )
15119: VALUES
15120: (
15121: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
15122: , interface.interface_header_id
15123: , p_interface_line_id
15124: , l_line_quantity
15125: , l_line_amount
15153: value => interface.item_description);
15154: l_advance_desc := substrb(FND_MESSAGE.get, 1, 240);
15155:
15156: --SQL WHAT: Insert information for advance payitem into
15157: -- po_line_locations_interface table
15158: --SQL WHY : We will use line_locations_interface as a
15159: -- common entry point for payitems, including ones we create
15160: -- behind the scenes
15161:
15158: --SQL WHY : We will use line_locations_interface as a
15159: -- common entry point for payitems, including ones we create
15160: -- behind the scenes
15161:
15162: INSERT INTO po_line_locations_interface
15163: (
15164: interface_line_location_id
15165: , interface_header_id
15166: , interface_line_id
15174: , need_by_date
15175: )
15176: VALUES
15177: (
15178: PO_LINE_LOCATIONS_INTERFACE_S.NEXTVAL
15179: , interface.interface_header_id
15180: , p_interface_line_id
15181: , NULL
15182: , interface.advance_amount
15213: --SQL WHAT: Default/update values for scratch payitems in interface table
15214: --SQL WHY : This allows us to update all new payitems' values at once,
15215: -- including payitems from sourcing or ones we've created in autocreate
15216:
15217: UPDATE po_line_locations_interface polli
15218: SET polli.value_basis =
15219: DECODE(polli.payment_type,
15220: 'RATE', 'QUANTITY',
15221: 'LUMPSUM', 'FIXED PRICE',
15332: END IF;
15333:
15334: -- insert payitem into po_line_locations_all
15335:
15336: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
15337: --SQL WHY : This allows us to insert all payitems in one location.
15338:
15339: INSERT INTO po_line_locations_all
15340: (
15525:
15526: d_progress := 230;
15527:
15528: -- create link between interface row and transaction row
15529: UPDATE po_line_locations_interface polli
15530: SET polli.line_location_id = l_line_loc_id
15531: WHERE polli.interface_line_location_id =
15532: line_location_rec.interface_line_location_id;
15533:
16032: , poll.amount
16033: , params.sob_id
16034: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
16035: FROM po_line_locations_all poll
16036: , po_line_locations_interface polli
16037: WHERE poll.po_line_id = p_po_line_id
16038: AND poll.line_location_id = polli.line_location_id
16039: AND poll.payment_type <> 'ADVANCE';
16040: