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_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_PRICE_ELEMENTS_INT

Line 36: from pon_auc_price_elements_int pape

32: -- init vars
33: BEGIN
34: select max(pape.auction_header_id)
35: into l_auction_header_id
36: from pon_auc_price_elements_int pape
37: where pape.batch_id = p_batch_id;
38:
39: select pon_auction_pkg.get_message_suffix(doc.internal_name)
40: into l_message_suffix

Line 53: update pon_auc_price_elements_int pape

49: END;
50:
51: -- Perform data population
52: -- populate PRICE_ELEMENT_TYPE_ID and DESCRIPTION
53: update pon_auc_price_elements_int pape
54: set (pape.price_element_type_id, pape.description) = (
55: select pet.price_element_type_id,
56: pet.description
57: from pon_price_element_types_tl pet

Line 65: update pon_auc_price_elements_int pape

61: where pape.batch_id = p_batch_id
62: and pape.price_element_type_name is not null;
63:
64: -- populate PRICING_BASIS
65: update pon_auc_price_elements_int pape
66: set pape.pricing_basis = (
67: select lookup_code
68: from fnd_lookups
69: where lookup_type = 'PON_PRICING_BASIS'

Line 76: update pon_auc_price_elements_int pape

72: where pape.batch_id = p_batch_id
73: and pape.pricing_basis_name is not null;
74:
75: -- if null, default from price_element_type
76: update pon_auc_price_elements_int pape
77: set pape.pricing_basis = (
78: select pricing_basis
79: from pon_price_element_types pet
80: where pet.price_element_type_id = pape.price_element_type_id

Line 110: 'PON_AUC_PRICE_ELEMENTS_INT',

106: VALUES
107: (
108: selected_batch_id,
109: selected_interface_line_id,
110: 'PON_AUC_PRICE_ELEMENTS_INT',
111: fnd_message.get_string('PON', 'PON_AUC_PRICE_ELEMENT_NAME'),
112: 'PON_AUC_CANNOT_UPLOAD_LP_PF',
113: sel_price_element_type_name
114: )

Line 135: 'PON_AUC_PRICE_ELEMENTS_INT',

131: VALUES
132: (
133: selected_batch_id,
134: selected_interface_line_id,
135: 'PON_AUC_PRICE_ELEMENTS_INT',
136: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
137: 'PON_AUC_PE_INVALID_VALUE',
138: sel_price_element_type_name
139: )

Line 160: 'PON_AUC_PRICE_ELEMENTS_INT',

156: VALUES
157: (
158: selected_batch_id,
159: selected_interface_line_id,
160: 'PON_AUC_PRICE_ELEMENTS_INT',
161: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),
162: 'PON_AUC_BASIS_INVAID_VALUE',
163: selected_pricing_basis_name
164: )

Line 176: pon_auc_price_elements_int pape

172: pape.pricing_basis selected_pricing_basis,
173: pape.pricing_basis_name selected_pricing_basis_name
174:
175: FROM
176: pon_auc_price_elements_int pape
177:
178: WHERE
179: pape.batch_id = p_batch_id;
180:

Line 204: 'PON_AUC_PRICE_ELEMENTS_INT',

200: VALUES
201: (
202: selected_batch_id,
203: selected_interface_line_id,
204: 'PON_AUC_PRICE_ELEMENTS_INT',
205: 'SEQUENCE_NUMBER',
206: 'PON_CAT_DISP_SEQ_M',
207: selected_sequence_number
208: )

Line 231: 'PON_AUC_PRICE_ELEMENTS_INT',

227: VALUES
228: (
229: selected_batch_id,
230: selected_interface_line_id,
231: 'PON_AUC_PRICE_ELEMENTS_INT',
232: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
233: 'PON_AUC_INVALID_PRECISION',
234: selected_value
235: )

Line 257: 'PON_AUC_PRICE_ELEMENTS_INT',

253: VALUES
254: (
255: selected_batch_id,
256: selected_interface_line_id,
257: 'PON_AUC_PRICE_ELEMENTS_INT',
258: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
259: 'PON_AUC_INVALID_PRECISION_AU'||l_message_suffix,
260: selected_value
261: )

Line 282: 'PON_AUC_PRICE_ELEMENTS_INT',

278: VALUES
279: (
280: selected_batch_id,
281: selected_interface_line_id,
282: 'PON_AUC_PRICE_ELEMENTS_INT',
283: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
284: 'PON_AUC_POSITIVE_OR_ZERO',
285: selected_value
286: )

Line 307: 'PON_AUC_PRICE_ELEMENTS_INT',

303: VALUES
304: (
305: selected_batch_id,
306: selected_interface_line_id,
307: 'PON_AUC_PRICE_ELEMENTS_INT',
308: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
309: 'PON_AUCTS_INV_PR_QT_VAL',
310: selected_display_target_flag
311: )

Line 334: 'PON_AUC_PRICE_ELEMENTS_INT',

330: VALUES
331: (
332: selected_batch_id,
333: selected_interface_line_id,
334: 'PON_AUC_PRICE_ELEMENTS_INT',
335: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
336: 'PON_AUC_POSITIVE_OR_ZERO',
337: selected_value
338: )

Line 362: 'PON_AUC_PRICE_ELEMENTS_INT',

358: VALUES
359: (
360: selected_batch_id,
361: selected_interface_line_id,
362: 'PON_AUC_PRICE_ELEMENTS_INT',
363: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),
364: 'PON_AUC_CANNOT_UPLOAD_PF_2',
365: selected_pricing_basis_name
366: )

Line 387: 'PON_AUC_PRICE_ELEMENTS_INT',

383: VALUES
384: (
385: selected_batch_id,
386: selected_interface_line_id,
387: 'PON_AUC_PRICE_ELEMENTS_INT',
388: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
389: 'PON_AUC_AUCTION_INA_PES_SP',
390: sel_price_element_type_name
391: )

Line 408: pon_auc_price_elements_int pape,

404: ip.order_type_lookup_code sel_order_type_lookup_code,
405: pet.enabled_flag selected_enabled_flag
406:
407: FROM
408: pon_auc_price_elements_int pape,
409: pon_item_prices_interface ip,
410: pon_price_element_types pet
411:
412: WHERE

Line 431: 'PON_AUC_PRICE_ELEMENTS_INT',

427: )
428: select
429: pape1.batch_id,
430: pape1.interface_line_id,
431: 'PON_AUC_PRICE_ELEMENTS_INT',
432: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
433: 'PON_DUPLICATE_WARNING_PRICE',
434: pape1.price_element_type_name
435: from pon_auc_price_elements_int pape1,

Line 435: from pon_auc_price_elements_int pape1,

431: 'PON_AUC_PRICE_ELEMENTS_INT',
432: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
433: 'PON_DUPLICATE_WARNING_PRICE',
434: pape1.price_element_type_name
435: from pon_auc_price_elements_int pape1,
436: pon_auc_price_elements_int pape2
437: where pape1.batch_id = p_batch_id
438: and pape1.batch_id = pape2.batch_id
439: and pape1.interface_line_id = pape2.interface_line_id

Line 436: pon_auc_price_elements_int pape2

432: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
433: 'PON_DUPLICATE_WARNING_PRICE',
434: pape1.price_element_type_name
435: from pon_auc_price_elements_int pape1,
436: pon_auc_price_elements_int pape2
437: where pape1.batch_id = p_batch_id
438: and pape1.batch_id = pape2.batch_id
439: and pape1.interface_line_id = pape2.interface_line_id
440: and pape1.price_element_type_id = pape2.price_element_type_id

Line 457: 'PON_AUC_PRICE_ELEMENTS_INT',

453: )
454: select
455: int_pe.batch_id,
456: int_pe.interface_line_id,
457: 'PON_AUC_PRICE_ELEMENTS_INT',
458: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
459: 'PON_AUC_CANNOT_UPLOAD_PF_1',
460: int_pe.price_element_type_name
461: from

Line 463: pon_auc_price_elements_int int_pe

459: 'PON_AUC_CANNOT_UPLOAD_PF_1',
460: int_pe.price_element_type_name
461: from
462: pon_price_elements auction_pe,
463: pon_auc_price_elements_int int_pe
464: where
465: int_pe.batch_id = p_batch_id
466: and auction_pe.auction_header_id = int_pe.auction_header_id
467: and auction_pe.line_number = int_pe.auction_line_number

Line 1170: from pon_auc_price_elements_int

1166: BEGIN
1167: -- select max sequence number (across all lines)
1168: select nvl(max(sequence_number), 0)
1169: into l_sequence_start
1170: from pon_auc_price_elements_int
1171: where batch_id = p_batch_id
1172: and sequence_number >= 0;
1173:
1174: l_sequence_start := l_sequence_start + 10;

Line 1183: insert into pon_auc_price_elements_int (

1179: FROM pon_auction_headers_all
1180: WHERE auction_header_id = p_auction_header_id;
1181:
1182: -- insert template price elements for all lines
1183: insert into pon_auc_price_elements_int (
1184: BATCH_ID,
1185: INTERFACE_LINE_ID,
1186: AUCTION_HEADER_ID,
1187: AUCTION_LINE_NUMBER,

Line 1240: delete from pon_auc_price_elements_int pape1

1236: 'SUPPLIER', 'SUPPLIER',
1237: 'NONE');
1238:
1239: -- resolve duplicate price elements by removing the Template price element
1240: delete from pon_auc_price_elements_int pape1
1241: where rowid in (
1242: select pape1.rowid
1243: from pon_auc_price_elements_int pape2
1244: where pape1.batch_id = p_batch_id

Line 1243: from pon_auc_price_elements_int pape2

1239: -- resolve duplicate price elements by removing the Template price element
1240: delete from pon_auc_price_elements_int pape1
1241: where rowid in (
1242: select pape1.rowid
1243: from pon_auc_price_elements_int pape2
1244: where pape1.batch_id = p_batch_id
1245: and pape1.batch_id = pape2.batch_id
1246: and pape1.interface_line_id = pape2.interface_line_id
1247: and pape1.price_element_type_id = pape2.price_element_type_id