[Home] [Help]
354: IS
355: cursor c_qual_name(p_qualifier_ctx VARCHAR2,p_qualifier_attr VARCHAR2,p_qualifier_id NUMBER)
356: IS
357: SELECT QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',p_qualifier_ctx, p_qualifier_attr, p_qualifier_id)
358: from dual;
359: l_cust_name varchar2(240);
360: l_qualifier_ctx VARCHAR2 (240);
361: l_qualifier_attr VARCHAR2(240);
362: BEGIN
481:
482: FUNCTION get_list_line_no RETURN NUMBER IS
483: x number;
484: CURSOR cur_get_list_line_no IS
485: SELECT ams_qp_list_line_no_s.nextval from dual;
486: BEGIN
487: OPEN cur_get_list_line_no;
488: FETCH cur_get_list_line_no INTO x;
489: CLOSE cur_get_list_line_no;
3872:
3873: -- nepanda : start : fix for bug 8507709 : added cursor to find out if data is already there in qp_list_line table for an offer
3874: CURSOR c_exists_in_qp_list_line(l_list_header_id NUMBER) IS
3875: SELECT 1
3876: FROM DUAL
3877: WHERE EXISTS (SELECT 1
3878: FROM qp_list_lines
3879: WHERE list_header_id = l_list_header_id);
3880: l_exists_in_qp_list_line NUMBER;
6117: l_start_date DATE;
6118:
6119: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
6120: SELECT 1
6121: FROM DUAL
6122: WHERE EXISTS (SELECT 1
6123: FROM qp_list_lines
6124: WHERE list_header_id = l_list_header_id);
6125:
7014: l_list_header_id NUMBER;
7015:
7016: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
7017: SELECT 1
7018: FROM DUAL
7019: WHERE EXISTS (SELECT 1
7020: FROM qp_list_lines
7021: WHERE list_header_id = l_list_header_id);
7022:
7589: l_pricing_phase_id NUMBER;
7590:
7591: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
7592: SELECT 1
7593: FROM DUAL
7594: WHERE EXISTS (SELECT 1
7595: FROM qp_list_lines
7596: WHERE list_header_id = l_list_header_id);
7597:
8873: l_api_name CONSTANT VARCHAR2(30) := 'validate_offer_approval';
8874: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8875: CURSOR c_budget_exist IS
8876: SELECT 1
8877: FROM DUAL
8878: WHERE EXISTS(
8879: SELECT 1
8880: FROM ozf_act_budgets
8881: WHERE arc_act_budget_used_by = 'OFFR'
8996: FROM ozf_offers
8997: WHERE qp_list_header_id = cp_listHeaderId;
8998:
8999: CURSOR c_voCnt(cp_listHeaderId NUMBER) IS
9000: SELECT 1 FROM dual WHERE EXISTS(SELECT
9001: 'X' FROM ozf_offer_discount_lines a, ozf_offer_discount_products b, ozf_offers c
9002: WHERE a.offer_discount_line_id = b.offer_discount_line_id
9003: AND a.offer_id = c.offer_id
9004: AND c.qp_list_header_id = cp_listHeaderId
12202: AND enabled_flag='Y');
12203:
12204: CURSOR c_access_exists(l_resource_id NUMBER,l_qp_list_header_id NUMBER) IS
12205: SELECT 1
12206: FROM DUAL
12207: WHERE EXISTS (SELECT 1
12208: FROM ams_act_access
12209: WHERE act_access_to_object_id = l_qp_list_header_id
12210: AND arc_act_access_to_object='OFFR'