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_ITEM_PRICES_ALL

Line 29: AND exhibit_number NOT IN (SELECT exhibit_number FROM pon_auction_item_prices_ALL items

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:
32: EXCEPTION
33: WHEN NO_DATA_FOUND THEN

Line 48: FROM pon_auction_item_prices_ALL items

44: begin
45:
46: /* SELECT exhibit_number
47: INTO p_EXHIBIT_NUMBER
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

Line 76: FROM pon_auction_item_prices_ALL items

72: SYSDATE,
73: p_CREATED_BY,
74: SYSDATE,
75: p_LAST_UPDATED_BY
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

Line 119: FROM pon_auction_item_prices_all

115: AND IS_CDRL='N';
116:
117: SELECT Count(*)
118: INTO number_of_lines
119: FROM pon_auction_item_prices_all
120: WHERE auction_header_id=p_auction_header_id
121: AND exhibit_number=p_exhibit_number
122: AND ROWNUM=1;
123:

Line 193: FROM pon_auction_item_prices_all

189: END IF;
190:
191: SELECT Count(*)
192: INTO number_of_lines
193: FROM pon_auction_item_prices_all
194: WHERE auction_header_id=p_auction_header_id
195: AND exhibit_number=p_exhibit_number
196: AND ROWNUM=1;
197:

Line 234: NOT IN (SELECT line_number FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID=p_auction_header_id);

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);
235: END IF;
236:
237:
238:

Line 421: FROM pon_auction_item_prices_all

417: LOG_MESSAGE('copy_lines','IS_EXHIBITS_ENABLED_FOR_AUC:'||'Y' );
418:
419: SELECT line_number
420: BULK COLLECT INTO p_lines
421: FROM pon_auction_item_prices_all
422: WHERE auction_header_id = p_auction_header_id
423: AND exhibit_number = p_exhibit_number;
424:
425: LOG_MESSAGE('copy_lines','After Collecting the line number of the exhibit Lines' );

Line 433: FROM pon_auction_item_prices_all WHERE

429: LOG_MESSAGE('copy_lines','New Exhibit Generated:'||p_new_exhibit_number );
430:
431: SELECT Max(line_number)
432: INTO p_initial_line_number
433: FROM pon_auction_item_prices_all WHERE
434: auction_header_id = p_auction_header_id;
435:
436: LOG_MESSAGE('copy_lines','p_initial_line_number:'||p_initial_line_number );
437:

Line 443: FROM pon_auction_item_prices_all WHERE

439: p_result,p_error_code,p_error_message);
440:
441: SELECT Max(line_number)
442: INTO p_final_line_number
443: FROM pon_auction_item_prices_all WHERE
444: auction_header_id = p_auction_header_id;
445:
446:
447: LOG_MESSAGE('copy_lines','p_final_line_number:'||p_final_line_number );

Line 460: UPDATE pon_auction_item_prices_all

456: CONNECT BY LEVEL <=p_final_line_number-p_initial_line_number+1);
457:
458:
459: FORALL i IN 1..p_line_num_displays.count
460: UPDATE pon_auction_item_prices_all
461: SET exhibit_number = p_new_exhibit_number,
462: line_num_display=p_line_num_displays(i)
463: WHERE auction_header_id = p_auction_header_id
464: AND line_number=p_line_numbers(i)+p_initial_line_number;

Line 475: FROM pon_auction_item_prices_all

471: LOG_MESSAGE('copy_lines','Copy Lines Completed' );
472:
473: SELECT NVL(MAX(line_number),0)
474: INTO P_LINE_NUMBER
475: FROM pon_auction_item_prices_all
476: WHERE auction_header_id = p_source_auction_header_id;
477:
478: SELECT Count(*)
479: INTO P_NO_OF_LINES

Line 480: FROM pon_auction_item_prices_all

476: WHERE auction_header_id = p_source_auction_header_id;
477:
478: SELECT Count(*)
479: INTO P_NO_OF_LINES
480: FROM pon_auction_item_prices_all
481: WHERE auction_header_id = p_source_auction_header_id;
482:
483: UPDATE PON_AUCTION_HEADERS_ALL
484: SET NUMBER_OF_LINES = P_NO_OF_LINES,

Line 519: FROM pon_auction_item_prices_all

515: LOG_MESSAGE('delete_lines','IS_EXHIBITS_ENABLED_FOR_AUC:'||'Y' );
516:
517: SELECT line_number
518: BULK COLLECT INTO p_lines
519: FROM pon_auction_item_prices_all
520: WHERE auction_header_id = p_auction_header_id
521: AND exhibit_number = p_exhibit_number;
522:
523: LOG_MESSAGE('delete_lines','After Collecting the line number of the exhibit Lines' );

Line 546: FROM pon_auction_item_prices_all

542: LOG_MESSAGE('delete_lines','Delete Lines Completed' );
543:
544: SELECT NVL(MAX(line_number),0)
545: INTO P_LINE_NUMBER
546: FROM pon_auction_item_prices_all
547: WHERE auction_header_id = p_source_auction_header_id;
548:
549: SELECT Count(*)
550: INTO P_NO_OF_LINES

Line 551: FROM pon_auction_item_prices_all

547: WHERE auction_header_id = p_source_auction_header_id;
548:
549: SELECT Count(*)
550: INTO P_NO_OF_LINES
551: FROM pon_auction_item_prices_all
552: WHERE auction_header_id = p_source_auction_header_id;
553:
554: UPDATE PON_AUCTION_HEADERS_ALL
555: SET NUMBER_OF_LINES = P_NO_OF_LINES,

Line 609: FROM pon_auction_item_prices_all

605: BEGIN
606:
607: SELECT Decode(Nvl(exhibit_number, '-1'), '-1' , 'N', 'Y')
608: INTO l_is_elin
609: FROM pon_auction_item_prices_all
610: WHERE auction_header_id = p_auction_header_id
611: AND line_number = p_line_number;
612:
613: RETURN l_is_elin;