DBA Data[Home] [Help]

APPS.PON_CONSOLE_PVT dependencies on DUAL

Line 27: -- The external procedure returns the dates individually in separate

23: --- |
24: --- +=======================================================================+
25: ---
26:
27: -- The external procedure returns the dates individually in separate
28: -- columns since Java does not understand arrays. Internally, the
29: -- procedures pass around an array of dates
30:
31: TYPE datetbltype IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1036: FROM dual

1032: IF NVL(p_auction_line_number, -1) = -1
1033: THEN
1034: SELECT 'N'
1035: INTO x_est_qty_available_flag
1036: FROM dual
1037: WHERE EXISTS (SELECT 1
1038: FROM pon_auction_item_prices_all al
1039: WHERE al.auction_header_id = p_auction_header_id
1040: AND al.group_type NOT IN ('GROUP','LOT_LINE')

Line 1046: FROM dual

1042: AND NVL(quantity, 0) = 0);
1043: ELSE
1044: SELECT 'N'
1045: INTO x_est_qty_available_flag
1046: FROM dual
1047: WHERE EXISTS (SELECT 1
1048: FROM pon_auction_item_prices_all al
1049: WHERE al.auction_header_id = p_auction_header_id
1050: AND al.line_number = p_auction_line_number