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.

[Home] [Help]

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 185: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;

181:
182: PROCEDURE validateAwardBid(p_batch_Id IN NUMBER,
183: p_spreadsheet_type IN VARCHAR2) IS
184: --
185: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
186: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
187: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
188: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
189: l_suffix VARCHAR2(3);

Line 186: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;

182: PROCEDURE validateAwardBid(p_batch_Id IN NUMBER,
183: p_spreadsheet_type IN VARCHAR2) IS
184: --
185: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
186: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
187: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
188: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
189: l_suffix VARCHAR2(3);
190: l_user_id NUMBER;

Line 187: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

183: p_spreadsheet_type IN VARCHAR2) IS
184: --
185: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
186: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
187: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
188: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
189: l_suffix VARCHAR2(3);
190: l_user_id NUMBER;
191: l_login_id NUMBER;

Line 188: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;

184: --
185: l_auction_id PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
186: l_request_id PON_AUCTION_HEADERS_ALL.request_id%TYPE;
187: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
188: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.price_tiers_indicator%TYPE;
189: l_suffix VARCHAR2(3);
190: l_user_id NUMBER;
191: l_login_id NUMBER;
192: l_exp_date DATE;

Line 221: from pon_auction_headers_all paha,

217: l_exp_date := SYSDATE+7;
218:
219: select paha.auction_header_id , paha.request_id, paha.contract_type, paha.price_tiers_indicator
220: into l_auction_id, l_request_id, l_contract_type, l_price_tiers_indicator
221: from pon_auction_headers_all paha,
222: pon_award_items_interface paii
223: where paii.auction_header_id = paha.auction_header_id
224: and paii.batch_id = p_batch_id
225: and rownum = 1;

Line 703: pon_auction_headers_all ah,

699: , 'LINE_NUMBER'
700: , ai.document_disp_line_number
701: FROM PON_AWARD_ITEMS_INTERFACE paii,
702: pon_auction_item_prices_all ai,
703: pon_auction_headers_all ah,
704: po_line_types_tl pltt
705: WHERE paii.batch_id = p_batch_id
706: AND paii.award_status = 'Y'
707: AND ah.auction_header_id = paii.auction_header_id

Line 1346: from pon_auction_headers_all ah,

1342: BEGIN
1343:
1344: select ah.po_style_id
1345: into x_po_style_id
1346: from pon_auction_headers_all ah,
1347: pon_item_prices_interface ipi
1348: where ipi.batch_id = p_batch_id
1349: and ipi.auction_header_id = ah.auction_header_id
1350: and rownum = 1;

Line 1439: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;

1435: l_amount_based_uom VARCHAR2(25);
1436: l_amount_based_unit_of_measure VARCHAR2(25);
1437: l_item_number_delimiter varchar2(1);
1438: l_inventory_org_id number;
1439: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1440: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1441: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1442: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1443: l_line_type_restriction VARCHAR2(30);

Line 1440: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;

1436: l_amount_based_unit_of_measure VARCHAR2(25);
1437: l_item_number_delimiter varchar2(1);
1438: l_inventory_org_id number;
1439: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1440: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1441: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1442: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1443: l_line_type_restriction VARCHAR2(30);
1444: l_auction_header_id NUMBER;

Line 1441: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;

1437: l_item_number_delimiter varchar2(1);
1438: l_inventory_org_id number;
1439: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1440: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1441: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1442: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1443: l_line_type_restriction VARCHAR2(30);
1444: l_auction_header_id NUMBER;
1445: l_auction_round_number NUMBER;

Line 1442: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;

1438: l_inventory_org_id number;
1439: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
1440: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
1441: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
1442: l_po_style_id PON_AUCTION_HEADERS_ALL.po_style_id%TYPE;
1443: l_line_type_restriction VARCHAR2(30);
1444: l_auction_header_id NUMBER;
1445: l_auction_round_number NUMBER;
1446: --

Line 1494: pon_auction_headers_all

1490: l_progress_payment_type,
1491: l_advance_negotiable_flag,
1492: l_recoupment_negotiable_flag
1493: FROM
1494: pon_auction_headers_all
1495: WHERE
1496: auction_header_id = l_auction_header_id;
1497:
1498: if(l_auction_round_number > 1) then