APPS.PON_GLOBAL_UPDATE_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 50: UPDATE pon_auction_item_prices_all

46:
47: LOG_MESSAGE(l_module,'BEGIN: p_auction_header_id ' || p_auction_header_id
48: || ' p_src_line_number '|| p_src_line_number );
49:
50: UPDATE pon_auction_item_prices_all
51: SET
52: clm_option_from_date = Decode(clm_option_indicator,'O',Nvl(p_option_from_date,clm_option_from_date),NULL),
53: clm_option_to_date = Decode(clm_option_indicator,'O',Nvl(p_option_to_date,clm_option_to_date),NULL),
54: note_to_bidders = Nvl(p_note_to_suppliers,note_to_bidders),

Line 62: UPDATE pon_auction_item_prices_all

58: WHERE auction_header_id = p_auction_header_id
59: AND line_Number in (select column_value from table(p_dest_line_ids_tbl));
60:
61: -- Ship to location is non-editable for autocreated lines
62: UPDATE pon_auction_item_prices_all
63: SET
64: ship_to_location_id = Decode(Nvl(clm_info_flag,'N'),'N',
65: Nvl(p_ship_to_loc_id,ship_to_location_id),NULL)
66: WHERE auction_header_id = p_auction_header_id

Line 78: UPDATE pon_auction_item_prices_all

74: * This condition is enforced in Global update process
75: * as below
76: */
77: IF p_clm_need_by_date IS NOT NULL THEN
78: UPDATE pon_auction_item_prices_all
79: SET
80: clm_need_by_date = Decode(Nvl(clm_info_flag,'N'),'N', p_clm_need_by_date,NULL),
81: need_by_start_date = NULL,
82: need_by_date = NULL

Line 86: UPDATE pon_auction_item_prices_all paip

82: need_by_date = NULL
83: WHERE auction_header_id = p_auction_header_id
84: AND line_Number in (select column_value from table(p_dest_line_ids_tbl));
85: ELSIF (p_pop_start_date IS NOT NULL AND p_pop_end_date IS NOT NULL) THEN
86: UPDATE pon_auction_item_prices_all paip
87: SET
88: need_by_start_date =Decode(Nvl(clm_info_flag,'N'),'N', p_pop_start_date,NULL),
89: need_by_date = Decode(Nvl(clm_info_flag,'N'),'N', p_pop_end_date,NULL),
90: clm_need_by_date = NULL