APPS.OZF_OFFR_QUAL_PVT dependencies on OZF_OFFER_QUALIFIERS

Line 98: SELECT ozf_offer_qualifiers_s.NEXTVAL

94: l_qualifier_id NUMBER;
95: l_dummy NUMBER;
96: l_ozf_offr_qual_rec ozf_offr_qual_rec_type;
97: CURSOR c_id IS
98: SELECT ozf_offer_qualifiers_s.NEXTVAL
99: FROM dual;
100:
101: CURSOR c_id_exists (l_id IN NUMBER) IS
102: SELECT 1

Line 103: FROM OZF_OFFER_QUALIFIERS

99: FROM dual;
100:
101: CURSOR c_id_exists (l_id IN NUMBER) IS
102: SELECT 1
103: FROM OZF_OFFER_QUALIFIERS
104: WHERE qualifier_id = l_id;
105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT create_offr_qual_pvt;

Line 348: FROM OZF_OFFER_QUALIFIERS

344:
345:
346: CURSOR c_get_offr_qual(qualifier_id NUMBER) IS
347: SELECT *
348: FROM OZF_OFFER_QUALIFIERS
349: WHERE qualifier_id = p_ozf_offr_qual_rec.qualifier_id;
350: -- Hint: Developer need to provide Where clause
351:
352:

Line 847: 'ozf_offer_qualifiers',

843: IF p_validation_mode = JTF_PLSQL_API.g_create
844: AND p_ozf_offr_qual_rec.qualifier_id IS NOT NULL
845: THEN
846: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
847: 'ozf_offer_qualifiers',
848: 'qualifier_id = ''' || p_ozf_offr_qual_rec.qualifier_id ||''''
849: );
850: END IF;
851:

Line 1038: FROM ozf_offer_qualifiers

1034: l_return_status VARCHAR2(1);
1035:
1036: CURSOR c_complete IS
1037: SELECT *
1038: FROM ozf_offer_qualifiers
1039: WHERE qualifier_id = p_ozf_offr_qual_rec.qualifier_id;
1040: l_ozf_offr_qual_rec c_complete%ROWTYPE;
1041: BEGIN
1042: x_complete_rec := p_ozf_offr_qual_rec;