[Home] [Help]
38: Begin
39:
40: SELECT list_type_code
41: INTO l_list_type
42: FROM QP_LIST_HEADERS
43: WHERE LIST_HEADER_ID = p_price_list_id;
44:
45: RETURN l_list_type;
46:
295: Select c.name,
296: a.list_line_no
297: From qp_preq_ldets_tmp a,
298: qp_preq_lines_tmp b,
299: qp_list_headers_vl c
300: Where b.line_id = p_line_id
301: And b.line_index = a.line_index
302: And a.created_from_list_header_id = c.list_header_id
303: And a.automatic_flag = 'Y'
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'
9250:
9251: l_invalid_line := 'Y';
9252: Begin
9253: Select name into l_price_list
9254: from qp_list_headers_vl where
9255: list_header_id = l_line_rec.price_list_id;
9256: Exception When No_data_found then
9257: l_price_list := l_line_rec.price_list_id;
9258: End;
9340: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9341:
9342: Begin
9343: Select name into l_price_list
9344: from qp_list_headers_vl a,qp_list_lines b where
9345: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9346: instr(p_req_line_tbl(i).status_text,',')-1))
9347: and a.list_header_id=b.list_header_id
9348: ;
9358: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9359: l_price_list);
9360: Begin
9361: Select name into l_price_list
9362: from qp_list_headers_vl a,qp_list_lines b where
9363: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9364: instr(p_req_line_tbl(i).status_text,',')+1))
9365: and a.list_header_id=b.list_header_id ;
9366: Exception When No_data_found then
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'