[Home] [Help]
466: a_attribute VARCHAR2, a_pte_code VARCHAR2)
467: IS
468: SELECT a.sourcing_enabled, a.sourcing_status,
469: nvl(a.user_sourcing_method, a.seeded_sourcing_method)
470: FROM qp_pte_segments a, qp_prc_contexts_b b,
471: qp_segments_b c
472: WHERE b.prc_context_code = a_context
473: AND b.prc_context_type = a_context_type
474: AND c.prc_context_id = b.prc_context_id
517:
518: CURSOR contexts_cur(a_context_code VARCHAR2, a_context_type VARCHAR2)
519: IS
520: SELECT nvl(t.user_prc_context_name, t.seeded_prc_context_name), b.enabled_flag
521: FROM qp_prc_contexts_b b, qp_prc_contexts_tl t
522: WHERE b.prc_context_id = t.prc_context_id
523: AND t.language = userenv('LANG')
524: AND b.prc_context_code = a_context_code
525: AND b.prc_context_type = a_context_type;
662: ) IS
663: CURSOR context_attr_cur(a_attribute_code VARCHAR2)
664: IS
665: SELECT a.prc_context_code, b.segment_mapping_column
666: FROM qp_prc_contexts_b a, qp_segments_b b
667: WHERE a.prc_context_id = b.prc_context_id
668: AND b.segment_code = UPPER(a_attribute_code);
669:
670: BEGIN
1036: IS
1037: CURSOR context_cur(a_attribute_code VARCHAR2)
1038: IS
1039: SELECT a.prc_context_id
1040: FROM qp_prc_contexts_b a, qp_segments_b b
1041: WHERE a.prc_context_id = b.prc_context_id
1042: AND b.segment_code = a_attribute_code
1043: AND a.prc_context_type = 'QUALIFIER';
1044:
1099: IS
1100: CURSOR context_cur(a_attribute_code VARCHAR2)
1101: IS
1102: SELECT a.prc_context_id
1103: FROM qp_prc_contexts_b a, qp_segments_b b
1104: WHERE a.prc_context_id = b.prc_context_id
1105: AND b.segment_code = a_attribute_code
1106: AND a.prc_context_type = 'PRICING';
1107:
1299: -- Returns BOOLEAN
1300: --
1301: -- DESCRIPTION
1302: -- New function introduced in Attributes Manager that is equivalent to
1303: -- existing Context_Exists function but instead of checking for the existence-- of the context in flexfield tables, checks in the QP_PRC_CONTEXTS_B table.
1304: --
1305: --*****************************************************************************
1306:
1307: FUNCTION AM_Context_Exists(p_context_type IN VARCHAR2,
1311:
1312: CURSOR context_code_cur(a_context_type VARCHAR2, a_context_code VARCHAR2)
1313: IS
1314: SELECT prc_context_code
1315: FROM qp_prc_contexts_b
1316: WHERE prc_context_type = a_context_type
1317: AND prc_context_code = a_context_code
1318: AND enabled_flag = 'Y';
1319:
1403:
1404: CURSOR context_id_cur(a_context_type VARCHAR2, a_context_code VARCHAR2)
1405: IS
1406: SELECT prc_context_id
1407: FROM qp_prc_contexts_b
1408: WHERE prc_context_type = a_context_type
1409: AND prc_context_code = a_context_code;
1410:
1411: CURSOR enabled_segments_cur(a_context_id NUMBER,
2274: CURSOR valueset_id_cur(a_context_type VARCHAR2, a_context_code VARCHAR2,
2275: a_segment_code VARCHAR2)
2276: IS
2277: SELECT nvl(a.user_valueset_id, a.seeded_valueset_id)
2278: FROM qp_segments_b a, qp_prc_contexts_b b
2279: WHERE a.prc_context_id = b.prc_context_id
2280: AND b.prc_context_type = a_context_type
2281: AND b.prc_context_code = a_context_code
2282: AND a.segment_code = a_segment_code;
2429:
2430: CURSOR pricing_attribute_name_cur(a_context_code VARCHAR2, a_segment_name VARCHAR2)
2431: IS
2432: SELECT a.segment_mapping_column
2433: FROM qp_segments_v a, qp_prc_contexts_b b
2434: WHERE b.prc_context_id = a.prc_context_id
2435: AND b.prc_context_code = a_context_code
2436: AND a.segment_code = a_segment_name
2437: AND a.segment_mapping_column like 'PRICING%';--deliberately matching a_segment_name
2440:
2441: CURSOR qual_attribute_name_cur(a_context_code VARCHAR2, a_segment_name VARCHAR2)
2442: IS
2443: SELECT a.segment_mapping_column
2444: FROM qp_segments_v a, qp_prc_contexts_b b
2445: WHERE b.prc_context_id = a.prc_context_id
2446: AND b.prc_context_code = a_context_code
2447: AND a.segment_code = a_segment_name
2448: AND a.segment_mapping_column like 'QUALIFIER%';--deliberately matching a_segment_name
4132: IS
4133: SELECT nvl(a.user_segment_name, a.seeded_segment_name),
4134: b.segment_code
4135: FROM qp_segments_tl a, qp_segments_b b,
4136: qp_prc_contexts_b c, qp_pte_segments d
4137: WHERE c.prc_context_type = a_context_type
4138: AND c.prc_context_code = a_context_code
4139: AND c.prc_context_id = b.prc_context_id
4140: AND b.segment_mapping_column = a_attribute
4238: BEGIN
4239:
4240: select c.segment_level
4241: into l_segment_level
4242: from qp_prc_contexts_b a,
4243: qp_segments_b b,
4244: qp_pte_segments c,
4245: qp_list_headers_b d
4246: where a.prc_context_id = b.prc_context_id
4319: SELECT a.prc_context_code,
4320: nvl(b.user_prc_context_name, b.seeded_prc_context_name)
4321: prc_context_name,
4322: a.enabled_flag, a.prc_context_type
4323: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b
4324: WHERE a.prc_context_id = b.prc_context_id
4325: AND b.language = userenv('LANG')
4326: AND EXISTS (SELECT 'x'
4327: FROM qp_segments_b c, qp_pte_segments d
4599: d.prc_context_code, d.prc_context_type, c.lov_enabled,
4600: a.availability_in_basic, c.limits_enabled, c.segment_level,
4601: nvl(a.user_valueset_id, a.seeded_valueset_id) valueset_id
4602: FROM qp_segments_b a, qp_segments_tl b,
4603: qp_pte_segments c, qp_prc_contexts_b d
4604: WHERE d.prc_context_type = a_context_type
4605: AND d.prc_context_code = a_context_code
4606: AND a.prc_context_id = d.prc_context_id
4607: AND a.segment_id = b.segment_id