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_UNSOL_UTIL_PKG dependencies on PON_BID_ITEM_PRICES

Line 31: pon_bid_item_prices_ext_b

27: line_number = p_line_number;
28:
29: IF PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id) = 1 THEN
30: DELETE FROM
31: pon_bid_item_prices_ext_b
32: WHERE
33: bid_number = p_bid_number AND
34: line_number = p_line_number;
35:

Line 44: x_entity_name => 'PON_BID_ITEM_PRICES',

40: END IF;
41: END IF;
42:
43: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
44: x_entity_name => 'PON_BID_ITEM_PRICES',
45: x_pk1_value => p_auction_header_id,
46: x_pk2_value => p_bid_number,
47: x_pk3_value => p_line_number);
48:

Line 56: pon_bid_item_prices

52: message => 'Deleted the line attachments');
53: END IF;
54:
55: DELETE FROM
56: pon_bid_item_prices
57: WHERE
58: bid_number = p_bid_number AND
59: line_number = p_line_number;
60:

Line 80: l_line_number pon_bid_item_prices.line_number%TYPE;

76:
77: IS
78:
79: l_module_name VARCHAR2 (30);
80: l_line_number pon_bid_item_prices.line_number%TYPE;
81:
82: CURSOR SlinLines IS
83: SELECT
84: line_number

Line 85: FROM pon_bid_item_prices

81:
82: CURSOR SlinLines IS
83: SELECT
84: line_number
85: FROM pon_bid_item_prices
86: WHERE auction_header_id = p_auction_header_id
87: AND bid_number = p_bid_number
88: AND group_line_id = p_line_number;
89:

Line 115: pon_bid_item_prices

111: line_number
112: INTO
113: l_line_number
114: FROM
115: pon_bid_item_prices
116: WHERE
117: auction_header_id = p_auction_header_id and
118: bid_number = p_bid_number and
119: line_number = p_line_number;

Line 159: FROM pon_bid_item_prices

155: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
156:
157: CURSOR all_lines IS
158: SELECT line_number
159: FROM pon_bid_item_prices
160: WHERE auction_header_id = p_auction_header_id
161: AND bid_number = p_bid_number
162: AND auction_line_number = -1;
163:

Line 182: pon_bid_item_prices_ext_b ext

