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 PON_AUCTION_ITEM_PRICES_ALL

Line 284: select count(DISTINCT line_number) into l_unawarded_line_count from pon_auction_item_prices_all where auction_header_id = p_auction_header_id and nvl(award_status,'NO') = 'NO';

280:
281: --Staggered Awarding project
282: select nvl(allow_staggered_awards, 'N') into l_allow_stag_awards from pon_auction_headers_all where auction_header_id = p_auction_header_id;
283:
284: select count(DISTINCT line_number) into l_unawarded_line_count from pon_auction_item_prices_all where auction_header_id = p_auction_header_id and nvl(award_status,'NO') = 'NO';
285:
286: if (l_unawarded_line_count > 0) then
287: l_has_unawarded_lines := 'Y';
288: else

Line 416: FROM pon_auction_item_prices_all itm,

412: -- unallocatedItems are items that have awarded bids that have yet to be
413: -- allocated
414: CURSOR unallocatedItems IS
415: SELECT distinct itm.line_number
416: FROM pon_auction_item_prices_all itm,
417: po_req_lines_in_pool_src_v prlv
418: WHERE itm.auction_header_id = p_auction_header_id AND
419: nvl(itm.line_origination_code, 'NONE') = 'REQUISITION' AND
420: nvl(itm.allocation_status, 'NO') <> 'ALLOCATED' AND

Line 431: FROM pon_auction_item_prices_all itm,

427: -- Allocation Failure notification, if line fails to be auto-allocated.
428: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_line_number NUMBER) IS
429: SELECT itm.document_disp_line_number, itm.item_number, itm.item_revision, itm.item_description,
430: itm.requisition_number, pjo.name
431: FROM pon_auction_item_prices_all itm,
432: per_jobs pjo
433: WHERE itm.auction_header_id = p_auction_header_id AND
434: itm.line_number = p_line_number AND
435: pjo.job_id (+) = itm.job_id;

Line 501: UPDATE pon_auction_item_prices_all

497: RETURN;
498: ELSE
499: -- update allocation status of item to allocated if allocation succeeded
500: log_message( l_api_name || 'update allocation status of item to allocated. Line num - ' || p_item_line_number);
501: UPDATE pon_auction_item_prices_all
502: SET allocation_status = 'ALLOCATED'
503: WHERE auction_header_id = p_auction_header_id and
504: line_number = p_item_line_number;
505: END IF;

Line 571: pon_auction_item_prices_all paip

567: -- the alloc quantity
568: CURSOR reqRescheduledSingleSupplier IS
569: SELECT paa.orig_req_line_id, prlsv.requisition_quantity
570: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
571: pon_auction_item_prices_all paip
572: WHERE paa.allocated_qty > prlsv.requisition_quantity AND
573: paa.auction_header_id = p_auction_header_id AND
574: nvl(paa.split_req_line_id, -999)= -999 AND
575: nvl(paa.allocated_qty,0) > 0 AND

Line 590: pon_auction_item_prices_all paip

586: -- of mrp rescheduling
587: CURSOR reqRescheduledMultSupplier IS
588: SELECT paa.orig_req_line_id
589: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
590: pon_auction_item_prices_all paip
591: WHERE paa.auction_header_id = p_auction_header_id AND
592: nvl(paa.split_req_line_id, -999)= -999 AND
593: nvl(paa.allocated_qty,0) > 0 AND
594: prlsv.requisition_line_id = paa.orig_req_line_id AND

Line 608: FROM pon_auction_item_prices_all itm,

604: -- Allocation Failure notification, if line fails to be auto-allocated.
605: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_orig_req_line_id NUMBER) IS
606: SELECT distinct paa.bid_line_number, itm.item_number, itm.item_revision, itm.item_description,
607: itm.requisition_number, pjo.name
608: FROM pon_auction_item_prices_all itm,
609: per_jobs pjo,
610: pon_award_allocations paa
611: WHERE paa.auction_header_id = itm.auction_header_id AND
612: paa.bid_line_number = itm.line_number AND

Line 966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;

962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
963: l_user_id NUMBER;
964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;
966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
967: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
968: l_contract_type pon_auction_headers_all.contract_type%TYPE;
969:
970:

