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_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 317: nvl((select 1 from pon_auction_item_prices_all items_inner

313:
314: SELECT Count(*)
315: INTO l_exhibits_links from
316: (SELECT exhibit_number,associated_to_line,
317: nvl((select 1 from pon_auction_item_prices_all items_inner
318: Where items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID
319: And items_inner.exhibit_number = AuctionExhibitsEO.EXHIBIT_NUMBER
320: And Nvl(items_inner.clm_cost_constraint,'Priced') not in ('NSP', 'NC')
321: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,

Line 322: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner

318: Where items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID
319: And items_inner.exhibit_number = AuctionExhibitsEO.EXHIBIT_NUMBER
320: And Nvl(items_inner.clm_cost_constraint,'Priced') not in ('NSP', 'NC')
321: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,
322: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner
323: where items_inner.line_number = AuctionExhibitsEO.ASSOCIATED_TO_LINE
324: AND items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID) as IS_LINE_PRICED
325: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO
326: WHERE AuctionExhibitsEO.AUCTION_HEADER_ID = p_auction_header_id

Line 353: nvl((select 1 from pon_auction_item_prices_all items_inner

349: p_user_id, -- LAST_UPDATED_BY
350: sysdate, -- LAST_UPDATE_DATE
351: p_login_id
352: FROM (SELECT exhibit_number,associated_to_line,
353: nvl((select 1 from pon_auction_item_prices_all items_inner
354: Where items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID
355: And items_inner.exhibit_number = AuctionExhibitsEO.EXHIBIT_NUMBER
356: And Nvl(items_inner.clm_cost_constraint,'Priced') not in ('NSP', 'NC')
357: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,

Line 358: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner

354: Where items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID
355: And items_inner.exhibit_number = AuctionExhibitsEO.EXHIBIT_NUMBER
356: And Nvl(items_inner.clm_cost_constraint,'Priced') not in ('NSP', 'NC')
357: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,
358: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner
359: where items_inner.line_number = AuctionExhibitsEO.ASSOCIATED_TO_LINE
360: AND items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID) as IS_LINE_PRICED
361: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO
362: WHERE AuctionExhibitsEO.AUCTION_HEADER_ID = p_auction_header_id) Lines

Line 398: l_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.CLM_INFO_FLAG%TYPE;

394:
395: l_temp NUMBER;
396: l_temp_fnd NUMBER;
397: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
398: l_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.CLM_INFO_FLAG%TYPE;
399: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;
400:
401: BEGIN
402:

Line 1379: PON_AUCTION_ITEM_PRICES_ALL

1375: CLM_DELIVERY_PERIOD sel_delivery_period,
1376: CLM_DELIVERY_PERIOD_UOM sel_delivery_period_uom,
1377: CLM_POP_DURATION sel_pop_duration
1378: FROM
1379: PON_AUCTION_ITEM_PRICES_ALL
1380: WHERE
1381: AUCTION_HEADER_ID = p_auction_header_id;
1382:
1383: /*

Line 1421: FROM pon_auction_item_prices_all paip,

1417: paip.line_num_display sel_clm_line_num_display,
1418: pah.close_bidding_date clm_sol_close_date,
1419: CLM_OPTION_TO_DATE sel_clm_option_to_date,
1420: CLM_BASE_LINE_NUM sel_clm_base_line_num
1421: FROM pon_auction_item_prices_all paip,
1422: pon_auction_headers_all pah
1423: WHERE paip.auction_header_id = p_auction_header_id
1424: AND paip.auction_header_id = pah.auction_header_id;
1425:

Line 1633: PON_AUCTION_ITEM_PRICES_ALL

1629: ORG_ID sel_org_id,
1630: Nvl(CLM_INFO_FLAG,'N') sel_is_info_line,
1631: line_num_display sel_clm_line_num_display
1632: FROM
1633: PON_AUCTION_ITEM_PRICES_ALL
1634: WHERE
1635: AUCTION_HEADER_ID = p_auction_header_id;
1636:
1637: END IF;

Line 1953: FROM PON_AUCTION_ITEM_PRICES_ALL

1949: (
1950: sel_group_type IN ('LOT', 'GROUP') AND
1951: NOT EXISTS (
1952: SELECT LINE_NUMBER
1953: FROM PON_AUCTION_ITEM_PRICES_ALL
1954: WHERE
1955: AUCTION_HEADER_ID = p_auction_header_id AND
1956: PARENT_LINE_NUMBER = sel_line_number
1957: )

Line 2261: AND EXISTS (SELECT 'Y' FROM pon_auction_item_prices_all

2257: -- Priced clins should not have priced slins
2258: WHEN
2259: (
2260: Nvl(sel_is_info_line,'N') = 'N'
2261: AND EXISTS (SELECT 'Y' FROM pon_auction_item_prices_all
2262: WHERE auction_header_id = p_auction_header_id
2263: AND group_line_id = sel_line_number
2264: AND Nvl(clm_info_flag,'N') = 'N')
2265: )

Line 2315: PON_AUCTION_ITEM_PRICES_ALL

2311: line_num_display sel_clm_line_num_display,
2312: --CLM QA Bug : 9835426
2313: nvl(clm_cost_constraint,'X') sel_clm_cost_constraint
2314: FROM
2315: PON_AUCTION_ITEM_PRICES_ALL
2316: WHERE
2317: AUCTION_HEADER_ID = p_auction_header_id;
2318:
2319: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

Line 2732: PON_AUCTION_ITEM_PRICES_ALL PAIP,

2728: -- Clin Slin Changes
2729: Nvl(CLM_INFO_FLAG,'N') sel_is_info_line,
2730: PAIP.line_num_display sel_clm_line_num_display
2731: FROM
2732: PON_AUCTION_ITEM_PRICES_ALL PAIP,
2733: PO_LINE_TYPES_B PLTB
2734: WHERE
2735: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2736: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;

Line 2796: PON_AUCTION_ITEM_PRICES_ALL PAIP,

2792: p_user_id, -- LAST_UPDATED_BY
2793: sysdate, -- LAST_UPDATE_DATE
2794: p_login_id -- LAST_UPDATE_LOGIN
2795: FROM
2796: PON_AUCTION_ITEM_PRICES_ALL PAIP,
2797: PO_LINE_TYPES_B PLTB
2798: WHERE
2799: AUCTION_HEADER_ID = p_auction_header_id AND
2800: PAIP.LINE_TYPE_ID = PLTB.LINE_TYPE_ID AND

Line 3166: PON_AUCTION_ITEM_PRICES_ALL PAIP

3162: PAA.SCORING_TYPE sel_scoring_type,
3163: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
3164: FROM
3165: PON_AUCTION_ATTRIBUTES PAA,
3166: PON_AUCTION_ITEM_PRICES_ALL PAIP
3167: WHERE
3168: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3169: PAA.AUCTION_HEADER_ID = p_auction_header_id AND
3170: PAIP.LINE_NUMBER = PAA.LINE_NUMBER AND

Line 3902: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3898: PASA.SHIP_TO_ORGANIZATION_ID sel_ship_to_organization_id,
3899: PASA.DIFFERENTIAL_RESPONSE_TYPE sel_differential_response_type,
3900: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
3901: FROM
3902: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3903: PON_AUCTION_SHIPMENTS_ALL PASA
3904: WHERE
3905: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3906: PASA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4201: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4197: PASA.QUANTITY sel_min_quantity,
4198: PASA.MAX_QUANTITY sel_max_quantity,
4199: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4200: FROM
4201: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4202: PON_AUCTION_SHIPMENTS_ALL PASA
4203: WHERE
4204: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4205: PASA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4240: FROM pon_auction_item_prices_all paip

4236: sysdate, -- CREATION_DATE
4237: p_user_id, -- LAST_UPDATED_BY
4238: sysdate, -- LAST_UPDATE_DATE
4239: p_login_id -- LAST_UPDATE_LOGIN
4240: FROM pon_auction_item_prices_all paip
4241: WHERE paip.auction_header_id = p_auction_header_id
4242: AND paip.line_number IN
4243: (SELECT DISTINCT pasa.line_number
4244: FROM pon_auction_shipments_all pasa1,

Line 4300: PON_AUCTION_ITEM_PRICES_ALL PAIP

4296: sysdate, -- LAST_UPDATE_DATE
4297: p_login_id -- LAST_UPDATE_LOGIN
4298: FROM
4299: PON_PRICE_DIFFERENTIALS PPD,
4300: PON_AUCTION_ITEM_PRICES_ALL PAIP
4301: WHERE
4302: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
4303: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4304: PPD.LINE_NUMBER = PAIP.LINE_NUMBER AND

Line 4341: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4337: sysdate, -- LAST_UPDATE_DATE
4338: p_login_id -- LAST_UPDATE_LOGIN
4339: FROM
4340: PON_PRICE_DIFFERENTIALS PPD,
4341: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4342: PON_AUCTION_SHIPMENTS_ALL PAS
4343: WHERE
4344: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
4345: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4475: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4471: PPD.PRICE_TYPE sel_price_type,
4472: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4473: FROM
4474: PON_PRICE_DIFFERENTIALS PPD,
4475: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4476: PO_PRICE_DIFF_LOOKUPS_V PPDL
4477: WHERE
4478: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4479: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4571: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4567: PPD.SHIPMENT_NUMBER sel_shipment_number,
4568: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc,
4569: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4570: FROM
4571: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4572: PON_AUCTION_SHIPMENTS_ALL PASA,
4573: PON_PRICE_DIFFERENTIALS PPD,
4574: PO_PRICE_DIFF_LOOKUPS_V PPDL
4575: WHERE

Line 4938: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4934: PPET.ENABLED_FLAG sel_enabled_flag,
4935: PPET.SYSTEM_FLAG sel_system_flag,
4936: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4937: FROM
4938: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4939: PON_PRICE_ELEMENTS PPE,
4940: PON_PRICE_ELEMENT_TYPES_TL PPETL,
4941: PON_PRICE_ELEMENT_TYPES PPET
4942: WHERE

Line 5005: PON_AUCTION_ITEM_PRICES_ALL PAIP,

5001: p_user_id, -- LAST_UPDATED_BY
5002: sysdate, -- LAST_UPDATE_DATE
5003: p_login_id -- LAST_UPDATE_LOGIN
5004: FROM
5005: PON_AUCTION_ITEM_PRICES_ALL PAIP,
5006: PON_PRICE_ELEMENTS PPE,
5007: PON_PRICE_ELEMENT_TYPES_TL PPETL
5008: WHERE
5009: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 5059: pon_auction_item_prices_all

5055: COUNT(LINE_NUMBER)
5056: INTO
5057: l_major_line_count
5058: FROM
5059: pon_auction_item_prices_all
5060: WHERE
5061: auction_header_id = p_auction_header_id AND
5062: group_type IN ('LOT', 'GROUP', 'LINE');
5063:

Line 5370: PON_AUCTION_ITEM_PRICES_ALL PAIP

5366: PAIP.LINE_NUMBER,
5367: Nvl(paip.clm_info_flag, 'N') sel_clm_info_flag, -- clin slin changes
5368: PAIP.LINE_NUM_DISPLAY
5369: FROM
5370: PON_AUCTION_ITEM_PRICES_ALL PAIP
5371: WHERE
5372: PAIP.AUCTION_HEADER_ID = p_auction_header_id
5373: AND Nvl(paip.clm_info_flag,'N')<>'Y';
5374:

Line 5490: PON_AUCTION_ITEM_PRICES_ALL PAIP

5486: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID,
5487: PAIP.LINE_NUM_DISPLAY
5488: FROM
5489: PON_AUCTION_SHIPMENTS_ALL PSA,
5490: PON_AUCTION_ITEM_PRICES_ALL PAIP
5491: WHERE
5492: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5493: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5494: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;

Line 5605: PON_AUCTION_ITEM_PRICES_ALL PAIP

5601: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID,
5602: PAIP.LINE_NUM_DISPLAY
5603: FROM
5604: PON_AUCTION_SHIPMENTS_ALL PSA,
5605: PON_AUCTION_ITEM_PRICES_ALL PAIP
5606: WHERE
5607: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5608: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5609: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;

Line 5671: PON_AUCTION_ITEM_PRICES_ALL PAIP

5667: sysdate, -- LAST_UPDATE_DATE
5668: p_login_id -- LAST_UPDATE_LOGIN
5669: FROM
5670: PO_LINE_TYPES_B PLTB,
5671: PON_AUCTION_ITEM_PRICES_ALL PAIP
5672: WHERE
5673: PAIP.AUCTION_HEADER_ID=p_auction_header_id AND
5674: PLTB.LINE_TYPE_ID= PAIP.LINE_TYPE_ID AND
5675: PLTB.OUTSIDE_OPERATION_FLAG='Y' AND

Line 5705: FROM PON_AUCTION_ITEM_PRICES_ALL

5701: CURSOR l_proj_cursor IS
5702: SELECT line_number, document_disp_line_number,
5703: project_id, project_task_id, project_expenditure_type,
5704: project_exp_organization_id, project_expenditure_item_date
5705: FROM PON_AUCTION_ITEM_PRICES_ALL
5706: WHERE auction_header_id=p_auction_header_id
5707: AND project_id IS NOT NULL
5708: AND project_task_id IS NOT NULL
5709: AND project_expenditure_type IS NOT NULL

Line 5755: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

5751: paip.ORDER_TYPE_LOOKUP_CODE,
5752: paip.line_number s_line_number,
5753: plt.outside_operation_flag po_outside_operation_flag,
5754: paip.line_num_display
5755: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
5756: PO_LINE_TYPES plt
5757: WHERE paip.auction_header_id = p_auction_header_id
5758: AND paip.line_type_id = plt.line_type_id (+)
5759: AND paip.group_type NOT IN ('GROUP','LOT_LINE');

Line 6145: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

6141: paip.has_payments_flag,
6142: plt.outside_operation_flag po_outside_operation_flag,
6143: paip.line_num_display,
6144: Nvl(paip.clm_info_flag, 'N') s_clm_info_flag
6145: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
6146: PO_LINE_TYPES plt
6147: WHERE paip.auction_header_id = p_auction_header_id
6148: AND paip.line_type_id = plt.line_type_id (+)
6149: AND paip.group_type NOT IN ('GROUP','LOT_LINE');

Line 6186: FROM PON_AUCTION_ITEM_PRICES_ALL paip

6182: paip.LINE_NUMBER s_line_number,
6183: paip.DOCUMENT_DISP_LINE_NUMBER,
6184: paip.WORK_APPROVER_USER_ID,
6185: paip.line_num_display
6186: FROM PON_AUCTION_ITEM_PRICES_ALL paip
6187: WHERE paip.auction_header_id = p_auction_header_id
6188: AND paip.WORK_APPROVER_USER_ID IS NOT NULL;
6189:
6190:

Line 6341: FROM PON_AUCTION_ITEM_PRICES_ALL paip

6337: paip.PROJECT_EXPENDITURE_TYPE pai_project_exp_type,
6338: paip.PROJECT_EXP_ORGANIZATION_ID pai_project_exp_org_id,
6339: paip.PROJECT_EXPENDITURE_ITEM_DATE pai_project_exp_item_date,
6340: paip.line_num_display
6341: FROM PON_AUCTION_ITEM_PRICES_ALL paip
6342: WHERE paip.auction_header_id = p_auction_header_id
6343: AND paip.PROJECT_ID IS NOT NULL
6344: AND paip.PROJECT_TASK_ID IS NOT NULL
6345: AND paip.PROJECT_EXPENDITURE_TYPE IS NOT NULL

Line 6413: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai

6409: sysdate, -- LAST_UPDATE_DATE
6410: p_login_id, -- LAST_UPDATE_LOGIN
6411: p_request_id --REQUEST_ID
6412: FROM
6413: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai
6414: WHERE paps.auction_header_id=pai.auction_header_id
6415: AND paps.line_number = pai.line_number
6416: AND paps.auction_header_id = p_auction_header_id
6417: GROUP BY paps.auction_header_id, paps.line_number,

Line 6453: PON_AUCTION_ITEM_PRICES_ALL paip

6449: paps.project_id, paps.project_task_id, paps.project_expenditure_type,
6450: paps.project_exp_organization_id, paps.project_expenditure_item_date,
6451: paip.line_number, paip.document_disp_line_number
6452: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,
6453: PON_AUCTION_ITEM_PRICES_ALL paip
6454: WHERE paps.auction_header_id=p_auction_header_id
6455: AND paps.project_id IS NOT NULL
6456: AND paps.project_task_id IS NOT NULL
6457: AND paps.project_expenditure_type IS NOT NULL

Line 6814: PON_AUCTION_ITEM_PRICES_ALL pai,

6810: pah.supplier_enterable_pymt_flag,
6811: pai.line_number s_line_number,
6812: pai.line_num_display
6813: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
6814: PON_AUCTION_ITEM_PRICES_ALL pai,
6815: PON_AUCTION_HEADERS_ALL pah
6816: WHERE ppi.auction_header_id = pai.auction_header_id
6817: AND ppi.line_number = pai.line_number
6818: AND pah.auction_header_id = ppi.auction_header_id

Line 7003: PON_AUCTION_ITEM_PRICES_ALL pai,

6999: ppi.work_approver_user_id,
7000: pai.line_number s_line_number,
7001: pai.line_num_display
7002: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
7003: PON_AUCTION_ITEM_PRICES_ALL pai,
7004: PON_AUCTION_HEADERS_ALL pah
7005: WHERE ppi.auction_header_id = pai.auction_header_id
7006: AND ppi.line_number = pai.line_number
7007: AND ppi.auction_header_id = p_auction_header_id

Line 7157: PON_AUCTION_ITEM_PRICES_ALL

7153: LINE_NUMBER
7154: INTO
7155: l_line_number
7156: FROM
7157: PON_AUCTION_ITEM_PRICES_ALL
7158: WHERE
7159: AUCTION_HEADER_ID = p_auction_header_id AND
7160: PURCHASE_BASIS = 'TEMP LABOR' AND
7161: ROWNUM = 1;

Line 7177: PON_AUCTION_ITEM_PRICES_ALL PAIP

7173: BEGIN
7174: --HAS_ATTRIBUTES_FLAG, HAS_SHIPMENTS_FLAG, HAS_PRICE_ELEMENTS_FLAG,
7175: --HAS_BUYER_PFS_FLAG, HAS_PRICE_DIFFERENTIALS_FLAG,HAS_QUANTITY_TIERS
7176: UPDATE
7177: PON_AUCTION_ITEM_PRICES_ALL PAIP
7178: SET
7179: HAS_ATTRIBUTES_FLAG = NVL(
7180: (SELECT 'Y'
7181: FROM PON_AUCTION_ATTRIBUTES

Line 7240: FROM PON_AUCTION_ITEM_PRICES_ALL

7236: BEGIN
7237:
7238: SELECT MAX (DISP_LINE_NUMBER)
7239: INTO x_max_disp_line_number
7240: FROM PON_AUCTION_ITEM_PRICES_ALL
7241: WHERE AUCTION_HEADER_ID = p_auction_header_id
7242: AND PARENT_LINE_NUMBER = p_parent_line_number;
7243:
7244: IF (x_max_disp_line_number IS NULL) THEN

Line 7247: FROM PON_AUCTION_ITEM_PRICES_ALL

7243:
7244: IF (x_max_disp_line_number IS NULL) THEN
7245: SELECT DISP_LINE_NUMBER
7246: INTO x_max_disp_line_number
7247: FROM PON_AUCTION_ITEM_PRICES_ALL
7248: WHERE AUCTION_HEADER_ID = p_auction_header_id
7249: AND LINE_NUMBER = p_parent_line_number;
7250: END IF;
7251:

Line 7267: FROM PON_AUCTION_ITEM_PRICES_ALL

7263: BEGIN
7264:
7265: SELECT MAX (DISP_LINE_NUMBER)
7266: INTO x_max_disp_line_number
7267: FROM PON_AUCTION_ITEM_PRICES_ALL
7268: WHERE AUCTION_HEADER_ID = p_auction_header_id
7269: AND group_line_id = p_parent_line_number;
7270:
7271: IF (x_max_disp_line_number IS NULL) THEN

Line 7274: FROM PON_AUCTION_ITEM_PRICES_ALL

7270:
7271: IF (x_max_disp_line_number IS NULL) THEN
7272: SELECT DISP_LINE_NUMBER
7273: INTO x_max_disp_line_number
7274: FROM PON_AUCTION_ITEM_PRICES_ALL
7275: WHERE AUCTION_HEADER_ID = p_auction_header_id
7276: AND LINE_NUMBER = p_parent_line_number;
7277: END IF;
7278:

Line 7930: UPDATE pon_auction_item_prices_all paip

7926: module => g_module_prefix || l_module_name,
7927: message => 'Entered procedure = ' || l_module_name);
7928: END IF;
7929:
7930: UPDATE pon_auction_item_prices_all paip
7931: SET
7932: -- the max sub line sequence number is set to the greatest
7933: -- max_sub_line_sequence_number between this round and the
7934: -- previous round

Line 7940: pon_auction_item_prices_all

7936: (
7937: SELECT
7938: NVL (MAX (sub_line_sequence_number),0)
7939: FROM
7940: pon_auction_item_prices_all
7941: WHERE
7942: auction_header_id=p_auction_header_id AND
7943: parent_line_number = paip.line_number AND
7944: group_type IN ('LOT_LINE', 'GROUP_LINE')

Line 7952: UPDATE pon_auction_item_prices_all paip

7948: line_number >= p_curr_from_line_number AND
7949: line_number <= p_curr_to_line_number AND
7950: group_type IN ('LOT', 'GROUP');
7951:
7952: UPDATE pon_auction_item_prices_all paip
7953: SET
7954: close_bidding_date = decode(p_stag_closing_enabled_flag, 'Y', close_bidding_date, p_close_bidding_date),
7955:
7956: -- If the line has any attributes this flag will be Y else N

Line 8090: pon_auction_item_prices_all

8086: order_type_lookup_code,
8087: unit_target_price,
8088: unit_display_target_flag
8089: FROM
8090: pon_auction_item_prices_all
8091: WHERE
8092: auction_header_id = p_auction_header_id AND
8093: (has_price_elements_flag = 'Y' OR has_buyer_pfs_flag = 'Y') AND
8094: line_number >= p_from_line_number AND

Line 8163: pon_auction_item_prices_all paip,

8159: sum(decode(ppe.pricing_basis, 'PER_UNIT', Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y', -ppsv.Value,ppsv.Value) , 0)) unit_price,
8160: sum(decode(ppe.pricing_basis, 'FIXED_AMOUNT', Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y', -ppsv.Value,ppsv.Value), 0)) fixed_amount,
8161: 1 + sum(decode(ppe.pricing_basis, 'PERCENTAGE', Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y', -ppsv.Value/100,ppsv.Value/100), 0)) percentage
8162: from
8163: pon_auction_item_prices_all paip,
8164: pon_bidding_parties pbp,
8165: pon_pf_supplier_values ppsv,
8166: pon_price_elements ppe
8167: where

Line 8432: FROM pon_auction_item_prices_all

8428: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
8429:
8430: SELECT NVL (MAX (line_number), 0)
8431: INTO l_max_line_number
8432: FROM pon_auction_item_prices_all
8433: WHERE auction_header_id = p_auction_header_id;
8434:
8435: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8436: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 8624: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP

8620:
8621: BEGIN
8622: SELECT 'N'
8623: INTO l_has_pe_for_all_items
8624: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP
8625: WHERE PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
8626: HAS_PRICE_ELEMENTS_FLAG = 'N' AND
8627: HAS_BUYER_PFS_FLAG = 'N' AND
8628: ROWNUM = 1;

Line 8655: PON_AUCTION_ITEM_PRICES_ALL PAIP

8651: MAX_INTERNAL_LINE_NUM = GREATEST (NVL (PAHA.MAX_INTERNAL_LINE_NUM,0),
8652: (SELECT
8653: MAX(PAIP.LINE_NUMBER)
8654: FROM
8655: PON_AUCTION_ITEM_PRICES_ALL PAIP
8656: WHERE
8657: PAIP.AUCTION_HEADER_ID = p_auction_header_id)),
8658: MAX_DOCUMENT_LINE_NUM = GREATEST (NVL (PAHA.MAX_DOCUMENT_LINE_NUM,0),
8659: (SELECT

Line 8662: PON_AUCTION_ITEM_PRICES_ALL PAIP

8658: MAX_DOCUMENT_LINE_NUM = GREATEST (NVL (PAHA.MAX_DOCUMENT_LINE_NUM,0),
8659: (SELECT
8660: MAX(PAIP.SUB_LINE_SEQUENCE_NUMBER)
8661: FROM
8662: PON_AUCTION_ITEM_PRICES_ALL PAIP
8663: WHERE
8664: PAIP.GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
8665: AND PAIP.AUCTION_HEADER_ID = p_auction_header_id))
8666: WHERE

Line 8726: FROM pon_auction_item_prices_all

8722: WHERE auction_header_id = p_auction_header_id;
8723:
8724: SELECT NVL (MAX (line_number), 0)
8725: INTO l_max_line_number
8726: FROM pon_auction_item_prices_all
8727: WHERE auction_header_id = p_auction_header_id;
8728:
8729: -- clean up from any previous failures
8730: