APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_OFFR_MARKET_OPTIONS

Line 92: SELECT 'N' FROM dual WHERE EXISTS(SELECT 'X' FROM ozf_offr_market_options WHERE group_number = p_group_number and qp_list_header_id = p_qp_list_header_id);

88: ) RETURN VARCHAR2
89: IS
90: l_return VARCHAR2(1) := 'Y';
91: CURSOR c_create_mo(p_group_number NUMBER, p_qp_list_header_id NUMBER) IS
92: SELECT 'N' FROM dual WHERE EXISTS(SELECT 'X' FROM ozf_offr_market_options WHERE group_number = p_group_number and qp_list_header_id = p_qp_list_header_id);
93: BEGIN
94: OPEN c_create_mo(p_group_number,p_qp_list_header_id);
95: FETCH c_create_mo INTO l_return;
96: IF(c_create_mo%NOTFOUND) THEN

Line 107: SELECT offer_market_option_id FROM ozf_offr_market_options WHERE qp_list_header_id = p_qp_list_header_id AND group_number = p_group_number;

103: FUNCTION get_market_option_id(p_group_number NUMBER,p_qp_list_header_id NUMBER)
104: RETURN NUMBER
105: IS
106: CURSOR c_mkt_option_id(p_group_number NUMBER,p_qp_list_header_id NUMBER)IS
107: SELECT offer_market_option_id FROM ozf_offr_market_options WHERE qp_list_header_id = p_qp_list_header_id AND group_number = p_group_number;
108: l_market_option_id NUMBER := -1;
109: BEGIN
110: OPEN c_mkt_option_id(p_group_number ,p_qp_list_header_id);
111: FETCH c_mkt_option_id INTO l_market_option_id;

Line 397: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options

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
398: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);
399:
400: l_mkt_opt_dtail c_mkt_opt_dtail%ROWTYPE;
401: l_mkt_option_found VARCHAR2(1) := 'N';

Line 413: SELECT offer_market_option_id FROM ozf_offr_market_options WHERE qp_list_header_id = p_qp_list_header_id

409:
410: l_qual_mo c_qual_mo%ROWTYPE;
411:
412: CURSOR c_market_option_id(p_qp_list_header_id NUMBER, p_group_number NUMBER) IS
413: SELECT offer_market_option_id FROM ozf_offr_market_options WHERE qp_list_header_id = p_qp_list_header_id
414: AND group_number = p_group_number;
415:
416: l_market_option_id NUMBER;
417:

Line 695: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options

691:
692:
693: CURSOR c_mkt_opt_dtail(p_qp_qualifier_id NUMBER)
694: IS
695: SELECT offer_market_option_id, object_version_number FROM ozf_offr_market_options
696: WHERE offer_market_option_id = (SELECT offer_market_option_id FROM ozf_qualifier_market_option WHERE qp_qualifier_id = p_qp_qualifier_id);
697:
698: l_mkt_opt_dtail c_mkt_opt_dtail%ROWTYPE;
699: l_mkt_option_found VARCHAR2(1);