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_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 142: pon_auction_item_prices_all prev_round_item

138: and p1.action = g_update_action
139: and exists
140: (select 'x'
141: from
142: pon_auction_item_prices_all prev_round_item
143: where
144: prev_round_item.line_number <= l_prev_max_line_number
145: and prev_round_item.auction_header_id = p_auction_header_id
146: and nvl(prev_round_item.quantity_disabled_flag,'N') = 'Y'

Line 158: from pon_auction_item_prices_all pal

154: -- TBD ANY VALIDATIONS
155: update pon_item_prices_interface p1
156: set item_description =
157: (select item_description
158: from pon_auction_item_prices_all pal
159: where p1.batch_id = p_batch_id
160: and p1.action = g_update_action
161: and p1.auction_header_id = pal.auction_header_id
162: and p1.auction_line_number = pal.line_number)

Line 168: from pon_auction_item_prices_all pal1

164: p1.batch_id = p_batch_id
165: and p1.action = g_update_action
166: and exists
167: (select 'x'
168: from pon_auction_item_prices_all pal1
169: where
170: p1.auction_header_id = pal1.auction_header_id
171: and p1.auction_line_number = pal1.line_number
172: and (pal1.line_origination_code ='BLANKET' or p1.item_id is not null));

Line 180: pon_auction_item_prices_all pal

176: -- lines if they are from blanket or requisition.
177: update pon_item_prices_interface p1
178: set line_type = (select tl.line_type
179: from po_line_types_tl tl,
180: pon_auction_item_prices_all pal
181: where p1.batch_id = p_batch_id
182: and p1.action = g_update_action
183: and pal.auction_header_id = p1.auction_header_id
184: and p1.auction_line_number = pal.line_number

Line 188: pon_auction_item_prices_all pal

184: and p1.auction_line_number = pal.line_number
185: and pal.line_type_id = tl.line_type_id),
186: item_number = (select pal.item_number
187: from
188: pon_auction_item_prices_all pal
189: where p1.batch_id = p_batch_id
190: and p1.action = g_update_action
191: and p1.auction_header_id = pal.auction_header_id
192: and p1.auction_line_number = pal.line_number)

Line 198: from pon_auction_item_prices_all pal1

194: p1.batch_id = p_batch_id
195: and p1.action = g_update_action
196: and exists
197: (select 'x'
198: from pon_auction_item_prices_all pal1
199: where
200: p1.auction_header_id = pal1.auction_header_id
201: and p1.auction_line_number = pal1.line_number
202: and pal1.line_origination_code in ('BLANKET','REQUISITION'));

Line 211: pon_auction_item_prices_all pal

207: update pon_item_prices_interface p1
208: set (item_revision,unit_of_measure) =
209: (select pal.item_revision,pal.unit_of_measure
210: from
211: pon_auction_item_prices_all pal
212: where p1.batch_id = p_batch_id
213: and p1.action=g_update_action
214: and p1.auction_header_id = pal.auction_header_id
215: and p1.auction_line_number = pal.line_number)

Line 221: from pon_auction_item_prices_all pal1

217: p1.batch_id = p_batch_id
218: and p1.action = g_update_action
219: and exists
220: (select 'x'
221: from pon_auction_item_prices_all pal1
222: where
223: p1.auction_header_id = pal1.auction_header_id
224: and p1.auction_line_number = pal1.line_number
225: and pal1.line_origination_code = 'REQUISITION');

Line 232: pon_auction_item_prices_all pal

228: -- line is from a backing requisition from the then update the quantity
229: update pon_item_prices_interface p1
230: set quantity = (select pal.quantity
231: from
232: pon_auction_item_prices_all pal
233: where p1.batch_id = p_batch_id
234: and p1.action = g_update_action
235: and pal.auction_header_id = p1.auction_header_id
236: and pal.line_number = p1.auction_line_number)

Line 242: from pon_auction_item_prices_all pal1

238: p1.batch_id = p_batch_id
239: and p1.action = g_update_action
240: and exists
241: (select 'x'
242: from pon_auction_item_prices_all pal1
243: where
244: p1.auction_header_id = pal1.auction_header_id
245: and p1.auction_line_number = pal1.line_number
246: and pal1.order_type_lookup_code = 'AMOUNT'

Line 264: pon_auction_item_prices_all pal

260: (select pal.item_revision,
261: pal.unit_of_measure,
262: decode(pal.order_type_lookup_code,'AMOUNT',pal.quantity,p1.quantity)
263: from
264: pon_auction_item_prices_all pal
265: where p1.batch_id = p_batch_id
266: and p1.action=g_update_action
267: and p1.auction_header_id = pal.auction_header_id
268: and p1.auction_line_number = pal.line_number)

Line 274: from pon_auction_item_prices_all pal1

270: p1.batch_id = p_batch_id
271: and p1.action = g_update_action
272: and exists
273: (select 'x'
274: from pon_auction_item_prices_all pal1
275: where
276: p1.auction_header_id = pal1.auction_header_id
277: and p1.auction_line_number = pal1.line_number
278: and pal1.line_origination_code ='REQUISITION');

Line 289: pon_auction_item_prices_all pal

285: update pon_item_prices_interface p1
286: set ship_to_location = (select st.location_code
287: from po_ship_to_loc_org_v st,
288: financials_system_params_all fsp,
289: pon_auction_item_prices_all pal
290: where p1.batch_id = p_batch_id
291: and p1.action = g_update_action
292: and p1.auction_header_id = pal.auction_header_id
293: and p1.auction_line_number = pal.line_number

Line 302: from pon_auction_item_prices_all pal1

298: p1.batch_id = p_batch_id
299: and p1.action = g_update_action
300: and exists
301: (select 'x'
302: from pon_auction_item_prices_all pal1
303: where
304: p1.auction_header_id = pal1.auction_header_id
305: and p1.auction_line_number = pal1.line_number
306: and pal1.line_origination_code in ('BLANKET','REQUISITION'));

Line 318: pon_auction_item_prices_all pal

314: set (display_target_flag,unit_display_target_flag) = (select
315: pal.display_target_price_flag,
316: pal.unit_display_target_flag
317: from
318: pon_auction_item_prices_all pal
319: where p1.batch_id = p_batch_id
320: and p1.action = g_update_action
321: and p1.auction_line_number = pal.line_number
322: and pal.auction_header_id = p1.auction_header_id)

Line 696: PON_AUCTION_ITEM_PRICES_ALL

692: PON_PARTY_LINE_EXCLUSIONS
693: PON_AUC_PAYMENTS_SHIPMENTS
694: Attachments
695: Update backing requisitions for lines being deleted.
696: PON_AUCTION_ITEM_PRICES_ALL
697: ======================================================================*/
698: PROCEDURE DELETE_LINES_WITH_CHILDREN is
699:
700: l_module CONSTANT VARCHAR2(26) := 'DELETE_LINES_WITH_CHILDREN';

Line 709: pon_auction_item_prices_all auction_item

705: auction_item.line_number,
706: auction_item.line_origination_code,
707: auction_item.org_id
708: FROM pon_item_prices_interface interface_line,
709: pon_auction_item_prices_all auction_item
710: WHERE interface_line.BATCH_ID = g_batch_id
711: and interface_line.action = g_delete_action
712: and interface_line.auction_header_id = auction_item.auction_header_id
713: and interface_line.auction_line_number = auction_item.line_number

Line 930: (x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

926: --Delete all attachments and update backing requisitions if they exist.
927: FOR delete_line_record IN delete_line_cursor LOOP
928:
929: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
930: (x_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
931: x_pk1_value => g_auction_header_id,
932: x_pk2_value => delete_line_record.line_number);
933:
934: if delete_line_record.line_origination_code is not null then

Line 945: delete from pon_auction_item_prices_all item_prices

941:
942: end loop;
943:
944:
945: delete from pon_auction_item_prices_all item_prices
946: where
947: auction_header_id = g_auction_header_id
948: and exists
949: (select

Line 960: delete from pon_auction_item_prices_all item_prices

956: and item_prices.parent_line_number = p1.auction_line_number
957: and item_prices.group_type in ('LOT_LINE','GROUP_LINE'));
958:
959:
960: delete from pon_auction_item_prices_all item_prices
961: where
962: auction_header_id = g_auction_header_id
963: and exists
964: (select

Line 988: interface table to the pon_auction_item_prices_all transaction table.

984:
985: PARAMETERS: NONE
986:
987: COMMENT : This procedure will add the new lines from the pon_item_prices_interface
988: interface table to the pon_auction_item_prices_all transaction table.
989: The following sql will be used for the same. This procedure will
990: contain the logic of copying the lines as is present in the
991: copyItemData method of NegItemSpreadsheetAMImpl.
992: ======================================================================*/

Line 997: l_price_break_type pon_auction_item_prices_all.price_break_type%type;

993: PROCEDURE ADD_LINES is
994:
995: l_module CONSTANT VARCHAR2(9) := 'ADD_LINES';
996:
997: l_price_break_type pon_auction_item_prices_all.price_break_type%type;
998: l_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
999:
1000: BEGIN
1001: --{

Line 998: l_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;

994:
995: l_module CONSTANT VARCHAR2(9) := 'ADD_LINES';
996:
997: l_price_break_type pon_auction_item_prices_all.price_break_type%type;
998: l_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
999:
1000: BEGIN
1001: --{
1002: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1013: insert into pon_auction_item_prices_all

1009: l_price_break_neg_flag);
1010:
1011:
1012:
1013: insert into pon_auction_item_prices_all
1014: fields
1015: (AUCTION_HEADER_ID,
1016: LINE_NUMBER,
1017: SUB_LINE_SEQUENCE_NUMBER,

Line 1654: pon_auction_item_prices_all paip

1650: from pon_attribute_scores
1651: where auction_header_id = g_auction_header_id and
1652: line_number in (select paip.line_number
1653: from pon_item_prices_interface p1,
1654: pon_auction_item_prices_all paip
1655: where p1.batch_id = g_batch_id and
1656: p1.auction_header_id = paip.auction_header_id and
1657: p1.auction_line_number = paip.line_number and
1658: paip.ip_category_id is not null and

Line 1676: pon_auction_item_prices_all paip

1672: paa.ip_category_id is not null and
1673: paa.ip_category_id <> 0 and
1674: paa.line_number in (select paip.line_number
1675: from pon_item_prices_interface p1,
1676: pon_auction_item_prices_all paip
1677: where p1.batch_id = g_batch_id and
1678: p1.auction_header_id = paip.auction_header_id and
1679: p1.auction_line_number = paip.line_number and
1680: paip.ip_category_id is not null and

Line 1787: UPDATE PON_AUCTION_ITEM_PRICES_ALL

1783: p1.batch_id = g_batch_id
1784: and p1.action = g_update_action;
1785:
1786: FORALL x in 1..l_line_number.COUNT
1787: UPDATE PON_AUCTION_ITEM_PRICES_ALL
1788: SET
1789: GROUP_TYPE = l_group_type(x),
1790: ITEM_DESCRIPTION = l_item_description(x),
1791: CATEGORY_ID = l_category_id(x),

Line 1861: UPDATE PON_AUCTION_ITEM_PRICES_ALL

1857: AND INTERFACE.group_type IN ('LOT_LINE','GROUP_LINE');
1858:
1859:
1860: FORALL x in 1..l_line_number.COUNT
1861: UPDATE PON_AUCTION_ITEM_PRICES_ALL
1862: SET
1863: LAST_AMENDMENT_UPDATE = decode(l_last_amendment_update,0,LAST_AMENDMENT_UPDATE,l_last_amendment_update),
1864: MODIFIED_DATE = sysdate,
1865: MODIFIED_FLAG = 'Y'

Line 1882: UPDATE PON_AUCTION_ITEM_PRICES_ALL

1878: INTERFACE.batch_id = g_batch_id
1879: AND INTERFACE.auction_line_number <= l_max_internal_line_num;
1880:
1881: FORALL x in 1..l_line_number.COUNT
1882: UPDATE PON_AUCTION_ITEM_PRICES_ALL
1883: SET
1884: LAST_AMENDMENT_UPDATE = decode(l_last_amendment_update,0,LAST_AMENDMENT_UPDATE,l_last_amendment_update),
1885: MODIFIED_DATE = sysdate,
1886: MODIFIED_FLAG = 'Y'

Line 2597: pon_auction_item_prices_all.

2593: and auction header id passed as a parameter to the procedure.
2594: This will also set the global variables g_batch_id and
2595: g_auction_header_id.
2596: This will also re-number all the lines and set flags in
2597: pon_auction_item_prices_all.
2598: ======================================================================*/
2599: PROCEDURE SYNCH_FROM_INTERFACE(
2600: p_batch_id IN NUMBER,
2601: p_auction_header_id IN NUMBER,

Line 2791: p_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

2787: p_category_name => 'Vendor',
2788: p_document_description => l_attachment_record.attachment_desc,
2789: p_datatype_id => 5,
2790: p_url => l_attachment_record.attachment_url,
2791: p_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2792: p_pk1_value => g_auction_header_id,
2793: p_pk2_value => l_attachment_record.auction_line_number,
2794: p_pk3_value => NULL,
2795: p_pk4_value => NULL,

Line 2803: /* Set the following fields for all records in pon_auction_item_prices all

2799: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2800: l_progress := 'Data copied for p_auction_header_id = '||p_auction_header_id;
2801: END if;
2802:
2803: /* Set the following fields for all records in pon_auction_item_prices all
2804: HAS_ATTRIBUTES_FLAG,
2805: HAS_SHIPMENTS_FLAG
2806: HAS_PRICE_ELEMENTS_FLAG
2807: HAS_BUYER_PFS_FLAG

Line 2860: FROM pon_auction_item_prices_all

2856:
2857: -- Determine total number of lines
2858: SELECT count(line_number)
2859: INTO l_number_of_lines
2860: FROM pon_auction_item_prices_all
2861: WHERE auction_header_id = g_auction_header_id;
2862:
2863: else
2864:

Line 2883: pon_auction_item_prices_all paip

2879: into
2880: l_number_of_lines,
2881: l_max_display_number
2882: FROM
2883: pon_auction_item_prices_all paip
2884: where
2885: paip.auction_header_id = p_auction_header_id;
2886: end if;
2887:

Line 2908: FROM pon_auction_item_prices_all

2904: END if;
2905:
2906: SELECT count(line_number)
2907: INTO l_number_of_lines
2908: FROM pon_auction_item_prices_all
2909: WHERE auction_header_id = g_auction_header_id;
2910:
2911: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2912: l_progress := 'delete completed g_batch_id = '||g_batch_id ||

Line 2976: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;

2972:
2973: l_module CONSTANT VARCHAR2(32) := 'SYNCH_PAYMENTS_FROM_INTERFACE';
2974: l_progress varchar2(200);
2975: l_sequence NUMBER :=0;
2976: l_previous_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
2977: l_prev_amend_auc_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
2978: l_supplier_modify_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
2979:
2980:

Line 2990: pon_auction_item_prices_all pai,

2986: paps.auction_header_id,
2987: paps.line_number,
2988: papi.document_disp_line_number
2989: FROM pon_auc_payments_interface papi,
2990: pon_auction_item_prices_all pai,
2991: pon_auc_payments_shipments paps
2992: WHERE papi.auction_header_id = pai.auction_header_id
2993: AND papi.document_disp_line_number = pai.document_disp_line_number
2994: AND paps.auction_header_id = pai.auction_header_id

Line 3036: PON_AUCTION_ITEM_PRICES_ALL pai,

3032: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_TYPE)) PROJECT_EXPENDITURE_TYPE,
3033: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, porg.organization_id)) PROJECT_EXP_ORGANIZATION_ID,
3034: DECODE(pai.LINE_ORIGINATION_CODE, 'REQUISITION', NULL, DECODE(pah.SUPPLIER_ENTERABLE_PYMT_FLAG,'Y', NULL, ppi.PROJECT_EXPENDITURE_ITEM_DATE)) PROJECT_EXPENDITURE_ITEM_DATE
3035: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
3036: PON_AUCTION_ITEM_PRICES_ALL pai,
3037: PON_AUCTION_HEADERS_ALL pah,
3038: FND_USER fu,
3039: HR_LOCATIONS_ALL hrl,
3040: MTL_UNITS_OF_MEASURE uom,

Line 3182: --Update pon_auction_item_prices_all to set lastupdatedate

3178: FROM PON_AUCTION_HEADERS_ALL pah
3179: WHERE auction_header_id = p_auction_header_id;
3180:
3181: IF l_prev_amend_auc_id IS NOT NULL THEN
3182: --Update pon_auction_item_prices_all to set lastupdatedate
3183: -- for changed payments
3184: UPDATE pon_auction_item_prices_all al
3185: SET modified_flag = 'Y'
3186: , modified_date = SYSDATE

Line 3184: UPDATE pon_auction_item_prices_all al

3180:
3181: IF l_prev_amend_auc_id IS NOT NULL THEN
3182: --Update pon_auction_item_prices_all to set lastupdatedate
3183: -- for changed payments
3184: UPDATE pon_auction_item_prices_all al
3185: SET modified_flag = 'Y'
3186: , modified_date = SYSDATE
3187: , last_update_date = SYSDATE
3188: , last_updated_by = fnd_global.user_id