DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRC_CONTEXTS_V

Line 2497: s,qp_prc_contexts_v p where s.segment_mapping_column = p_attribute_code and

2493: return varchar2 is
2494: l_attribute_name varchar2(80) := Null;
2495: begin
2496: select nvl(s.user_segment_name,s.seeded_segment_name) into l_attribute_name from qp_segments_v
2497: s,qp_prc_contexts_v p where s.segment_mapping_column = p_attribute_code and
2498: s.prc_context_id = p.prc_context_id and p.prc_context_code = p_context_code and
2499: p.prc_context_type = p_attribute_type;
2500: return l_attribute_name;
2501: exception

Line 2594: select nvl(user_prc_context_name,seeded_prc_context_name) into l_context_name from qp_prc_contexts_v where prc_context_code =

2590: FUNCTION get_context_name (p_context in varchar2,p_attribute_type in varchar2) return varchar2
2591: is
2592: l_context_name varchar2(240) :=Null;
2593: begin
2594: select nvl(user_prc_context_name,seeded_prc_context_name) into l_context_name from qp_prc_contexts_v where prc_context_code =
2595: p_context and prc_context_type = p_attribute_type;
2596: return l_context_name;
2597: exception
2598: when no_data_found then return null;

Line 3216: FROM qp_prc_contexts_v c

3212: IS
3213: BEGIN
3214: SELECT c.prc_context_code
3215: INTO x_context_code
3216: FROM qp_prc_contexts_v c
3217: WHERE nvl(c.user_prc_context_name,c.seeded_prc_context_name) = p_context_name
3218: AND prc_context_type = p_attribute_type;
3219: EXCEPTION
3220: WHEN NO_DATA_FOUND THEN