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

Line 3843: FROM PON_AUCTION_ITEM_PRICES_ALL A,

3839: l_clm_pop_duration,
3840: l_clm_pop_duration_uom,
3841: l_exhibit_number
3842:
3843: FROM PON_AUCTION_ITEM_PRICES_ALL A,
3844: (SELECT sum(decode(VL.ENABLED_FLAG,'N',1,0)) C1,
3845: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
3846: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'SUPPLIER',decode(P.PRICE_ELEMENT_TYPE_ID,-10,0,1),0),0)) NUM_SUPPLIER_PFS,
3847: AUCTION_HEADER_ID,

Line 4200: -- ("when cross-copying, set pon_auction_item_prices_all.source_line_number using

4196: END IF;
4197:
4198: --
4199: -- Lot based bidding project cross copy logic
4200: -- ("when cross-copying, set pon_auction_item_prices_all.source_line_number using
4201: -- pon_auction_item_prices_all.document_disp_line_number)
4202: --
4203: IF (p_doctype_id <> p_source_doctype_id AND
4204: ( p_copy_type = g_new_rnd_copy

Line 4201: -- pon_auction_item_prices_all.document_disp_line_number)

4197:
4198: --
4199: -- Lot based bidding project cross copy logic
4200: -- ("when cross-copying, set pon_auction_item_prices_all.source_line_number using
4201: -- pon_auction_item_prices_all.document_disp_line_number)
4202: --
4203: IF (p_doctype_id <> p_source_doctype_id AND
4204: ( p_copy_type = g_new_rnd_copy
4205: OR p_copy_type = g_amend_copy

Line 4284: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'

4280: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE
4281: FROM FND_ATTACHED_DOCUMENTS
4282: WHERE pk1_value = to_char(p_source_auction_header_id)
4283: AND pk2_value = to_char(l_line_number(x))
4284: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'
4285: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl
4286: WHERE NAME = 'PonAmendmentSpecific')
4287: UNION
4288: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE

Line 4292: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'

4288: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE
4289: FROM FND_ATTACHED_DOCUMENTS
4290: WHERE pk1_value = To_Char(l_source_prev_amend_id)
4291: AND pk2_value = to_char(l_line_number(x))
4292: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'
4293: AND ATTACHED_DOCUMENT_ID NOT IN
4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
4295: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
4296:

Line 4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
4295: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
4296:
4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4299: X_from_pk1_value => base_attach_rec.pk1_value,
4300: X_from_pk2_value => base_attach_rec.pk2_value,
4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4302: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4299: X_from_pk1_value => base_attach_rec.pk1_value,
4300: X_from_pk2_value => base_attach_rec.pk2_value,
4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4302: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
4303: X_to_pk2_value => to_char(l_line_number(x)), -- PK1_VALUE
4304: X_created_by => p_user_id, -- CREATED_BY
4305: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

Line 4312: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

4308: END LOOP;
4309:
4310: ELSE
4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4312: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4313: X_from_pk1_value => to_char(p_source_auction_header_id),
4314: X_from_pk2_value => to_char(l_line_number(x)),
4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4316: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4312: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4313: X_from_pk1_value => to_char(p_source_auction_header_id),
4314: X_from_pk2_value => to_char(l_line_number(x)),
4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4316: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
4317: X_to_pk2_value => to_char(l_line_number(x)),
4318: X_created_by => p_user_id, -- CREATED_BY
4319: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 4329: INTO PON_AUCTION_ITEM_PRICES_ALL

4325: END LOOP;
4326:
4327: FORALL x IN 1..l_line_number.COUNT
4328: INSERT
4329: INTO PON_AUCTION_ITEM_PRICES_ALL
4330: (AUCTION_HEADER_ID,
4331: AWARD_STATUS,
4332: LINE_NUMBER,
4333: ITEM_DESCRIPTION,

Line 9836: LOG_MESSAGE('copy_negotiation','The source auction is a in DRAFT stage; querying PON_AUCTION_ITEM_PRICES_ALL for l_max_line_number');

9832:
9833:
9834: if( CURRENT_STATUS = 'DRAFT' or CURRENT_STATUS = 'APPLIED' ) then
9835:
9836: LOG_MESSAGE('copy_negotiation','The source auction is a in DRAFT stage; querying PON_AUCTION_ITEM_PRICES_ALL for l_max_line_number');
9837:
9838: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
9839: where auction_header_id = p_source_auction_header_id;
9840: else

Line 9838: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL

9834: if( CURRENT_STATUS = 'DRAFT' or CURRENT_STATUS = 'APPLIED' ) then
9835:
9836: LOG_MESSAGE('copy_negotiation','The source auction is a in DRAFT stage; querying PON_AUCTION_ITEM_PRICES_ALL for l_max_line_number');
9837:
9838: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
9839: where auction_header_id = p_source_auction_header_id;
9840: else
9841:
9842: LOG_MESSAGE('copy_negotiation','The source auction is not in DRAFT stage; so querying MAX_INTERNAL_LINE_NUM field in PON_AUCTION_HEADERS_ALL for l_max_line_number');

Line 10394: FROM PON_AUCTION_ITEM_PRICES_ALL

10390:
10391: SELECT
10392: COUNT(LINE_NUMBER) number_of_lines, MAX (DECODE (GROUP_TYPE, 'LOT_LINE', 0, 'GROUP_LINE', 0, SUB_LINE_SEQUENCE_NUMBER)) last_line_number
10393: INTO l_number_of_lines, l_last_line_number
10394: FROM PON_AUCTION_ITEM_PRICES_ALL
10395: WHERE
10396: AUCTION_HEADER_ID = l_auction_header_id;
10397:
10398: LOG_MESSAGE('copy_lines_and_children','l_number_of_lines : ' || l_number_of_lines || ' ; l_last_line_number : ' || l_last_line_number);

Line 11607: FROM PON_AUCTION_ITEM_PRICES_ALL

11603:
11604: SELECT COUNT(1)
11605: INTO
11606: l_temp_labor_count
11607: FROM PON_AUCTION_ITEM_PRICES_ALL
11608: WHERE PURCHASE_BASIS = 'TEMP LABOR'
11609: AND AUCTION_HEADER_ID = p_source_auction_header_id;
11610:
11611: IF (l_temp_labor_count > 0) THEN

Line 12050: pon_auction_item_prices_all

12046: document_disp_line_number,
12047: parent_line_number,
12048: sub_line_sequence_number
12049: from
12050: pon_auction_item_prices_all
12051: where
12052: auction_header_id = p_auction_header_id
12053: order by
12054: disp_line_number;

Line 12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;

12051: where
12052: auction_header_id = p_auction_header_id
12053: order by
12054: disp_line_number;
12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

Line 12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

12052: auction_header_id = p_auction_header_id
12053: order by
12054: disp_line_number;
12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12060:

Line 12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;

12053: order by
12054: disp_line_number;
12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12060:
12061: begin

Line 12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;

12054: disp_line_number;
12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12060:
12061: begin
12062: log_message('renumber_lines', 'called');

Line 12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

12055: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
12056: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12057: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12058: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
12059: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
12060:
12061: begin
12062: log_message('renumber_lines', 'called');
12063: for line in c_lines loop

Line 12076: update pon_auction_item_prices_all

12072: l_doc_disp_line_number := l_parent_doc_disp_line_number || '.' || l_sub_line_sequence_number;
12073: l_child_sequence_number := l_child_sequence_number + 1;
12074: end if;
12075:
12076: update pon_auction_item_prices_all
12077: set
12078: document_disp_line_number = l_doc_disp_line_number,
12079: sub_line_sequence_number = l_sub_line_sequence_number
12080: where

Line 12252: from pon_auction_item_prices_all

12248: if (p_lot_enabled = 'N' or p_group_enabled = 'N') then
12249:
12250: select count(1)
12251: into l_delete_count
12252: from pon_auction_item_prices_all
12253: where auction_header_id = p_auction_header_id
12254: and line_number >= p_from_line_number
12255: and line_number <= p_to_line_number
12256: and (p_lot_enabled = 'N'

Line 12269: from pon_auction_item_prices_all ip

12265: delete from pon_auction_attributes
12266: where auction_header_id = p_auction_header_id
12267: and line_number in
12268: (select ip.line_number
12269: from pon_auction_item_prices_all ip
12270: where ip.auction_header_id = p_auction_header_id
12271: and ip.line_number >= p_from_line_number
12272: and ip.line_number <= p_to_line_number
12273: and (p_lot_enabled = 'N'

Line 12282: from pon_auction_item_prices_all ip

12278: delete from pon_attribute_scores
12279: where auction_header_id = p_auction_header_id
12280: and line_number in
12281: (select ip.line_number
12282: from pon_auction_item_prices_all ip
12283: where ip.auction_header_id = p_auction_header_id
12284: and ip.line_number >= p_from_line_number
12285: and ip.line_number <= p_to_line_number
12286: and (p_lot_enabled = 'N'

Line 12296: from pon_auction_item_prices_all ip

12292: delete from pon_auction_shipments
12293: where auction_header_id = p_auction_header_id
12294: and line_number in
12295: (select ip.line_number
12296: from pon_auction_item_prices_all ip
12297: where ip.auction_header_id = p_auction_header_id
12298: and ip.line_number >= p_from_line_number
12299: and ip.line_number <= p_to_line_number
12300: and (p_lot_enabled = 'N'

Line 12309: from pon_auction_item_prices_all ip

12305: delete from pon_price_differentials
12306: where auction_header_id = p_auction_header_id
12307: and line_number in
12308: (select ip.line_number
12309: from pon_auction_item_prices_all ip
12310: where ip.auction_header_id = p_auction_header_id
12311: and ip.line_number >= p_from_line_number
12312: and ip.line_number <= p_to_line_number
12313: and (p_lot_enabled = 'N'

Line 12322: from pon_auction_item_prices_all ip

12318: delete from pon_price_elements
12319: where auction_header_id = p_auction_header_id
12320: and line_number in
12321: (select ip.line_number
12322: from pon_auction_item_prices_all ip
12323: where ip.auction_header_id = p_auction_header_id
12324: and ip.line_number >= p_from_line_number
12325: and ip.line_number <= p_to_line_number
12326: and (p_lot_enabled = 'N'

Line 12336: from pon_auction_item_prices_all ip

12332: delete from pon_party_line_exclusions
12333: where auction_header_id = p_auction_header_id
12334: and line_number in
12335: (select ip.line_number
12336: from pon_auction_item_prices_all ip
12337: where ip.auction_header_id = p_auction_header_id
12338: and ip.line_number >= p_from_line_number
12339: and ip.line_number <= p_to_line_number
12340: and (p_lot_enabled = 'N'

Line 12350: from pon_auction_item_prices_all ip

12346: delete from pon_pf_supplier_values
12347: where auction_header_id = p_auction_header_id
12348: and line_number in
12349: (select ip.line_number
12350: from pon_auction_item_prices_all ip
12351: where ip.auction_header_id = p_auction_header_id
12352: and ip.line_number >= p_from_line_number
12353: and ip.line_number <= p_to_line_number
12354: and (p_lot_enabled = 'N'

Line 12360: delete from pon_auction_item_prices_all

12356: or p_group_enabled = 'N'
12357: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12358:
12359:
12360: delete from pon_auction_item_prices_all
12361: where auction_header_id = p_auction_header_id
12362: and line_number >= p_from_line_number
12363: and line_number <= p_to_line_number
12364: and (p_lot_enabled = 'N'