Line 967: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;

963: l_user_id NUMBER;
964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;
966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
967: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
968: l_contract_type pon_auction_headers_all.contract_type%TYPE;
969:
970:
971: l_api_name VARCHAR2(30) := ' AUTO_REQ_ALLOCATION ';

Line 1019: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah

1015: l_clm_info_flag := l_empty_table;
1016:
1017: SELECT paip.order_type_lookup_code, paip.purchase_basis, pah.contract_type
1018: INTO l_order_type_lookup_code, l_purchase_basis, l_contract_type
1019: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah
1020: WHERE paip.auction_header_id = pah.auction_header_id
1021: AND paip.auction_header_id = p_auctionid
1022: AND paip.line_number = p_line_number;
1023:

Line 1047: FROM pon_auction_item_prices_all itm,

1043: bh.bid_number,
1044: bl.bid_currency_unit_price,
1045: Decode(Nvl(itm.clm_info_flag,'N'), 'Y', 1, 0) AS clm_info_indicator
1046: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col , l_clm_info_flag
1047: FROM pon_auction_item_prices_all itm,
1048: pon_bid_item_prices bl,
1049: pon_bid_headers bh,
1050: pon_auction_headers_all pah
1051: WHERE itm.auction_header_id = p_auctionID AND

Line 1628: FROM pon_auction_item_prices_all

1624: INTO x_requistion_based
1625: FROM DUAL
1626: WHERE EXISTS(
1627: SELECT '1'
1628: FROM pon_auction_item_prices_all
1629: WHERE auction_header_id = p_auction_header_id
1630: AND line_origination_code = 'REQUISITION'
1631: );
1632:

Line 1966: pon_auction_item_prices_all paip,

1962: ,pbip.CLM_PROMISE_PERIOD_UOM
1963: ,pbip.CLM_PROMISE_POP_DURATION
1964: ,pbip.CLM_PROMISE_POP_DURATION_UOM
1965: FROM
1966: pon_auction_item_prices_all paip,
1967: pon_bid_item_prices pbip,
1968: mtl_units_of_measure mtluom,
1969: pon_bid_headers pbh,
1970: fnd_currencies fc

Line 1991: FROM pon_award_allocations paa, pon_auction_item_prices_all paip

1987: * Use orig_req_line_id column.
1988: */
1989: CURSOR reqBackingBidItem IS
1990: SELECT Decode(Nvl(l_is_fed,'N'),'Y', paa.orig_req_line_id, paa.split_req_line_id), paa.allocated_qty
1991: FROM pon_award_allocations paa, pon_auction_item_prices_all paip
1992: WHERE paa.auction_header_id = p_auction_header_id and
1993: paa.bid_number = p_bid_number AND
1994: paa.auction_header_id = paip.auction_header_id and
1995: paa.bid_line_number = paip.line_number AND

Line 2018: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP

2014:
2015: */
2016: CURSOR sumOfReqAllocQuantities is
2017: SELECT PAIP.line_number, nvl(sum(nvl(PAA.allocated_qty,0)), 0)
2018: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP
2019: WHERE PAIP.auction_header_id = p_auction_header_id
2020: AND PAIP.award_status = 'COMPLETED'
2021: AND ((Nvl(clm_info_flag,'N')='Y') OR (Nvl(clm_info_flag,'N') = 'N' and nvl(PAIP.awarded_quantity,0) > 0))
2022: AND PAA.auction_header_id(+) = PAIP.auction_header_id

Line 2033: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP

2029: * To find the sum of allocation quantities, use orig_req_line_id column.
2030: */
2031: CURSOR clm_sumOfReqAllocQuantities is
2032: SELECT PAIP.line_number, nvl(sum(nvl(PAA.allocated_qty,0)), 0)
2033: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP
2034: WHERE PAIP.auction_header_id = p_auction_header_id
2035: AND PAIP.award_status = 'COMPLETED'
2036: AND ((Nvl(clm_info_flag,'N')='Y') OR (Nvl(clm_info_flag,'N') = 'N' and nvl(PAIP.awarded_quantity,0) > 0))
2037: AND PAA.auction_header_id(+) = PAIP.auction_header_id

