APPS.OZF_NA_RULE_LINE_PVT dependencies on OZF_NA_RULE_LINES

Line 125: SELECT ozf_na_rule_lines_s.NEXTVAL

121: l_org_id NUMBER := FND_API.G_MISS_NUM;
122: l_na_rule_line_id NUMBER;
123: l_dummy NUMBER;
124: CURSOR c_id IS
125: SELECT ozf_na_rule_lines_s.NEXTVAL
126: FROM dual;
127:
128: CURSOR c_id_exists (l_id IN NUMBER) IS
129: SELECT 1

Line 130: FROM OZF_NA_RULE_LINES

126: FROM dual;
127:
128: CURSOR c_id_exists (l_id IN NUMBER) IS
129: SELECT 1
130: FROM OZF_NA_RULE_LINES
131: WHERE na_rule_line_id = l_id;
132:
133: l_na_rule_line_rec na_rule_line_rec_type ;
134: BEGIN

Line 354: FROM OZF_NA_RULE_LINES

350:
351:
352: CURSOR c_get_na_rule_line(na_rule_line_id NUMBER) IS
353: SELECT *
354: FROM OZF_NA_RULE_LINES
355: WHERE na_rule_line_id = p_na_rule_line_rec.na_rule_line_id;
356: -- Hint: Developer need to provide Where clause
357:
358:

Line 832: 'ozf_na_rule_lines',

828: IF p_validation_mode = JTF_PLSQL_API.g_create
829: AND p_na_rule_line_rec.na_rule_line_id IS NOT NULL
830: THEN
831: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
832: 'ozf_na_rule_lines',
833: 'na_rule_line_id = ''' || p_na_rule_line_rec.na_rule_line_id ||''''
834: );
835: END IF;
836:

Line 1031: FROM ozf_na_rule_lines

1027: l_return_status VARCHAR2(1);
1028:
1029: CURSOR c_complete IS
1030: SELECT *
1031: FROM ozf_na_rule_lines
1032: WHERE na_rule_line_id = p_na_rule_line_rec.na_rule_line_id;
1033: l_na_rule_line_rec c_complete%ROWTYPE;
1034: BEGIN
1035: x_complete_rec := p_na_rule_line_rec;