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_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUCTION_HEADERS_ALL

Line 69: pon_auction_headers_all ah

65:
66: SELECT '_' || dt.message_suffix
67: INTO l_suffix
68: FROM pon_auc_doctypes dt,
69: pon_auction_headers_all ah
70: WHERE dt.doctype_id = ah.doctype_id
71: AND ah.auction_header_id = p_auction_id
72: AND rownum =1;
73:

Line 207: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;

203:
204: PROCEDURE validateAwardBid(p_batch_Id IN NUMBER,
205: p_spreadsheet_type IN VARCHAR2) IS
206: --
207: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
208: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
209: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
210: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
211: l_suffix VARCHAR2(3);

Line 208: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;

204: PROCEDURE validateAwardBid(p_batch_Id IN NUMBER,
205: p_spreadsheet_type IN VARCHAR2) IS
206: --
207: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
208: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
209: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
210: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
211: l_suffix VARCHAR2(3);
212: l_user_id NUMBER;

Line 209: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

205: p_spreadsheet_type IN VARCHAR2) IS
206: --
207: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
208: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
209: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
210: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
211: l_suffix VARCHAR2(3);
212: l_user_id NUMBER;
213: l_login_id NUMBER;

Line 210: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;

206: --
207: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
208: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
209: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
210: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
211: l_suffix VARCHAR2(3);
212: l_user_id NUMBER;
213: l_login_id NUMBER;
214: l_exp_date DATE;

Line 244: from pon_auction_headers_all paha,

240: l_exp_date := SYSDATE+7;
241:
242: select paha.auction_header_id , paha.request_id, paha.contract_type, paha.price_tiers_indicator
243: into l_auction_id, l_request_id, l_contract_type, l_price_tiers_indicator
244: from pon_auction_headers_all paha,
245: pon_award_items_interface paii
246: where paii.auction_header_id = paha.auction_header_id
247: and paii.batch_id = p_batch_id
248: and rownum = 1;

Line 727: pon_auction_headers_all ah,

723: , 'LINE_NUMBER'
724: , ai.document_disp_line_number
725: FROM PON_AWARD_ITEMS_INTERFACE paii,
726: pon_auction_item_prices_all ai,
727: pon_auction_headers_all ah,
728: po_line_types_tl pltt
729: WHERE paii.batch_id = p_batch_id
730: AND paii.award_status = 'Y'
731: AND ah.auction_header_id = paii.auction_header_id

Line 1397: from pon_auction_headers_all ah,

1393: BEGIN
1394:
1395: select ah.po_style_id
1396: into x_po_style_id
1397: from pon_auction_headers_all ah,
1398: pon_item_prices_interface ipi
1399: where ipi.batch_id = p_batch_id
1400: and ipi.auction_header_id = ah.auction_header_id
1401: and rownum = 1;

Line 1491: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;

1487: l_amount_based_uom VARCHAR2(25);
1488: l_amount_based_unit_of_measure VARCHAR2(25);
1489: l_item_number_delimiter varchar2(1);
1490: l_inventory_org_id number;
1491: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1492: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1493: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1494: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1495: l_line_type_restriction VARCHAR2(30);

Line 1492: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;

1488: l_amount_based_unit_of_measure VARCHAR2(25);
1489: l_item_number_delimiter varchar2(1);
1490: l_inventory_org_id number;
1491: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1492: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1493: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1494: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1495: l_line_type_restriction VARCHAR2(30);
1496: l_auction_header_id NUMBER;

Line 1493: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;

1489: l_item_number_delimiter varchar2(1);
1490: l_inventory_org_id number;
1491: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1492: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1493: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1494: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1495: l_line_type_restriction VARCHAR2(30);
1496: l_auction_header_id NUMBER;
1497: l_auction_round_number NUMBER;

Line 1494: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;

1490: l_inventory_org_id number;
1491: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1492: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1493: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1494: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1495: l_line_type_restriction VARCHAR2(30);
1496: l_auction_header_id NUMBER;
1497: l_auction_round_number NUMBER;
1498:

Line 1507: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;

1503: l_sol_line_count NUMBER;
1504: l_int_line_count NUMBER;
1505: l_price_break_type VARCHAR2(4000);
1506: l_price_break_neg_flag VARCHAR2(4000);
1507: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
1508: l_cumulative VARCHAR2(4000);
1509: l_noncumulative VARCHAR2(4000);
1510: l_required VARCHAR2(4000);
1511: l_optional VARCHAR2(4000);

Line 1585: pon_auction_headers_all

1581: l_progress_payment_type,
1582: l_advance_negotiable_flag,
1583: l_recoupment_negotiable_flag
1584: FROM
1585: pon_auction_headers_all
1586: WHERE
1587: auction_header_id = l_auction_header_id;
1588:
1589: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 1606: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = l_auction_header_id;

1602:
1603: --clm clin/slin change
1604: BEGIN
1605:
1606: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = l_auction_header_id;
1607:
1608: SELECT
1609: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1610: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

Line 3783: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

3779: PON_AUCTION_PKG.get_default_pb_settings (l_auction_header_id,
3780: l_price_break_type,
3781: l_price_break_neg_flag);
3782:
3783: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3784:
3785: IF(l_price_tiers_indicator = 'PRICE_BREAKS' ) THEN
3786:
3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');

Line 3854: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

3850: AND group_type <> 'GROUP'
3851: and batch_id = p_batch_id;
3852:
3853:
3854: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3855:
3856: -- Validate price break seetings
3857: insert into PON_INTERFACE_ERRORS
3858: (interface_type,

Line 3930: AND Nvl((SELECT global_agreement_flag FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id),'N') = 'Y'

3926: null, -- TOKEN1_VALUE
3927: interface_line_id
3928: FROM pon_item_prices_interface p1
3929: where price_break_type = 'CUMULATIVE'
3930: AND Nvl((SELECT global_agreement_flag FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id),'N') = 'Y'
3931: AND ORDER_TYPE_LOOKUP_CODE NOT IN( 'AMOUNT','FIXED PRICE')
3932: AND Nvl(clm_info_flag,'N') <> 'Y'
3933: AND group_type <> 'GROUP'
3934: AND batch_id = p_batch_id;