APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on QP_QUALIFIERS

Line 342: SELECT 'Y' FROM dual WHERE EXISTS (SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_qp_list_header_id AND qualifier_grouping_no = p_group_number);

338: RETURN VARCHAR2
339: IS
340: --l_operation VARCHAR2(30);
341: CURSOR c_group_members_exist(p_qp_list_header_id NUMBER,p_group_number NUMBER) IS
342: SELECT 'Y' FROM dual WHERE EXISTS (SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_qp_list_header_id AND qualifier_grouping_no = p_group_number);
343: l_grp_mem_exist VARCHAR2(1) := 'A';
344: BEGIN
345: OPEN c_group_members_exist(p_qp_list_header_id,p_group_number);
346: FETCH c_group_members_exist INTO l_grp_mem_exist;

Line 393: SELECT qualifier_grouping_no FROM qp_qualifiers WHERE qualifier_id = p_qp_qualifier_id;

389: l_old_group_members_exist VARCHAR2(1);
390: l_new_group_members_exist VARCHAR2(1);
391:
392: CURSOR c_group_number(p_qp_qualifier_id NUMBER) IS
393: SELECT qualifier_grouping_no FROM qp_qualifiers WHERE qualifier_id = p_qp_qualifier_id;
394:
395: CURSOR c_mkt_opt_dtail(p_qp_qualifier_id NUMBER)
396: IS
397: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options

Line 682: SELECT qualifier_grouping_no,list_header_id FROM qp_qualifiers

678: l_api_name CONSTANT VARCHAR2(30) := 'Delete_volume_offer_qualifier';
679:
680:
681: CURSOR c_group_no(p_qualifier_id NUMBER)IS
682: SELECT qualifier_grouping_no,list_header_id FROM qp_qualifiers
683: WHERE qualifier_id = p_qualifier_id;
684: l_group_no c_group_no%ROWTYPE;
685: group_no NUMBER := 1000;
686:

Line 708: SELECT qualifier_context FROM qp_qualifiers

704: WHERE qp_qualifier_id = p_qualifier_id;
705: l_qual_mo c_qual_mo%ROWTYPE;
706:
707: CURSOR c_qualifierContext(cp_qualifierId NUMBER) IS
708: SELECT qualifier_context FROM qp_qualifiers
709: WHERE qualifier_id = cp_qualifierId;
710: l_qualifierContext VARCHAR2(30);
711: BEGIN
712: SAVEPOINT Delete_volume_offer_qual_pvt;