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 2953: FROM PON_AUCTION_ITEM_PRICES_ALL A,

2949: l_project_exp_organization_id,
2950: l_project_exp_item_date,
2951: l_close_bidding_date,
2952: l_has_quantity_tiers_flag
2953: FROM PON_AUCTION_ITEM_PRICES_ALL A,
2954: (SELECT sum(decode(VL.ENABLED_FLAG,'N',1,0)) C1,
2955: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
2956: 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,
2957: AUCTION_HEADER_ID,

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

3298: END IF;
3299:
3300: --
3301: -- Lot based bidding project cross copy logic
3302: -- ("when cross-copying, set pon_auction_item_prices_all.source_line_number using
3303: -- pon_auction_item_prices_all.document_disp_line_number)
3304: --
3305: IF (p_doctype_id <> p_source_doctype_id AND
3306: ( p_copy_type = g_new_rnd_copy

Line 3303: -- pon_auction_item_prices_all.document_disp_line_number)

3299:
3300: --
3301: -- Lot based bidding project cross copy logic
3302: -- ("when cross-copying, set pon_auction_item_prices_all.source_line_number using
3303: -- pon_auction_item_prices_all.document_disp_line_number)
3304: --
3305: IF (p_doctype_id <> p_source_doctype_id AND
3306: ( p_copy_type = g_new_rnd_copy
3307: OR p_copy_type = g_amend_copy

Line 3361: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

3357: --
3358: IF ( p_retain_attachments = 'Y' ) THEN
3359: -- AND l_attachment_flag(x) = 'Y' ) THEN
3360: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
3361: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
3362: X_from_pk1_value => to_char(p_source_auction_header_id),
3363: X_from_pk2_value => to_char(l_line_number(x)),
3364: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
3365: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 3364: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

3360: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
3361: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
3362: X_from_pk1_value => to_char(p_source_auction_header_id),
3363: X_from_pk2_value => to_char(l_line_number(x)),
3364: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
3365: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
3366: X_to_pk2_value => to_char(l_line_number(x)),
3367: X_created_by => p_user_id, -- CREATED_BY
3368: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

Line 3377: INTO PON_AUCTION_ITEM_PRICES_ALL

3373: END LOOP;
3374:
3375: FORALL x IN 1..l_line_number.COUNT
3376: INSERT
3377: INTO PON_AUCTION_ITEM_PRICES_ALL
3378: (AUCTION_HEADER_ID,
3379: AWARD_STATUS,
3380: LINE_NUMBER,
3381: ITEM_DESCRIPTION,

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

8658: --------------------------------------------------------------------------------------------------------------
8659:
8660: if(CURRENT_STATUS = 'DRAFT') then
8661:
8662: LOG_MESSAGE('copy_negotiation','The source auction is a in DRAFT stage; querying PON_AUCTION_ITEM_PRICES_ALL for l_max_line_number');
8663:
8664: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
8665: where auction_header_id = p_source_auction_header_id;
8666: else

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

8660: if(CURRENT_STATUS = 'DRAFT') then
8661:
8662: LOG_MESSAGE('copy_negotiation','The source auction is a in DRAFT stage; querying PON_AUCTION_ITEM_PRICES_ALL for l_max_line_number');
8663:
8664: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
8665: where auction_header_id = p_source_auction_header_id;
8666: else
8667:
8668: 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 9195: FROM PON_AUCTION_ITEM_PRICES_ALL

9191:
9192: SELECT
9193: COUNT(LINE_NUMBER) number_of_lines, MAX (DECODE (GROUP_TYPE, 'LOT_LINE', 0, 'GROUP_LINE', 0, SUB_LINE_SEQUENCE_NUMBER)) last_line_number
9194: INTO l_number_of_lines, l_last_line_number
9195: FROM PON_AUCTION_ITEM_PRICES_ALL
9196: WHERE
9197: AUCTION_HEADER_ID = l_auction_header_id;
9198:
9199: LOG_MESSAGE('copy_lines_and_children','l_number_of_lines : ' || l_number_of_lines || ' ; l_last_line_number : ' || l_last_line_number);

Line 10268: FROM PON_AUCTION_ITEM_PRICES_ALL

10264:
10265: SELECT COUNT(1)
10266: INTO
10267: l_temp_labor_count
10268: FROM PON_AUCTION_ITEM_PRICES_ALL
10269: WHERE PURCHASE_BASIS = 'TEMP LABOR'
10270: AND AUCTION_HEADER_ID = p_source_auction_header_id;
10271:
10272: IF (l_temp_labor_count > 0) THEN

Line 10649: pon_auction_item_prices_all

10645: document_disp_line_number,
10646: parent_line_number,
10647: sub_line_sequence_number
10648: from
10649: pon_auction_item_prices_all
10650: where
10651: auction_header_id = p_auction_header_id
10652: order by
10653: disp_line_number;

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

10650: where
10651: auction_header_id = p_auction_header_id
10652: order by
10653: disp_line_number;
10654: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

Line 10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

10651: auction_header_id = p_auction_header_id
10652: order by
10653: disp_line_number;
10654: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10659:

Line 10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;

10652: order by
10653: disp_line_number;
10654: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10659:
10660: begin

Line 10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;

10653: disp_line_number;
10654: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10659:
10660: begin
10661: log_message('renumber_lines', 'called');

Line 10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;

10654: l_doc_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE := 1;
10655: l_child_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10656: l_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10657: l_parent_doc_disp_line_number pon_auction_item_prices_all.document_disp_line_number%TYPE;
10658: l_sub_line_sequence_number pon_auction_item_prices_all.sub_line_sequence_number%TYPE;
10659:
10660: begin
10661: log_message('renumber_lines', 'called');
10662: for line in c_lines loop

Line 10675: update pon_auction_item_prices_all

10671: l_doc_disp_line_number := l_parent_doc_disp_line_number || '.' || l_sub_line_sequence_number;
10672: l_child_sequence_number := l_child_sequence_number + 1;
10673: end if;
10674:
10675: update pon_auction_item_prices_all
10676: set
10677: document_disp_line_number = l_doc_disp_line_number,
10678: sub_line_sequence_number = l_sub_line_sequence_number
10679: where

Line 10811: from pon_auction_item_prices_all

10807: if (p_lot_enabled = 'N' or p_group_enabled = 'N') then
10808:
10809: select count(1)
10810: into l_delete_count
10811: from pon_auction_item_prices_all
10812: where auction_header_id = p_auction_header_id
10813: and line_number >= p_from_line_number
10814: and line_number <= p_to_line_number
10815: and (p_lot_enabled = 'N'

Line 10828: from pon_auction_item_prices_all ip

10824: delete from pon_auction_attributes
10825: where auction_header_id = p_auction_header_id
10826: and line_number in
10827: (select ip.line_number
10828: from pon_auction_item_prices_all ip
10829: where ip.auction_header_id = p_auction_header_id
10830: and ip.line_number >= p_from_line_number
10831: and ip.line_number <= p_to_line_number
10832: and (p_lot_enabled = 'N'

Line 10841: from pon_auction_item_prices_all ip

10837: delete from pon_attribute_scores
10838: where auction_header_id = p_auction_header_id
10839: and line_number in
10840: (select ip.line_number
10841: from pon_auction_item_prices_all ip
10842: where ip.auction_header_id = p_auction_header_id
10843: and ip.line_number >= p_from_line_number
10844: and ip.line_number <= p_to_line_number
10845: and (p_lot_enabled = 'N'

Line 10855: from pon_auction_item_prices_all ip

10851: delete from pon_auction_shipments
10852: where auction_header_id = p_auction_header_id
10853: and line_number in
10854: (select ip.line_number
10855: from pon_auction_item_prices_all ip
10856: where ip.auction_header_id = p_auction_header_id
10857: and ip.line_number >= p_from_line_number
10858: and ip.line_number <= p_to_line_number
10859: and (p_lot_enabled = 'N'

Line 10868: from pon_auction_item_prices_all ip

10864: delete from pon_price_differentials
10865: where auction_header_id = p_auction_header_id
10866: and line_number in
10867: (select ip.line_number
10868: from pon_auction_item_prices_all ip
10869: where ip.auction_header_id = p_auction_header_id
10870: and ip.line_number >= p_from_line_number
10871: and ip.line_number <= p_to_line_number
10872: and (p_lot_enabled = 'N'

Line 10881: from pon_auction_item_prices_all ip

10877: delete from pon_price_elements
10878: where auction_header_id = p_auction_header_id
10879: and line_number in
10880: (select ip.line_number
10881: from pon_auction_item_prices_all ip
10882: where ip.auction_header_id = p_auction_header_id
10883: and ip.line_number >= p_from_line_number
10884: and ip.line_number <= p_to_line_number
10885: and (p_lot_enabled = 'N'

Line 10895: from pon_auction_item_prices_all ip

10891: delete from pon_party_line_exclusions
10892: where auction_header_id = p_auction_header_id
10893: and line_number in
10894: (select ip.line_number
10895: from pon_auction_item_prices_all ip
10896: where ip.auction_header_id = p_auction_header_id
10897: and ip.line_number >= p_from_line_number
10898: and ip.line_number <= p_to_line_number
10899: and (p_lot_enabled = 'N'

Line 10909: from pon_auction_item_prices_all ip

10905: delete from pon_pf_supplier_values
10906: where auction_header_id = p_auction_header_id
10907: and line_number in
10908: (select ip.line_number
10909: from pon_auction_item_prices_all ip
10910: where ip.auction_header_id = p_auction_header_id
10911: and ip.line_number >= p_from_line_number
10912: and ip.line_number <= p_to_line_number
10913: and (p_lot_enabled = 'N'

Line 10919: delete from pon_auction_item_prices_all

10915: or p_group_enabled = 'N'
10916: and ip.group_type in ('GROUP', 'GROUP_LINE')));
10917:
10918:
10919: delete from pon_auction_item_prices_all
10920: where auction_header_id = p_auction_header_id
10921: and line_number >= p_from_line_number
10922: and line_number <= p_to_line_number
10923: and (p_lot_enabled = 'N'