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

Line 345: select uda_template_id into l_template_id from pon_auction_item_prices_all where

341: g_auc_line_number, p_target_line_number
342: )
343: );
344:
345: select uda_template_id into l_template_id from pon_auction_item_prices_all where
346: auction_header_id = p_source_auction_header_id and line_number = p_source_line_number;
347:
348: PO_UDA_DATA_UTIL.copy_user_attrs
349: (

Line 518: FROM pon_auction_item_prices_all al,

514: p_batch_start number,p_batch_end number) is
515: select al.auction_header_id, al.line_number,al.uda_template_id,
516: bl.bid_number,bl.line_number bid_line_number,bl.auction_header_id bid_auc_head_id,
517: decode(al.modified_date-old_al.modified_date,0,'B','A') copyfrom
518: FROM pon_auction_item_prices_all al,
519: pon_auction_item_prices_all old_al,
520: pon_bid_item_prices bl
521: WHERE al.auction_header_id = p_auction_header_id
522: AND bl.bid_number(+) = p_source_bid_number

Line 519: pon_auction_item_prices_all old_al,

515: select al.auction_header_id, al.line_number,al.uda_template_id,
516: bl.bid_number,bl.line_number bid_line_number,bl.auction_header_id bid_auc_head_id,
517: decode(al.modified_date-old_al.modified_date,0,'B','A') copyfrom
518: FROM pon_auction_item_prices_all al,
519: pon_auction_item_prices_all old_al,
520: pon_bid_item_prices bl
521: WHERE al.auction_header_id = p_auction_header_id
522: AND bl.bid_number(+) = p_source_bid_number
523: AND bl.line_number(+) = al.line_number

Line 688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;

684:
685: l_src_pkey PO_TBL_NUMBER;
686: l_tar_pkey PO_TBL_NUMBER;
687:
688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;
689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;
690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;
691: BEGIN
692: select nvl(clm_cost_constraint,'X')

Line 689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;

685: l_src_pkey PO_TBL_NUMBER;
686: l_tar_pkey PO_TBL_NUMBER;
687:
688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;
689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;
690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;
691: BEGIN
692: select nvl(clm_cost_constraint,'X')
693: into l_cost_constraint

Line 690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;

686: l_tar_pkey PO_TBL_NUMBER;
687:
688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;
689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;
690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;
691: BEGIN
692: select nvl(clm_cost_constraint,'X')
693: into l_cost_constraint
694: from pon_auction_item_prices_all

Line 694: from pon_auction_item_prices_all

690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;
691: BEGIN
692: select nvl(clm_cost_constraint,'X')
693: into l_cost_constraint
694: from pon_auction_item_prices_all
695: where auction_header_id=p_auction_header_id
696: and line_number=p_auction_line_number;
697:
698:

Line 728: from pon_auction_item_prices_all

724: if (x_return_status = 'S') then
725:
726: select nvl(clm_cost_constraint,'X'),clm_idc_type,clm_contract_type
727: into l_cost_constraint,l_idc_type,l_contract_type
728: from pon_auction_item_prices_all
729: where auction_header_id=p_auction_header_id
730: and line_number=p_auction_line_number;
731:
732: if l_cost_constraint in ('NC','NSP') then