[Home] [Help]
290: IS
291: cursor c_qual_name(p_qualifier_ctx VARCHAR2,p_qualifier_attr VARCHAR2,p_qualifier_id NUMBER)
292: IS
293: SELECT QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',p_qualifier_ctx, p_qualifier_attr, p_qualifier_id)
294: from dual;
295: l_cust_name varchar2(240);
296: l_qualifier_ctx VARCHAR2 (240);
297: l_qualifier_attr VARCHAR2(240);
298: BEGIN
417:
418: FUNCTION get_list_line_no RETURN NUMBER IS
419: x number;
420: CURSOR cur_get_list_line_no IS
421: SELECT ams_qp_list_line_no_s.nextval from dual;
422: BEGIN
423: OPEN cur_get_list_line_no;
424: FETCH cur_get_list_line_no INTO x;
425: CLOSE cur_get_list_line_no;
5617: l_start_date DATE;
5618:
5619: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
5620: SELECT 1
5621: FROM DUAL
5622: WHERE EXISTS (SELECT 1
5623: FROM qp_list_lines
5624: WHERE list_header_id = l_list_header_id);
5625:
6484: l_list_header_id NUMBER;
6485:
6486: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
6487: SELECT 1
6488: FROM DUAL
6489: WHERE EXISTS (SELECT 1
6490: FROM qp_list_lines
6491: WHERE list_header_id = l_list_header_id);
6492:
7055: l_pricing_phase_id NUMBER;
7056:
7057: CURSOR c_adv_options_exist(l_list_header_id NUMBER) IS
7058: SELECT 1
7059: FROM DUAL
7060: WHERE EXISTS (SELECT 1
7061: FROM qp_list_lines
7062: WHERE list_header_id = l_list_header_id);
7063:
8339: l_api_name CONSTANT VARCHAR2(30) := 'validate_offer_approval';
8340: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8341: CURSOR c_budget_exist IS
8342: SELECT 1
8343: FROM DUAL
8344: WHERE EXISTS(
8345: SELECT 1
8346: FROM ozf_act_budgets
8347: WHERE arc_act_budget_used_by = 'OFFR'
8462: FROM ozf_offers
8463: WHERE qp_list_header_id = cp_listHeaderId;
8464:
8465: CURSOR c_voCnt(cp_listHeaderId NUMBER) IS
8466: SELECT 1 FROM dual WHERE EXISTS(SELECT
8467: 'X' FROM ozf_offer_discount_lines a, ozf_offer_discount_products b, ozf_offers c
8468: WHERE a.offer_discount_line_id = b.offer_discount_line_id
8469: AND a.offer_id = c.offer_id
8470: AND c.qp_list_header_id = cp_listHeaderId
11394: AND enabled_flag='Y');
11395:
11396: CURSOR c_access_exists(l_resource_id NUMBER,l_qp_list_header_id NUMBER) IS
11397: SELECT 1
11398: FROM DUAL
11399: WHERE EXISTS (SELECT 1
11400: FROM ams_act_access
11401: WHERE act_access_to_object_id = l_qp_list_header_id
11402: AND arc_act_access_to_object='OFFR'