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_EXHIBITS_PKG dependencies on PON_AUCTION_EXHIBIT_DETAILS

Line 24: DELETE FROM pon_auction_exhibit_details WHERE auction_header_id=p_auction_header_id

20:
21:
22: BEGIN
23:
24: DELETE FROM pon_auction_exhibit_details WHERE auction_header_id=p_auction_header_id
25: AND IS_CDRL = 'N'
26: AND exhibit_number in
27: (SELECT exhibits.exhibit_number FROM pon_auction_exhibit_details exhibits WHERE exhibits.auction_header_id=p_auction_header_id
28: AND IS_CDRL='N'

Line 27: (SELECT exhibits.exhibit_number FROM pon_auction_exhibit_details exhibits WHERE exhibits.auction_header_id=p_auction_header_id

23:
24: DELETE FROM pon_auction_exhibit_details WHERE auction_header_id=p_auction_header_id
25: AND IS_CDRL = 'N'
26: AND exhibit_number in
27: (SELECT exhibits.exhibit_number FROM pon_auction_exhibit_details exhibits WHERE exhibits.auction_header_id=p_auction_header_id
28: AND IS_CDRL='N'
29: AND exhibit_number NOT IN (SELECT exhibit_number FROM pon_auction_item_prices_ALL items
30: WHERE items.auction_header_id=p_auction_header_id AND items.exhibit_number=exhibits.exhibit_number));
31:

Line 52: (SELECT exhibit_number FROM pon_auction_exhibit_details exhibits

48: FROM pon_auction_item_prices_ALL items
49: WHERE items.auction_header_id=p_auction_header_id
50: AND items.exhibit_number IS NOT NULL
51: AND NOT EXISTS
52: (SELECT exhibit_number FROM pon_auction_exhibit_details exhibits
53: WHERE auction_header_id=p_auction_header_id AND IS_CDRL='N' AND items.exhibit_number=exhibits.exhibit_number)
54: AND ROWNUM=1;*/
55:
56: INSERT INTO pon_auction_exhibit_details

Line 56: INSERT INTO pon_auction_exhibit_details

52: (SELECT exhibit_number FROM pon_auction_exhibit_details exhibits
53: WHERE auction_header_id=p_auction_header_id AND IS_CDRL='N' AND items.exhibit_number=exhibits.exhibit_number)
54: AND ROWNUM=1;*/
55:
56: INSERT INTO pon_auction_exhibit_details
57: (AUCTION_HEADER_ID,
58: EXHIBIT_NUMBER,
59: IS_CDRL,
60: ASSOCIATED_TO_LINE,

Line 80: (SELECT exhibit_number FROM pon_auction_exhibit_details exhibits

76: FROM pon_auction_item_prices_ALL items
77: WHERE items.auction_header_id=p_auction_header_id
78: AND items.exhibit_number IS NOT NULL
79: AND NOT EXISTS
80: (SELECT exhibit_number FROM pon_auction_exhibit_details exhibits
81: WHERE auction_header_id=p_auction_header_id AND IS_CDRL='N' AND items.exhibit_number=exhibits.exhibit_number)
82: GROUP BY exhibit_number);
83:
84: EXCEPTION

Line 112: FROM pon_auction_exhibit_details

108: BEGIN
109:
110: SELECT Count(*)
111: INTO number_of_exhibits
112: FROM pon_auction_exhibit_details
113: WHERE auction_header_id=p_auction_header_id
114: AND exhibit_number=p_exhibit_number
115: AND IS_CDRL='N';
116:

Line 126: INSERT INTO pon_auction_exhibit_details

122: AND ROWNUM=1;
123:
124:
125: IF(number_of_exhibits=0 AND number_of_lines>0) THEN
126: INSERT INTO pon_auction_exhibit_details
127: (AUCTION_HEADER_ID,
128: EXHIBIT_NUMBER,
129: IS_CDRL,
130: CREATION_DATE,

Line 200: DELETE from pon_auction_exhibit_details

196: AND ROWNUM=1;
197:
198:
199: IF(number_of_lines=0) then
200: DELETE from pon_auction_exhibit_details
201: WHERE auction_header_id=p_auction_header_id
202: AND exhibit_number=p_exhibit_number
203: AND IS_CDRL='N';
204:

Line 224: UPDATE pon_auction_exhibit_details

220: IF(IS_EXHIBITS_ENABLED_FOR_AUC(p_auction_header_id) = 'N') THEN
221: RETURN;
222: END IF;
223: IF(p_line_number IS NOT NULL) THEN
224: UPDATE pon_auction_exhibit_details
225: SET ASSOCIATED_TO_LINE=NULL
226: WHERE AUCTION_HEADER_ID=p_auction_header_id
227: AND ASSOCIATED_TO_LINE = p_line_number;
228:

Line 230: UPDATE pon_auction_exhibit_details

226: WHERE AUCTION_HEADER_ID=p_auction_header_id
227: AND ASSOCIATED_TO_LINE = p_line_number;
228:
229: else
230: UPDATE pon_auction_exhibit_details
231: SET ASSOCIATED_TO_LINE=NULL
232: WHERE AUCTION_HEADER_ID=p_auction_header_id
233: AND ASSOCIATED_TO_LINE
234: NOT IN (SELECT line_number FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID=p_auction_header_id);

Line 364: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)

360: from fnd_lookup_values
361: where lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
362: AND Length(lookup_code) = 1
363: AND lookup_code NOT IN
364: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)
365: ORDER BY lookup_code)
366: WHERE ROWNUM=1;
367:
368: ELSE

Line 375: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)

371: FROM (select lookup_code
372: from fnd_lookup_values
373: where lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
374: AND lookup_code NOT IN
375: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)
376: ORDER BY length(lookup_code), lookup_code)
377: WHERE ROWNUM=1;
378: END IF;
379:

