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.PON_AUCTION_CREATE_PO_PKG dependencies on PO_LINES_INTERFACE

Line 1795: FROM po_lines_interface

1791: SELECT interface_line_id,
1792: group_line_id,
1793: clm_info_flag,
1794: interface_header_id
1795: FROM po_lines_interface
1796: WHERE group_Line_id IS NULL
1797: AND INTERFACE_HEADER_ID = l_interface_header_id
1798: AND auction_header_id = l_auction_header_id
1799: AND clm_exhibit_name IS NULL --ELINs project

Line 1809: FROM po_lines_interface

1805: SELECT interface_line_id,
1806: group_line_id,
1807: line_num_display,
1808: interface_header_id
1809: FROM po_lines_interface
1810: WHERE group_Line_id IS NULL
1811: AND INTERFACE_HEADER_ID = l_interface_header_id
1812: AND auction_header_id = l_auction_header_id
1813: ORDER BY interface_line_id;

Line 1824: FROM PO_LINES_INTERFACE

1820: group_line_id,
1821: requisition_line_id,
1822: clm_base_line_num,
1823: line_num_display
1824: FROM PO_LINES_INTERFACE
1825: WHERE INTERFACE_HEADER_ID = l_interface_header_id
1826: ORDER BY interface_line_id;
1827:
1828: /* Bug 9883780 - End */

Line 1884: /* Selects the data from Sourcing that will populate PO_LINES_INTERFACE */

