APPS.PON_COPY_UDAS_GRP dependencies on PON_BID_ITEM_PRICES

Line 374: ,pon_bid_item_prices pbip

370: INTO l_complex_attr_grp
371: FROM
372: po_uda_ag_templates puat
373: ,po_uda_ag_template_usages puatu
374: ,pon_bid_item_prices pbip
375: ,ego_attr_groups_v eagv
376:
377: WHERE puat.template_id = p_bid_template_id
378: AND puatu.template_id = puat.template_id

Line 520: pon_bid_item_prices bl

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
524: AND old_al.auction_header_id(+) = bl.auction_header_id

Line 766: FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines

762: l_clm_idc_type po_lines_all.CLM_IDC_TYPE%TYPE;
763:
764: CURSOR attr_groups_cursor(p_bid_number NUMBER,p_bid_line_number NUMBER) is
765: select distinct(ATTR_GROUP_NAME) ATTR_GROUP_NAME
766: FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines
767: where bid_lines.bid_number = p_bid_number
768: and bid_lines.line_number = p_bid_line_number
769: and bid_lines.uda_template_id = ag.template_id
770: and Nvl(ag.attribute1,'A') = Decode(ag.attribute1,NULL,'A',bid_lines.clm_idc_type)

Line 793: pon_bid_item_prices

789:
790: BEGIN
791: select uda_template_id into l_dest_template_id
792: from
793: pon_bid_item_prices
794: where
795: bid_number = p_bid_header_id
796: and line_number = p_bid_line_number;
797: LOG_MESSAGE(l_module,'Bid Line Template Id : '||l_dest_template_id);

Line 842: update pon_bid_item_prices

838:
839: log_message(l_module,'Return from Auto_create_uda_copy '||x_return_status);
840: IF x_return_status = 'S' THEN
841:
842: update pon_bid_item_prices
843: set clm_contract_type = l_clm_contract_type,clm_idc_type =l_clm_idc_type
844: where
845: bid_number = p_bid_header_id and
846: line_number = p_bid_line_number;