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

Line 414: where entity_name = 'PON_AUCTION_HEADERS_ALL' and

410:
411: CURSOR discussion_id IS
412: select discussion_id
413: from pon_discussions
414: where entity_name = 'PON_AUCTION_HEADERS_ALL' and
415: pk1_value = to_char(p_auction_id);
416:
417: BEGIN
418:

Line 1084: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

1080: v_is_draft boolean := FALSE;
1081: v_most_recent_auction_id NUMBER;
1082: v_auction_status VARCHAR2(25);
1083: v_bidding_status VARCHAR2(25);
1084: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
1085: v_technical_lock_status pon_auction_headers_all.technical_lock_status%TYPE;
1086:
1087: BEGIN
1088:

Line 1085: v_technical_lock_status pon_auction_headers_all.technical_lock_status%TYPE;

1081: v_most_recent_auction_id NUMBER;
1082: v_auction_status VARCHAR2(25);
1083: v_bidding_status VARCHAR2(25);
1084: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
1085: v_technical_lock_status pon_auction_headers_all.technical_lock_status%TYPE;
1086:
1087: BEGIN
1088:
1089: IF (p_bidStatus IS NOT NULL AND p_bidStatus = 'DRAFT') THEN

Line 1117: FROM pon_auction_headers_all

1113: END IF;
1114:
1115: SELECT nvl(two_part_flag, 'N'), nvl(technical_lock_status, 'N')
1116: INTO v_two_part_flag, v_technical_lock_status
1117: FROM pon_auction_headers_all
1118: WHERE auction_header_id = p_auction_id;
1119:
1120: IF ((v_is_auction_sealed) AND
1121: ((v_two_part_flag = 'N' AND NOT p_sealed_auction_status = 'ACTIVE') OR (v_two_part_flag = 'Y' AND NOT v_technical_lock_status = 'ACTIVE')) AND

Line 1142: from pon_auction_headers_all ah,

1138: -- and active/draft responses page
1139:
1140: select max(ah.auction_header_id)
1141: into v_most_recent_auction_id
1142: from pon_auction_headers_all ah,
1143: pon_auction_headers_all ah2
1144: where ah.auction_status <> 'DRAFT'
1145: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
1146: and ah2.auction_header_id = p_auction_id;

Line 1143: pon_auction_headers_all ah2

1139:
1140: select max(ah.auction_header_id)
1141: into v_most_recent_auction_id
1142: from pon_auction_headers_all ah,
1143: pon_auction_headers_all ah2
1144: where ah.auction_status <> 'DRAFT'
1145: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
1146: and ah2.auction_header_id = p_auction_id;
1147:

Line 1152: from pon_auction_headers_all

1148: select auction_status,
1149: decode(sign(close_bidding_date - sysdate), 1, 'NOT_CLOSED', 'CLOSED')
1150: into v_auction_status,
1151: v_bidding_status
1152: from pon_auction_headers_all
1153: where auction_header_id = v_most_recent_auction_id;
1154:
1155: IF ((v_auction_status IS NOT NULL AND v_auction_status = 'CANCELLED') OR
1156: (v_bidding_status = 'CLOSED')) THEN