178: bid_number = p_bid_number;
179:
180: IF PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id) = 1 THEN
181: DELETE FROM
182: pon_bid_item_prices_ext_b ext
183: WHERE
184: ext.bid_number = p_bid_number
185: AND ext.line_number IN
186: (SELECT bid_item.line_number FROM pon_bid_item_prices bid_item

Line 186: (SELECT bid_item.line_number FROM pon_bid_item_prices bid_item

182: pon_bid_item_prices_ext_b ext
183: WHERE
184: ext.bid_number = p_bid_number
185: AND ext.line_number IN
186: (SELECT bid_item.line_number FROM pon_bid_item_prices bid_item
187: WHERE bid_item.bid_number = ext.bid_number AND bid_item.auction_line_number = -1);
188:
189: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
190: FND_LOG.string (log_level => FND_LOG.level_statement,

Line 198: x_entity_name => 'PON_BID_ITEM_PRICES',

194: END IF;
195:
196: FOR line IN all_lines LOOP
197: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
198: x_entity_name => 'PON_BID_ITEM_PRICES',
199: x_pk1_value => p_auction_header_id,
200: x_pk2_value => p_bid_number,
201: x_pk3_value => line.line_number);
202:

Line 211: pon_bid_item_prices

207: END IF;
208: END LOOP;
209:
210: DELETE FROM
211: pon_bid_item_prices
212: WHERE
213: bid_number = p_bid_number AND
214: auction_line_number = -1;
215:

Line 256: (SELECT 1 FROM pon_bid_item_prices WHERE auction_header_id = p_auc_header_id AND auction_line_number = -1);

252: SELECT 'Y'
253: INTO l_has_unsol_lines
254: FROM dual
255: WHERE EXISTS
256: (SELECT 1 FROM pon_bid_item_prices WHERE auction_header_id = p_auc_header_id AND auction_line_number = -1);
257:
258: RETURN l_has_unsol_lines;
259:
260: EXCEPTION

Line 278: (SELECT 1 FROM pon_bid_item_prices WHERE bid_number = p_bid_number AND auction_line_number = -1);

274: SELECT 'Y'
275: INTO l_has_unsol_lines
276: FROM dual
277: WHERE EXISTS
278: (SELECT 1 FROM pon_bid_item_prices WHERE bid_number = p_bid_number AND auction_line_number = -1);
279:
280: RETURN l_has_unsol_lines;
281:
282: EXCEPTION

Line 327: INSERT INTO pon_bid_item_prices

323: INTO l_auctpid
324: FROM pon_auction_headers_all ah
325: WHERE ah.auction_header_id = p_auction_id;
326:
327: INSERT INTO pon_bid_item_prices
328: (
329: AUCTION_HEADER_ID,
330: AUCTION_LINE_NUMBER,
331: BID_NUMBER,

Line 573: FROM pon_bid_item_prices bl

569: bl.CLM_PROMISE_PERIOD,
570: bl.CLM_PROMISE_PERIOD_UOM,
571: bl.CLM_PROMISE_POP_DURATION,
572: bl.CLM_PROMISE_POP_DURATION_UOM
573: FROM pon_bid_item_prices bl
574: WHERE bl.bid_number = p_source_bid_num
575: AND bl.auction_line_number = -1);
576:
577: END INSERT_INTO_BID_ITEMS;

Line 626: FROM pon_bid_item_prices

622: IS
623:
624: CURSOR unsol_lines IS
625: SELECT line_number,uda_template_id
626: FROM pon_bid_item_prices
627: WHERE bid_number=p_source_bid_num
628: AND auction_line_number = -1;
629:
630: BEGIN

Line 667: FROM fnd_attached_documents ad, pon_bid_item_prices bl

663: ) IS
664:
665: CURSOR unsol_lines_with_attachments IS
666: SELECT DISTINCT ad.pk3_value
667: FROM fnd_attached_documents ad, pon_bid_item_prices bl
668: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
669: AND ad.pk1_value = p_source_header_id
670: AND ad.pk2_value = p_source_bid_num
671: AND ad.pk3_value IS NOT null

Line 668: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'

664:
665: CURSOR unsol_lines_with_attachments IS
666: SELECT DISTINCT ad.pk3_value
667: FROM fnd_attached_documents ad, pon_bid_item_prices bl
668: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
669: AND ad.pk1_value = p_source_header_id
670: AND ad.pk2_value = p_source_bid_num
671: AND ad.pk3_value IS NOT null
672: AND bl.bid_number = p_bid_number

Line 679: (x_from_entity_name => 'PON_BID_ITEM_PRICES',

675:
676: BEGIN
677: FOR line IN unsol_lines_with_attachments LOOP
678: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
679: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
680: x_from_pk1_value => p_source_header_id,
681: x_from_pk2_value => p_source_bid_num,
682: x_from_pk3_value => line.pk3_value,
683: x_to_entity_name => 'PON_BID_ITEM_PRICES',

Line 683: x_to_entity_name => 'PON_BID_ITEM_PRICES',

679: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
680: x_from_pk1_value => p_source_header_id,
681: x_from_pk2_value => p_source_bid_num,
682: x_from_pk3_value => line.pk3_value,
683: x_to_entity_name => 'PON_BID_ITEM_PRICES',
684: x_to_pk1_value => p_auc_header_id,
685: x_to_pk2_value => p_bid_number,
686: x_to_pk3_value => line.pk3_value,
687: x_created_by => p_userid,

Line 791: (SELECT LINE_NUMBER FROM pon_bid_item_prices

787: UPDATE pon_bid_item_references
788: SET LINK_DONE_BY = 'SUPPLIER'
789: WHERE AUCTION_HEADER_ID = p_auction_id
790: AND LINE_NUMBER IN
791: (SELECT LINE_NUMBER FROM pon_bid_item_prices
792: WHERE AUCTION_HEADER_ID = p_auction_id
793: AND AUCTION_LINE_NUMBER = -1)
794: --Fix for bug 13643475
795: --Need to mark all the unsolicited lines linked as Supplier

Line 830: (SELECT LINE_NUMBER FROM pon_bid_item_prices

826: l_login_id
827: FROM pon_bid_item_references
828: WHERE AUCTION_HEADER_ID = p_auction_id
829: AND LINE_NUMBER IN
830: (SELECT LINE_NUMBER FROM pon_bid_item_prices
831: WHERE AUCTION_HEADER_ID = p_auction_id
832: AND AUCTION_LINE_NUMBER = -1
833: AND AWARD_STATUS = 'AWARDED'));
834: --Fix for bug 13643475

Line 855: (SELECT 1 FROM pon_bid_item_prices

851: SELECT 'Y'
852: INTO l_has_unsol_lines
853: FROM dual
854: WHERE EXISTS
855: (SELECT 1 FROM pon_bid_item_prices
856: WHERE bid_number = p_bid_number
857: AND auction_line_number = -1
858: AND Nvl(CLM_INFO_FLAG, 'N') = 'N'
859: AND Nvl(clm_cost_constraint, 'X') NOT IN ('NSP', 'NC'));

Line 886: FROM pon_bid_item_prices pbip,

882: INTO l_has_awarded_ref
883: FROM dual
884: WHERE EXISTS
885: (SELECT 1
886: FROM pon_bid_item_prices pbip,
887: pon_bid_item_references pbir
888: WHERE pbip.auction_header_id = p_auction_header_id
889: AND pbip.auction_line_number = -1
890: AND Nvl(pbip.award_status,'NO') = 'AWARDED'