APPS.OZF_NA_RULE_HEADER_PVT dependencies on OZF_NA_RULE_HEADERS_B

Line 112: SELECT ozf_na_rule_headers_b_s.NEXTVAL

108: l_org_id NUMBER := FND_API.G_MISS_NUM;
109: l_na_rule_header_id NUMBER;
110: l_dummy NUMBER;
111: CURSOR c_id IS
112: SELECT ozf_na_rule_headers_b_s.NEXTVAL
113: FROM dual;
114:
115: CURSOR c_id_exists (l_id IN NUMBER) IS
116: SELECT 1

Line 117: FROM OZF_NA_RULE_HEADERS_B

113: FROM dual;
114:
115: CURSOR c_id_exists (l_id IN NUMBER) IS
116: SELECT 1
117: FROM OZF_NA_RULE_HEADERS_B
118: WHERE na_rule_header_id = l_id;
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT create_na_rule_header_pvt;

Line 341: FROM OZF_NA_RULE_HEADERS_B

337:
338:
339: CURSOR c_get_na_rule_header(na_rule_header_id NUMBER) IS
340: SELECT *
341: FROM OZF_NA_RULE_HEADERS_B
342: WHERE na_rule_header_id = p_na_rule_header_rec.na_rule_header_id;
343: -- Hint: Developer need to provide Where clause
344:
345:

Line 822: 'ozf_na_rule_headers_b',

818: IF p_validation_mode = JTF_PLSQL_API.g_create
819: AND p_na_rule_header_rec.na_rule_header_id IS NOT NULL
820: THEN
821: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
822: 'ozf_na_rule_headers_b',
823: 'na_rule_header_id = ''' || p_na_rule_header_rec.na_rule_header_id ||''''
824: );
825: END IF;
826:

Line 993: FROM ozf_na_rule_headers_b

989: l_return_status VARCHAR2(1);
990:
991: CURSOR c_complete IS
992: SELECT *
993: FROM ozf_na_rule_headers_b
994: WHERE na_rule_header_id = p_na_rule_header_rec.na_rule_header_id;
995: l_na_rule_header_rec c_complete%ROWTYPE;
996: BEGIN
997: x_complete_rec := p_na_rule_header_rec;