[Home] [Help]
4040: Return g_rounding_factor_rec.rounding_factor;
4041: Else
4042: g_rounding_factor_rec.list_header_id := p_list_header_id;
4043: select rounding_factor into g_rounding_factor_rec.rounding_factor from
4044: qp_list_headers_b where list_header_id=p_list_header_id;
4045:
4046: If g_rounding_factor_rec.rounding_factor = fnd_api.g_miss_num then
4047: g_rounding_factor_rec.rounding_factor:= Null;
4048: End If;
4346: px_Req_LINE_DETAIL_tbl(l_RLD_Index).List_Line_type_Code := p_Line_Adj_rec.List_Line_type_Code;
4347: Begin
4348: Select list_type_code into
4349: px_Req_LINE_DETAIL_tbl(l_RLD_Index).created_from_list_type_code
4350: from qp_list_headers_b where
4351: list_header_id= p_Line_Adj_rec.List_Header_Id;
4352: Exception when no_data_found then
4353: adj_debug('Invalid list header '|| p_Line_Adj_rec.List_Header_Id,1);
4354: End;
7880: From
7881: qp_qualifiers qpq
7882: , qp_pricing_attributes qppa
7883: , qp_list_lines qpll
7884: , qp_list_headers_b qplh
7885: , qp_price_req_sources qpprs
7886: where
7887: qpq.qualifier_context='CUSTOMER'
7888: and qpq.qualifier_attribute='QUALIFIER_ATTRIBUTE15'
10884: -- check whether there is an AMS modifier defined
10885: adj_debug('in ams mod check ');
10886: BEGIN
10887: SELECT 1 into l_tmp_no from dual where exists (
10888: select 1 from qp_list_headers_b qh
10889: , oe_order_headers_all oh
10890: where qh.currency_code = oh.transactional_curr_code
10891: and oh.header_id = l_header_id
10892: and qh.source_system_code='AMS'
13293:
13294: CURSOR l_send_all_lines_cur(p_event_code1 VARCHAR2) IS
13295: SELECT 'X'
13296: FROM
13297: qp_list_headers_b qh,
13298: qp_list_lines ql,
13299: qp_pricing_attributes qppr
13300: WHERE ql.list_line_id = qppr.list_line_id
13301: AND ql.automatic_flag = 'N'