Line 588: FROM pon_auction_exhibit_details

584:
585: BEGIN
586: SELECT Count(*)
587: INTO l_elin_count
588: FROM pon_auction_exhibit_details
589: WHERE auction_header_id = p_auction_header_id
590: AND associated_to_line = p_line_number
591: AND Nvl(is_cdrl, 'N') = 'N';
592:

Line 678: FROM pon_auction_exhibit_details

674:
675: BEGIN
676: SELECT Nvl(is_cdrl, 'E')
677: INTO l_cdrl_exists
678: FROM pon_auction_exhibit_details
679: WHERE auction_header_id=p_auction_header_id
680: AND exhibit_number=p_exhibit_number;
681: EXCEPTION
682: WHEN No_Data_Found THEN

Line 698: INSERT INTO pon_auction_exhibit_details

694: END IF;
695:
696: l_user_id := fnd_global.user_id();
697:
698: INSERT INTO pon_auction_exhibit_details
699: (AUCTION_HEADER_ID,
700: EXHIBIT_NUMBER,
701: IS_CDRL,
702: ASSOCIATED_TO_LINE,

Line 715: /* This api will delete cdrl exhibit record from pon_auction_exhibit_details table.

711: x_return_status := 'S';
712:
713: END INSERT_CDRL_EXHIBIT_DETAILS;
714:
715: /* This api will delete cdrl exhibit record from pon_auction_exhibit_details table.
716: * This api should be called by okc code.
717: */
718: PROCEDURE DELETE_CDRL_EXHIBIT_DETAILS(p_auction_header_id IN NUMBER,
719: p_exhibit_number IN VARCHAR2,

Line 726: DELETE FROM pon_auction_exhibit_details

722: IS
723:
724: BEGIN
725:
726: DELETE FROM pon_auction_exhibit_details
727: WHERE auction_header_id = p_auction_header_id
728: AND exhibit_number = p_exhibit_number
729: AND is_cdrl = 'Y';
730: