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_PKG dependencies on FND_LOOKUPS

Line 4918: auction_status_name = (select meaning from fnd_lookups

4914: x_progress := '020';
4915:
4916: update pon_auction_headers_all
4917: set auction_status = 'OPEN_FOR_BIDDING',
4918: auction_status_name = (select meaning from fnd_lookups
4919: where lookup_type = 'PON_AUCTION_STATUS' and
4920: lookup_code = 'OPEN_FOR_BIDDING')
4921: where auction_header_id = x_auction_header_id;
4922:

Line 4948: auction_status_name = (select meaning from fnd_lookups

4944: x_progress := '020';
4945:
4946: update pon_auction_headers_all
4947: set auction_status = 'CLOSED_FOR_BIDDING',
4948: auction_status_name = (select meaning from fnd_lookups
4949: where lookup_type = 'PON_AUCTION_STATUS' and
4950: lookup_code = 'CLOSED_FOR_BIDDING')
4951: where auction_header_id = x_auction_header_id;
4952:

Line 13250: l_buyer_meaning fnd_lookups.meaning%type;

13246: );
13247: END IF;
13248:
13249: DECLARE
13250: l_buyer_meaning fnd_lookups.meaning%type;
13251: l_buyer_sealed_meaning fnd_lookups.meaning%type;
13252:
13253: BEGIN
13254: SELECT fl.meaning,

Line 13251: l_buyer_sealed_meaning fnd_lookups.meaning%type;

13247: END IF;
13248:
13249: DECLARE
13250: l_buyer_meaning fnd_lookups.meaning%type;
13251: l_buyer_sealed_meaning fnd_lookups.meaning%type;
13252:
13253: BEGIN
13254: SELECT fl.meaning,
13255: nvl2(pav.sealed_auction_status,

Line 13258: from fnd_lookups

13254: SELECT fl.meaning,
13255: nvl2(pav.sealed_auction_status,
13256: ' (' ||
13257: (select meaning
13258: from fnd_lookups
13259: where lookup_type = 'PON_SEALED_AUCTION_STATUS'
13260: and (
13261: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13262: or lookup_code = pav.technical_lock_status))

Line 13265: FROM fnd_lookups fl, pon_auction_headers_all_v pav

13261: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13262: or lookup_code = pav.technical_lock_status))
13263: ||')', '')
13264: INTO l_buyer_meaning, l_buyer_sealed_meaning
13265: FROM fnd_lookups fl, pon_auction_headers_all_v pav
13266: WHERE pav.auction_header_id = p_auction_header_id
13267: AND fl.lookup_type = 'PON_AUCTION_STATUS'
13268: AND fl.lookup_code = pav.negotiation_status;
13269:

Line 13300: l_supp_meaning fnd_lookups.meaning%type;

13296: );
13297: END IF;
13298:
13299: DECLARE
13300: l_supp_meaning fnd_lookups.meaning%type;
13301: l_supp_sealed_meaning fnd_lookups.meaning%type;
13302:
13303: BEGIN
13304: SELECT fl.meaning, nvl2(pav.sealed_auction_status,

Line 13301: l_supp_sealed_meaning fnd_lookups.meaning%type;

13297: END IF;
13298:
13299: DECLARE
13300: l_supp_meaning fnd_lookups.meaning%type;
13301: l_supp_sealed_meaning fnd_lookups.meaning%type;
13302:
13303: BEGIN
13304: SELECT fl.meaning, nvl2(pav.sealed_auction_status,
13305: ' (' || (select meaning

Line 13306: from fnd_lookups

13302:
13303: BEGIN
13304: SELECT fl.meaning, nvl2(pav.sealed_auction_status,
13305: ' (' || (select meaning
13306: from fnd_lookups
13307: where lookup_type = 'PON_SEALED_AUCTION_STATUS'
13308: and (
13309: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13310: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )

Line 13313: FROM fnd_lookups fl, pon_auction_headers_all_v pav

13309: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13310: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )
13311: ||')', '')
13312: INTO l_supp_meaning, l_supp_sealed_meaning
13313: FROM fnd_lookups fl, pon_auction_headers_all_v pav
13314: WHERE pav.auction_header_id = p_auction_header_id
13315: AND fl.lookup_type = 'PON_AUCTION_STATUS'
13316: AND fl.lookup_code = pav.suppl_negotiation_status;
13317:

Line 13352: SELECT (SELECT meaning from fnd_lookups

13348: END IF;
13349:
13350:
13351: -- get the meanings of the technical and commercial locks for use later
13352: SELECT (SELECT meaning from fnd_lookups
13353: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
13354: lookup_code = nvl(technical_lock_status,'')), --technical status
13355: (SELECT meaning from fnd_lookups
13356: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and

Line 13355: (SELECT meaning from fnd_lookups

13351: -- get the meanings of the technical and commercial locks for use later
13352: SELECT (SELECT meaning from fnd_lookups
13353: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
13354: lookup_code = nvl(technical_lock_status,'')), --technical status
13355: (SELECT meaning from fnd_lookups
13356: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
13357: lookup_code = nvl(sealed_auction_status,'')) --commercial status
13358: INTO l_technical_lock_meaning, l_commercial_lock_meaning
13359: FROM pon_auction_headers_all