1880: pbh.auction_header_id = pah.auction_header_id and
1881: pbh.bid_number = p_bid_number and
1882: pbh.bid_currency_code = fc.currency_code;
1883:
1884: /* Selects the data from Sourcing that will populate PO_LINES_INTERFACE */
1885:
1886: /*
1887: rrkulkar-large-auction-support - this cursor will bring in all the lines in the middle-tier :
1888: hence, added the following condition in the where clause :-

Line 2331: Insert a row into PO_LINES_INTERFACE with the

2327:
2328: log_message(x_progress);
2329:
2330: /*
2331: Insert a row into PO_LINES_INTERFACE with the
2332: item information from the negotiation line, and
2333: the requisiton_line_id and quantity
2334: (price and quantity will be switched when
2335: negotiation line is amount-based-

Line 2341: INSERT into PO_LINES_INTERFACE (

2337: from the backing requisition.
2338: */
2339:
2340:
2341: INSERT into PO_LINES_INTERFACE (
2342: interface_header_id,
2343: interface_line_id,
2344: requisition_line_id,
2345: line_type_id,

Line 2410: po_lines_interface_s.nextval, -- interface_line_id

2406:
2407: values (
2408:
2409: x_interface_header_id, -- interface_header_id
2410: po_lines_interface_s.nextval, -- interface_line_id
2411: x_requisition_line_id, -- requisition_line_id
2412: x_pdoi_line.line_type_id,
2413: -- line_type_id
2414: x_pdoi_line.item_id,

Line 2486: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||

2482:
2483: ) return interface_line_id into x_interface_line_id;
2484:
2485: x_progress :=
2486: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||
2487: 'interface_header_id: ' || to_char(x_interface_header_id) || ', ' ||
2488: 'interface_line_id: ' || to_char(x_interface_line_id) || ', ' ||
2489: 'requisition_line_id: ' || to_char(x_requisition_line_id) || ', ' ||
2490: 'line_type_id: ' || to_char(x_pdoi_line.line_type_id) || ', ' ||

Line 2565: insert an additional row into PO_LINES_INTERFACE with the

2561: award quantities
2562: case-3. There is an excess award OR
2563:
2564: In either of the aforementioned 3 cases, we need to
2565: insert an additional row into PO_LINES_INTERFACE with the
2566: item information from the negotiation line, a null
2567: requisition_line_id, a quantity for the excess award,
2568: and a value of 'N' in the orig_from_req_flag column.
2569:

Line 2613: INSERT into PO_LINES_INTERFACE (

2609: x_quantity := x_award_quantity - sum_of_alloc_quantities(x_line_number);
2610: ELSE
2611: x_quantity := x_award_quantity;
2612: END IF;
2613: INSERT into PO_LINES_INTERFACE (
2614: interface_header_id,
2615: interface_line_id,
2616: requisition_line_id,
2617: line_type_id,

Line 2682: po_lines_interface_s.nextval, -- interface_line_id

2678:
2679: values (
2680:
2681: x_interface_header_id, -- interface_header_id
2682: po_lines_interface_s.nextval, -- interface_line_id
2683: NULL, -- requisition_line_id
2684: x_pdoi_line.line_type_id,
2685: -- line_type_id
2686: x_pdoi_line.item_id,

Line 2757: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||

2753: ) return interface_line_id into x_interface_line_id;
2754:
2755:
2756: x_progress :=
2757: '35: CREATE_PO_STRUCTURE: INSERTING the following data into PO_LINES_INTERFACE: ' ||
2758: 'interface_header_id: ' || to_char(x_interface_header_id) || ', ' ||
2759: 'interface_line_id: ' || to_char(x_interface_line_id) || ', ' ||
2760: 'requisition_line_id: ' || null || ', ' ||
2761: 'line_type_id: ' || to_char(x_pdoi_line.line_type_id) || ', ' ||

Line 2869: INSERT into PO_LINES_INTERFACE (

2865:
2866: need to find out about x_interface_line_id :- is it used for debugging purposes only?
2867: */
2868:
2869: INSERT into PO_LINES_INTERFACE (
2870: interface_header_id,
2871: interface_line_id,
2872: requisition_line_id,
2873: line_type_id,

Line 2934: po_lines_interface_s.nextval, -- interface_line_id

2930: CLM_POP_DURATION_UOM
2931: )
2932: SELECT
2933: x_interface_header_id, -- interface_header_id
2934: po_lines_interface_s.nextval, -- interface_line_id
2935: NULL, -- requisition_line_id
2936: paip.line_type_id, -- line_type_id
2937: paip.item_id, -- item_id
2938: paip.item_revision, -- item_revision

Line 3161: po_lines_interface pli,

3157: FROM pon_auction_item_prices_all paip,
3158: pon_bid_item_prices pbip,
3159: pon_bid_payments_shipments bpys,
3160: pon_auc_payments_shipments apys,
3161: po_lines_interface pli,
3162: mtl_units_of_measure mtluom
3163: WHERE pbip.bid_number = p_bid_number and
3164: pbip.auction_header_id = p_auction_header_id and
3165: nvl(pbip.award_status, 'NO') = 'AWARDED' and

Line 3216: insert into po_lines_interface.

3212:
3213: END LOOP; --} --end-loop- batching-SPO
3214:
3215: /* Unsolicited Lines Project : If unsolicited lines are enabled,
3216: insert into po_lines_interface.
3217: */
3218: IF l_allow_unsol_lines = 'Y' THEN
3219: log_message('SPO : l_allow_unsol_lines '||l_allow_unsol_lines);
3220: log_message('SPO : Before inserting unsolicited lines. ');

Line 3274: INSERT into PO_LINES_INTERFACE (

3270: log_message('blanket batching loop: l_batch_size=' || l_batch_size || ' l_batch_start=' || l_batch_start || ' l_batch_end=' || l_batch_end);
3271:
3272: /* Bug 9915090 - In Case of IDVs quantity should be populated with extended price / offer price. */
3273:
3274: INSERT into PO_LINES_INTERFACE (
3275: interface_header_id,
3276: interface_line_id,
3277: requisition_line_id,
3278: line_type_id,

Line 3332: po_lines_interface_s.nextval, -- interface_line_id

3328:
3329: )
3330: SELECT
3331: x_interface_header_id, -- interface_header_id
3332: po_lines_interface_s.nextval, -- interface_line_id
3333: NULL, -- requisition_line_id
3334: paip.line_type_id, -- line_type_id
3335: l_rows_processed + rownum, -- line num
3336: paip.item_id,

Line 3436: UPDATE po_lines_interface PLI1

3432: log_message('blanket inserting info lines: l_rows_processed' || l_rows_processed );
3433:
3434:
3435:
3436: UPDATE po_lines_interface PLI1
3437: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
3438: where PLI2.interface_header_id = x_interface_header_id
3439: and PLI2.auction_header_id = p_auction_header_id
3440: and PLI2.auction_line_number = PLI1.group_line_id

Line 3437: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2

3433:
3434:
3435:
3436: UPDATE po_lines_interface PLI1
3437: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
3438: where PLI2.interface_header_id = x_interface_header_id
3439: and PLI2.auction_header_id = p_auction_header_id
3440: and PLI2.auction_line_number = PLI1.group_line_id
3441: AND PLI2.group_line_id IS NULL

Line 3447: UPDATE po_lines_interface PLI1

3443: where PLI1.group_line_id is not null
3444: and PLI1.interface_header_id = x_interface_header_id
3445: and PLI1.auction_header_id = p_auction_header_id;
3446:
3447: UPDATE po_lines_interface PLI1
3448: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2
3449: where PLI2.interface_header_id = x_interface_header_id
3450: and PLI2.auction_header_id = p_auction_header_id
3451: and PLI2.auction_line_number = PLI1.clm_base_line_num

Line 3448: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2

3444: and PLI1.interface_header_id = x_interface_header_id
3445: and PLI1.auction_header_id = p_auction_header_id;
3446:
3447: UPDATE po_lines_interface PLI1
3448: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2
3449: where PLI2.interface_header_id = x_interface_header_id
3450: and PLI2.auction_header_id = p_auction_header_id
3451: and PLI2.auction_line_number = PLI1.clm_base_line_num
3452: AND PLI2.clm_base_line_num IS NULL

Line 3473: INSERT INTO po_lines_interface (

3469:
3470: log_message('inserting blanket price break information');
3471:
3472: -- Insert Price Break information
3473: INSERT INTO po_lines_interface (
3474: interface_header_id,
3475: interface_line_id,
3476: shipment_type,
3477: line_type_id,

Line 3514: po_lines_interface_s.NEXTVAL, -- interface_line_id

3510:
3511: )
3512: SELECT
3513: x_interface_header_id, -- interface_header_id
3514: po_lines_interface_s.NEXTVAL, -- interface_line_id
3515: pbs.shipment_type, -- shipment_type
3516: paip.line_type_id, -- line_type_id
3517: paip.item_id, -- item_id
3518: paip.item_revision, -- item_revision

Line 3554: po_lines_interface pli

3550:
3551: FROM pon_auction_item_prices_all paip,
3552: pon_bid_item_prices pbip,
3553: pon_bid_shipments pbs,
3554: po_lines_interface pli
3555: WHERE pbip.bid_number = p_bid_number and
3556: pbip.auction_header_id = p_auction_header_id and
3557: nvl(pbip.award_status, 'NO') = 'AWARDED' and
3558: paip.auction_header_id = pbip.auction_header_id and

Line 3605: po_lines_interface pli

3601: FROM pon_price_differentials ppd,
3602: pon_bid_item_prices pbip,
3603: pon_bid_price_differentials pbpd,
3604: pon_auction_headers_all pah,
3605: po_lines_interface pli
3606: WHERE pbip.bid_number = p_bid_number
3607: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3608: AND pbip.auction_header_id = ppd.auction_header_id
3609: AND pbip.line_number = ppd.line_number

Line 3666: po_lines_interface pli

3662: and pbs.line_number = pbpd.line_number
3663: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3664: pon_bid_shipments pbs,
3665: pon_auction_headers_all pah,
3666: po_lines_interface pli
3667: WHERE pbip.bid_number = p_bid_number
3668: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3669: AND pbip.bid_number = pbs.bid_number
3670: AND pbip.line_number = pbs.line_number

Line 3690: INSERT INTO po_lines_interface_debug

3686: /*
3687: -- DEBUG CODE
3688: -- ALWAYS COMMENTED OUT
3689:
3690: INSERT INTO po_lines_interface_debug
3691: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3692:
3693: INSERT INTO po_price_diff_interface_debug
3694: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);

Line 3691: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);

3687: -- DEBUG CODE
3688: -- ALWAYS COMMENTED OUT
3689:
3690: INSERT INTO po_lines_interface_debug
3691: (SELECT * FROM po_lines_interface WHERE interface_header_id = x_interface_header_id);
3692:
3693: INSERT INTO po_price_diff_interface_debug
3694: (SELECT * FROM po_price_diff_interface WHERE interface_header_id = x_interface_header_id);
3695: */

Line 3738: insert into po_lines_interface.

3734: --------------------------------------------------------------------------------------------------------------
3735: --BATCHING FOR OUTCOME = BLANKET PURCHASE AGREEMENT: ENDS HERE
3736: --------------------------------------------------------------------------------------------------------------
3737: /* Unsolicited Lines Project : If unsolicited lines are enabled,
3738: insert into po_lines_interface.
3739: */
3740: log_message('BPA : l_allow_unsol_lines '||l_allow_unsol_lines);
3741: IF l_allow_unsol_lines = 'Y' THEN
3742: log_message('BPA : Before inserting unsolicited lines. ');

Line 3798: UPDATE po_lines_interface PLI1

3794: The below update query updates the mappings only for records, which were backed up by requisitions or
3795: those records, which were splitted because of excess awarding or those records which were added in the
3796: solicitation in relation with Requisition. */
3797:
3798: UPDATE po_lines_interface PLI1
3799: SET PLI1.group_line_id = Nvl( (select PLI2.interface_line_id
3800: from po_lines_interface PLI2
3801: where PLI2.interface_header_id = x_interface_header_id
3802: and PLI2.auction_header_id = p_auction_header_id

Line 3800: from po_lines_interface PLI2

3796: solicitation in relation with Requisition. */
3797:
3798: UPDATE po_lines_interface PLI1
3799: SET PLI1.group_line_id = Nvl( (select PLI2.interface_line_id
3800: from po_lines_interface PLI2
3801: where PLI2.interface_header_id = x_interface_header_id
3802: and PLI2.auction_header_id = p_auction_header_id
3803: and PLI2.auction_line_number = PLI1.group_line_id
3804: AND PLI2.group_line_id IS NULL

Line 3817: UPDATE po_lines_interface PLI1

3813: CLIN - SLIN relationships .
3814: The below update query updates the mappings only for records, which were added in the solicitions
3815: and not updated in the above query*/
3816:
3817: UPDATE po_lines_interface PLI1
3818: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
3819: where PLI2.interface_header_id = x_interface_header_id
3820: and PLI2.auction_header_id = p_auction_header_id
3821: and PLI2.auction_line_number = PLI1.group_line_id

Line 3818: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2

3814: The below update query updates the mappings only for records, which were added in the solicitions
3815: and not updated in the above query*/
3816:
3817: UPDATE po_lines_interface PLI1
3818: SET PLI1.group_line_id = (select PLI2.interface_line_id from po_lines_interface PLI2
3819: where PLI2.interface_header_id = x_interface_header_id
3820: and PLI2.auction_header_id = p_auction_header_id
3821: and PLI2.auction_line_number = PLI1.group_line_id
3822: AND PLI2.group_line_id IS NULL

Line 3828: FROM po_lines_interface PLI3

3824: where PLI1.group_line_id is not null
3825: and PLI1.interface_header_id = x_interface_header_id
3826: and PLI1.auction_header_id = p_auction_header_id
3827: and PLI1.group_line_id <> Nvl ( (SELECT PLI3.interface_line_id
3828: FROM po_lines_interface PLI3
3829: WHERE PLI3.interface_header_id = x_interface_header_id
3830: and PLI3.auction_header_id = p_auction_header_id
3831: AND PLI3.interface_line_id = PLI1.group_line_id), -99999 );
3832:

Line 3839: UPDATE po_lines_interface PLI1

3835: The below update query updates the mappings only for records, which were backed up by requisitions or
3836: those records, which were splitted because of excess awarding or those records which were added in the
3837: solicitation in relation with Requisition. */
3838:
3839: UPDATE po_lines_interface PLI1
3840: SET PLI1.clm_base_line_num = Nvl( (select PLI2.interface_line_id
3841: from po_lines_interface PLI2
3842: where PLI2.interface_header_id = x_interface_header_id
3843: and PLI2.auction_header_id = p_auction_header_id

Line 3841: from po_lines_interface PLI2

3837: solicitation in relation with Requisition. */
3838:
3839: UPDATE po_lines_interface PLI1
3840: SET PLI1.clm_base_line_num = Nvl( (select PLI2.interface_line_id
3841: from po_lines_interface PLI2
3842: where PLI2.interface_header_id = x_interface_header_id
3843: and PLI2.auction_header_id = p_auction_header_id
3844: and PLI2.auction_line_number = PLI1.clm_base_line_num
3845: AND PLI2.clm_base_line_num IS NULL

Line 3857: UPDATE po_lines_interface PLI1

3853: Base CLIN/SLIN to maintain BASE - OPTION relationships.
3854: The below update query updates the mappings only for records, which were added in the solicitions
3855: and not updated in the above query*/
3856:
3857: UPDATE po_lines_interface PLI1
3858: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2
3859: where PLI2.interface_header_id = x_interface_header_id
3860: and PLI2.auction_header_id = p_auction_header_id
3861: and PLI2.auction_line_number = PLI1.clm_base_line_num

Line 3858: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2

3854: The below update query updates the mappings only for records, which were added in the solicitions
3855: and not updated in the above query*/
3856:
3857: UPDATE po_lines_interface PLI1
3858: SET PLI1.clm_base_line_num = (select PLI2.interface_line_id from po_lines_interface PLI2
3859: where PLI2.interface_header_id = x_interface_header_id
3860: and PLI2.auction_header_id = p_auction_header_id
3861: and PLI2.auction_line_number = PLI1.clm_base_line_num
3862: AND PLI2.clm_base_line_num IS NULL

Line 3868: FROM po_lines_interface PLI3

3864: where PLI1.clm_base_line_num is not null
3865: and PLI1.interface_header_id = x_interface_header_id
3866: and PLI1.auction_header_id = p_auction_header_id
3867: and PLI1.clm_base_line_num <> Nvl ( (SELECT PLI3.interface_line_id
3868: FROM po_lines_interface PLI3
3869: WHERE PLI3.interface_header_id = x_interface_header_id
3870: and PLI3.auction_header_id = p_auction_header_id
3871: AND PLI3.interface_line_id = PLI1.clm_base_line_num), -99999 );
3872:

Line 3915: UPDATE po_lines_interface

3911: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
3912:
3913: log_message('next_clin_num : '||next_clin_num);
3914:
3915: UPDATE po_lines_interface
3916: SET line_num_display = next_clin_num
3917: WHERE interface_header_id = upd_row.interface_header_id
3918: AND interface_line_id = upd_row.interface_line_id;
3919:

Line 4091: po_lines_interface pli,

4087: pbav.value,
4088: paa.attribute_name
4089: FROM pon_bid_item_prices pbip,
4090: pon_auction_item_prices_all paip,
4091: po_lines_interface pli,
4092: pon_bid_attribute_values pbav,
4093: pon_auction_attributes paa,
4094: icx_cat_agreement_attrs_v icx
4095: WHERE pbip.auction_header_id = p_auction_header_id and

Line 5979: FROM po_lines_interface

5975: IS
5976:
5977: CURSOR po_lines IS
5978: SELECT interface_line_id , auction_line_number
5979: FROM po_lines_interface
5980: WHERE interface_header_id = x_interface_id;
5981:
5982: BEGIN
5983:

Line 5986: UPDATE po_lines_interface

5982: BEGIN
5983:
5984: FOR oneline IN po_lines
5985: LOOP
5986: UPDATE po_lines_interface
5987: SET group_line_id = oneline.interface_line_id
5988: WHERE interface_header_id = x_interface_id
5989: AND group_line_id = oneline.auction_line_number;
5990:

Line 5991: UPDATE po_lines_interface

5987: SET group_line_id = oneline.interface_line_id
5988: WHERE interface_header_id = x_interface_id
5989: AND group_line_id = oneline.auction_line_number;
5990:
5991: UPDATE po_lines_interface
5992: SET clm_base_line_num = oneline.interface_line_id
5993: WHERE interface_header_id = x_interface_id
5994: AND clm_base_line_num = oneline.auction_line_number;
5995: