[Home] [Help]
4123: Return g_rounding_factor_rec.rounding_factor;
4124: Else
4125: g_rounding_factor_rec.list_header_id := p_list_header_id;
4126: select rounding_factor into g_rounding_factor_rec.rounding_factor from
4127: qp_list_headers_b where list_header_id=p_list_header_id;
4128:
4129: If g_rounding_factor_rec.rounding_factor = fnd_api.g_miss_num then
4130: g_rounding_factor_rec.rounding_factor:= Null;
4131: End If;
4429: px_Req_LINE_DETAIL_tbl(l_RLD_Index).List_Line_type_Code := p_Line_Adj_rec.List_Line_type_Code;
4430: Begin
4431: Select list_type_code into
4432: px_Req_LINE_DETAIL_tbl(l_RLD_Index).created_from_list_type_code
4433: from qp_list_headers_b where
4434: list_header_id= p_Line_Adj_rec.List_Header_Id;
4435: Exception when no_data_found then
4436: adj_debug('Invalid list header '|| p_Line_Adj_rec.List_Header_Id,1);
4437: End;
7972: From
7973: qp_qualifiers qpq
7974: , qp_pricing_attributes qppa
7975: , qp_list_lines qpll
7976: , qp_list_headers_b qplh
7977: , qp_price_req_sources qpprs
7978: where
7979: qpq.qualifier_context='CUSTOMER'
7980: and qpq.qualifier_attribute='QUALIFIER_ATTRIBUTE15'
10992: -- check whether there is an AMS modifier defined
10993: adj_debug('in ams mod check ');
10994: BEGIN
10995: SELECT 1 into l_tmp_no from dual where exists (
10996: select 1 from qp_list_headers_b qh
10997: , oe_order_headers_all oh
10998: where qh.currency_code = oh.transactional_curr_code
10999: and oh.header_id = l_header_id
11000: and qh.source_system_code='AMS'
13467:
13468: CURSOR l_send_all_lines_cur(p_event_code1 VARCHAR2) IS
13469: SELECT 'X'
13470: FROM
13471: qp_list_headers_b qh,
13472: qp_list_lines ql,
13473: qp_pricing_attributes qppr
13474: WHERE ql.list_line_id = qppr.list_line_id
13475: AND ql.automatic_flag = 'N'