[Home] [Help]
37: Begin
38:
39: SELECT list_type_code
40: INTO l_list_type
41: FROM QP_LIST_HEADERS
42: WHERE LIST_HEADER_ID = p_price_list_id;
43:
44: RETURN l_list_type;
45:
294: Select c.name,
295: a.list_line_no
296: From qp_preq_ldets_tmp a,
297: qp_preq_lines_tmp b,
298: qp_list_headers_vl c
299: Where b.line_id = p_line_id
300: And b.line_index = a.line_index
301: And a.created_from_list_header_id = c.list_header_id
302: And a.automatic_flag = 'Y'
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'
9158:
9159: l_invalid_line := 'Y';
9160: Begin
9161: Select name into l_price_list
9162: from qp_list_headers_vl where
9163: list_header_id = l_line_rec.price_list_id;
9164: Exception When No_data_found then
9165: l_price_list := l_line_rec.price_list_id;
9166: End;
9249: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9250:
9251: Begin
9252: Select name into l_price_list
9253: from qp_list_headers_vl a,qp_list_lines b where
9254: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9255: instr(p_req_line_tbl(i).status_text,',')-1))
9256: and a.list_header_id=b.list_header_id
9257: ;
9267: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9268: l_price_list);
9269: Begin
9270: Select name into l_price_list
9271: from qp_list_headers_vl a,qp_list_lines b where
9272: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9273: instr(p_req_line_tbl(i).status_text,',')+1))
9274: and a.list_header_id=b.list_header_id ;
9275: Exception When No_data_found then
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'