APPS.OZF_OFFER_PUB dependencies on OZF_OFFERS

Line 58: FROM ozf_offers

54: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
55:
56: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
57: SELECT offer_id, offer_type, custom_setup_id, offer_code, tier_level, object_version_number
58: FROM ozf_offers
59: WHERE qp_list_header_id = l_qp_list_header_id;
60:
61: CURSOR c_act_budget_obj_ver(l_act_budg_id NUMBER) IS
62: SELECT object_version_number

Line 1211: FROM ozf_offers

1207: WHERE activity_budget_id = l_act_budg_id;
1208:
1209: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
1210: SELECT offer_id, offer_type, custom_setup_id, offer_code, object_version_number
1211: FROM ozf_offers
1212: WHERE qp_list_header_id = l_qp_list_header_id;
1213:
1214: l_api_version CONSTANT NUMBER := 1.0;
1215: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';

Line 1930: FROM ozf_offers

1926: l_fund_id NUMBER;
1927:
1928: CURSOR c_offer_detail(l_list_header_id VARCHAR2) IS
1929: SELECT offer_id, object_version_number
1930: FROM ozf_offers
1931: WHERE qp_list_header_id = l_list_header_id;
1932:
1933: CURSOR c_list_line(p_list_header_id IN NUMBER) IS
1934: SELECT NVL(map.xref_line_id_value,line.list_line_id) list_line_id

Line 2005: FND_MESSAGE.set_name('OZF', 'OZF_OFFERS_NO_OFFER_TYPE');

2001: --//Validations
2002: IF p_modifier_rec.qp_list_header_id = FND_API.g_miss_num OR p_modifier_rec.qp_list_header_id IS NULL THEN
2003: IF p_modifier_rec.offer_type = FND_API.g_miss_char OR p_modifier_rec.offer_type IS NULL THEN
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2005: FND_MESSAGE.set_name('OZF', 'OZF_OFFERS_NO_OFFER_TYPE');
2006: --//Please enter a value for Offer Type
2007: FND_MSG_PUB.add;
2008: END IF;
2009: RAISE FND_API.G_EXC_ERROR;