Line 2336: check pon_auction_item_prices_all.order_type_lookup_code)

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-
2336: check pon_auction_item_prices_all.order_type_lookup_code)
2337: from the backing requisition.
2338: */
2339:
2340:

Line 3011: pon_auction_item_prices_all paip,

3007: ,Decode(Nvl(l_is_fed,'N'),'Y',pbip.CLM_PROMISE_POP_DURATION,null)
3008: ,Decode(Nvl(l_is_fed,'N'),'Y',pbip.CLM_PROMISE_POP_DURATION_UOM,null)
3009:
3010: FROM
3011: pon_auction_item_prices_all paip,
3012: pon_bid_item_prices pbip,
3013: mtl_units_of_measure mtluom,
3014: pon_bid_headers pbh,
3015: fnd_currencies fc,

Line 3157: FROM pon_auction_item_prices_all paip,

3153: x_user_id, -- last_updated_by
3154: sysdate, -- creation_date
3155: x_user_id -- created_by
3156:
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,

Line 3405: FROM pon_auction_item_prices_all paip,

3401: --CLM Order Off IDV Project
3402: , pbh.idv_header_id
3403: , pbip.idv_line_id
3404: , paip.exhibit_number --ELINs project
3405: FROM pon_auction_item_prices_all paip,
3406: pon_bid_item_prices pbip,
3407: mtl_units_of_measure mtluom,
3408: pon_bid_headers pbh,
3409: fnd_currencies fc,

Line 3551: FROM pon_auction_item_prices_all paip,

3547: , paip.CLM_CONTRACT_TYPE
3548: , paip.CLM_COST_CONSTRAINT
3549: , paip.CLM_IDC_TYPE
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

Line 4061: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;

4057:
4058: l_cur_interface_line_id NUMBER;
4059: l_cur_attr_values_id NUMBER;
4060: l_cur_attr_values_tlp_id NUMBER;
4061: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;
4062: l_cur_ip_category_id NUMBER;
4063: l_cur_item_id NUMBER;
4064: l_cur_org_id NUMBER;
4065: l_language_code pon_auction_headers_all.language_code%TYPE;

Line 4090: pon_auction_item_prices_all paip,

4086: icx.stored_in_column,
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

Line 5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;

5494: x_number_of_failed_pos NUMBER;
5495: x_email_type VARCHAR2(240);
5496: x_allocation_error VARCHAR2(2000);
5497: x_line_number NUMBER;
5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;

Line 5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;

5495: x_email_type VARCHAR2(240);
5496: x_allocation_error VARCHAR2(2000);
5497: x_line_number NUMBER;
5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;
5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;

Line 5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;

5496: x_allocation_error VARCHAR2(2000);
5497: x_line_number NUMBER;
5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;
5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
5504: l_resultout VARCHAR2(10);

Line 5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;

5497: x_line_number NUMBER;
5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;
5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
5504: l_resultout VARCHAR2(10);
5505:

Line 5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;

5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;
5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
5504: l_resultout VARCHAR2(10);
5505:
5506: x_open_bidding_date date;
5507: x_close_bidding_date date;

Line 5598: FROM pon_auction_item_prices_all

5594: INTO x_requistion_based
5595: FROM DUAL
5596: WHERE EXISTS(
5597: SELECT '1'
5598: FROM pon_auction_item_prices_all
5599: WHERE auction_header_id = p_auction_header_id
5600: AND line_origination_code = 'REQUISITION'
5601: );
5602:

Line 6167: FROM pon_auction_item_prices_all paip

6163: --Bug : 14134092 :For unsol lines, skip fund allocations from inventory destination req lines.
6164: AND (pbip.auction_line_number <> -1 OR (pbip.auction_line_number = -1 AND prl.destination_type_code = 'EXPENSE')));
6165: --Bug : 14134092 : When line type is enabled, fund allocation is done for autocreated lines also.
6166: /* AND NOT EXISTS (SELECT 1
6167: FROM pon_auction_item_prices_all paip
6168: WHERE paip.auction_header_id = pbrv.auction_header_id
6169: AND paip.line_number = pbrv.auction_line_number
6170: AND paip.line_origination_code = 'REQUISITION'));*/
6171: