APPS.PON_GLOBAL_UPDATE_PKG dependencies on PON_AUCTION_ITEM_PRICES_EXT_B

Line 105: MERGE INTO pon_auction_item_prices_ext_b DESTLINE

101: END IF;
102:
103: LOG_MESSAGE(l_module,'Named attributes updated ');
104:
105: MERGE INTO pon_auction_item_prices_ext_b DESTLINE
106: USING (
107: SELECT
108: attr_group_id,
109: LINE_NUMBER,

Line 213: FROM pon_auction_item_prices_ext_b WHERE AUCTION_HEADER_ID = p_auction_header_id

209: d_ext_attr9,
210: d_ext_attr10,
211: uda_template_id,
212: auctioN_header_id
213: FROM pon_auction_item_prices_ext_b WHERE AUCTION_HEADER_ID = p_auction_header_id
214: and LINE_NUMBER = p_src_line_number) SRCLINE
215: ON
216: (DESTLINE.LINE_NUMBER IN (select column_value from table(p_dest_line_ids_tbl)) AND DESTLINE.attr_group_id = SRCLINE.attr_group_id AND SRCLINE.AUCTION_HEADER_ID = p_auction_header_id )
217: WHEN MATCHED THEN

Line 320: INSERT INTO pon_auction_item_prices_ext_b DESTlINE

316: LOG_MESSAGE(l_module,'Merge statement executed ');
317:
318: FORALL i IN 1..p_dest_line_ids_tbl.Count
319:
320: INSERT INTO pon_auction_item_prices_ext_b DESTlINE
321: (DESTLINE.extension_id,
322: DESTLINE.attr_group_id,
323: DESTLINE.LINE_NUMBER,
324: DESTLINE.data_level_id,

Line 534: FROM pon_auction_item_prices_ext_b SRCLINE WHERE SRCLINE.LINE_NUMBER = p_src_line_number

530: SRCLINE.d_ext_attr9,
531: SRCLINE.d_ext_attr10,
532: SRCLINE.uda_template_id,
533: SRCLINE.auction_header_id
534: FROM pon_auction_item_prices_ext_b SRCLINE WHERE SRCLINE.LINE_NUMBER = p_src_line_number
535: AND auction_header_id = p_auction_header_id
536: AND NOT EXISTS (SELECT 1 FROM pon_auction_item_prices_ext_b pleb WHERE
537: pleb.line_Number =p_dest_line_ids_tbl(i) AND
538: pleb.attr_group_id = SRCLINE.attr_group_id AND

Line 536: AND NOT EXISTS (SELECT 1 FROM pon_auction_item_prices_ext_b pleb WHERE

532: SRCLINE.uda_template_id,
533: SRCLINE.auction_header_id
534: FROM pon_auction_item_prices_ext_b SRCLINE WHERE SRCLINE.LINE_NUMBER = p_src_line_number
535: AND auction_header_id = p_auction_header_id
536: AND NOT EXISTS (SELECT 1 FROM pon_auction_item_prices_ext_b pleb WHERE
537: pleb.line_Number =p_dest_line_ids_tbl(i) AND
538: pleb.attr_group_id = SRCLINE.attr_group_id AND
539: pleb.auction_header_id = SRCLINE.auction_header_id);
540:

Line 547: FROM pon_auction_item_prices_ext_b

543:
544: SELECT extension_id,attr_group_id,line_number,data_level_id,uda_template_id
545: BULK COLLECT INTO extension_id_tbl,attr_group_id_tbl,sol_line_num_tbl,
546: data_level_id_tbl,uda_template_id_tbl
547: FROM pon_auction_item_prices_ext_b
548: WHERE line_Number IN ( select column_value from table(p_dest_line_ids_tbl))
549: AND auction_header_id = p_auction_header_id;
550:
551: LOG_MESSAGE(l_module,'About to insert into pon_auction_item_prices_ext_tl ');

Line 595: DELETE FROM pon_auction_item_prices_ext_b WHERE line_Number = p_src_line_number

591: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
592:
593: LOG_MESSAGE(l_module,'Inserted into pon_auction_item_prices_ext_tl ');
594:
595: DELETE FROM pon_auction_item_prices_ext_b WHERE line_Number = p_src_line_number
596: AND auction_header_id = p_auction_header_id;
597:
598: LOG_MESSAGE(l_module,'Deleted temporary record from pon_auction_item_prices_ext_b');
599: x_result:='S';

Line 598: LOG_MESSAGE(l_module,'Deleted temporary record from pon_auction_item_prices_ext_b');

594:
595: DELETE FROM pon_auction_item_prices_ext_b WHERE line_Number = p_src_line_number
596: AND auction_header_id = p_auction_header_id;
597:
598: LOG_MESSAGE(l_module,'Deleted temporary record from pon_auction_item_prices_ext_b');
599: x_result:='S';
600:
601: EXCEPTION
602: WHEN OTHERS THEN