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 5514: auction_status_name = (select meaning from fnd_lookups

5510: x_progress := '020';
5511:
5512: update pon_auction_headers_all
5513: set auction_status = 'OPEN_FOR_BIDDING',
5514: auction_status_name = (select meaning from fnd_lookups
5515: where lookup_type = 'PON_AUCTION_STATUS' and
5516: lookup_code = 'OPEN_FOR_BIDDING')
5517: where auction_header_id = x_auction_header_id;
5518:

Line 5544: auction_status_name = (select meaning from fnd_lookups

5540: x_progress := '020';
5541:
5542: update pon_auction_headers_all
5543: set auction_status = 'CLOSED_FOR_BIDDING',
5544: auction_status_name = (select meaning from fnd_lookups
5545: where lookup_type = 'PON_AUCTION_STATUS' and
5546: lookup_code = 'CLOSED_FOR_BIDDING')
5547: where auction_header_id = x_auction_header_id;
5548:

Line 14109: l_buyer_meaning fnd_lookups.meaning%type;

14105: );
14106: END IF;
14107:
14108: DECLARE
14109: l_buyer_meaning fnd_lookups.meaning%type;
14110: l_buyer_sealed_meaning fnd_lookups.meaning%type;
14111:
14112: BEGIN
14113: SELECT fl.meaning,

Line 14110: l_buyer_sealed_meaning fnd_lookups.meaning%type;

14106: END IF;
14107:
14108: DECLARE
14109: l_buyer_meaning fnd_lookups.meaning%type;
14110: l_buyer_sealed_meaning fnd_lookups.meaning%type;
14111:
14112: BEGIN
14113: SELECT fl.meaning,
14114: nvl2(pav.sealed_auction_status,

Line 14117: from fnd_lookups

14113: SELECT fl.meaning,
14114: nvl2(pav.sealed_auction_status,
14115: ' (' ||
14116: (select meaning
14117: from fnd_lookups
14118: where lookup_type = 'PON_SEALED_AUCTION_STATUS'
14119: and (
14120: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14121: or lookup_code = pav.technical_lock_status))

Line 14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14120: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14121: or lookup_code = pav.technical_lock_status))
14122: ||')', '')
14123: INTO l_buyer_meaning, l_buyer_sealed_meaning
14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14125: WHERE pav.auction_header_id = p_auction_header_id
14126: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14127: AND fl.lookup_code = pav.negotiation_status;
14128:

Line 14159: l_supp_meaning fnd_lookups.meaning%type;

14155: );
14156: END IF;
14157:
14158: DECLARE
14159: l_supp_meaning fnd_lookups.meaning%type;
14160: l_supp_sealed_meaning fnd_lookups.meaning%type;
14161:
14162: BEGIN
14163: SELECT fl.meaning, nvl2(pav.sealed_auction_status,

Line 14160: l_supp_sealed_meaning fnd_lookups.meaning%type;

14156: END IF;
14157:
14158: DECLARE
14159: l_supp_meaning fnd_lookups.meaning%type;
14160: l_supp_sealed_meaning fnd_lookups.meaning%type;
14161:
14162: BEGIN
14163: SELECT fl.meaning, nvl2(pav.sealed_auction_status,
14164: ' (' || (select meaning

Line 14165: from fnd_lookups

14161:
14162: BEGIN
14163: SELECT fl.meaning, nvl2(pav.sealed_auction_status,
14164: ' (' || (select meaning
14165: from fnd_lookups
14166: where lookup_type = 'PON_SEALED_AUCTION_STATUS'
14167: and (
14168: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14169: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )

Line 14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14168: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14169: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )
14170: ||')', '')
14171: INTO l_supp_meaning, l_supp_sealed_meaning
14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14173: WHERE pav.auction_header_id = p_auction_header_id
14174: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14175: AND fl.lookup_code = pav.suppl_negotiation_status;
14176:

Line 14211: SELECT (SELECT meaning from fnd_lookups

14207: END IF;
14208:
14209:
14210: -- get the meanings of the technical and commercial locks for use later
14211: SELECT (SELECT meaning from fnd_lookups
14212: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
14213: lookup_code = nvl(technical_lock_status,'')), --technical status
14214: (SELECT meaning from fnd_lookups
14215: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and

Line 14214: (SELECT meaning from fnd_lookups

14210: -- get the meanings of the technical and commercial locks for use later
14211: SELECT (SELECT meaning from fnd_lookups
14212: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
14213: lookup_code = nvl(technical_lock_status,'')), --technical status
14214: (SELECT meaning from fnd_lookups
14215: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
14216: lookup_code = nvl(sealed_auction_status,'')) --commercial status
14217: INTO l_technical_lock_meaning, l_commercial_lock_meaning
14218: FROM pon_auction_headers_all