APPS.PQH_RSS_INS dependencies on DUAL

Line 91: ,gradual_value_number_from

87: -- Insert the row into: pqh_de_result_sets
88: --
89: insert into pqh_de_result_sets
90: (result_set_id
91: ,gradual_value_number_from
92: ,gradual_value_number_to
93: ,grade_id
94: ,object_version_number
95: )

Line 92: ,gradual_value_number_to

88: --
89: insert into pqh_de_result_sets
90: (result_set_id
91: ,gradual_value_number_from
92: ,gradual_value_number_to
93: ,grade_id
94: ,object_version_number
95: )
96: Values

Line 98: ,p_rec.gradual_value_number_from

94: ,object_version_number
95: )
96: Values
97: (p_rec.result_set_id
98: ,p_rec.gradual_value_number_from
99: ,p_rec.gradual_value_number_to
100: ,p_rec.grade_id
101: ,p_rec.object_version_number
102: );

Line 99: ,p_rec.gradual_value_number_to

95: )
96: Values
97: (p_rec.result_set_id
98: ,p_rec.gradual_value_number_from
99: ,p_rec.gradual_value_number_to
100: ,p_rec.grade_id
101: ,p_rec.object_version_number
102: );
103: --

Line 169: Cursor C_Sel1 is select pqh_de_result_sets_s.nextval from sys.dual;

165: Procedure pre_insert
166: (p_rec in out nocopy pqh_rss_shd.g_rec_type
167: ) is
168: --
169: Cursor C_Sel1 is select pqh_de_result_sets_s.nextval from sys.dual;
170: --
171: Cursor C_Sel2 is
172: Select null
173: from pqh_de_result_sets

Line 267: ,p_gradual_value_number_from

263: pqh_rss_rki.after_insert
264: (p_effective_date => p_effective_date
265: ,p_result_set_id
266: => p_rec.result_set_id
267: ,p_gradual_value_number_from
268: => p_rec.gradual_value_number_from
269: ,p_gradual_value_number_to
270: => p_rec.gradual_value_number_to
271: ,p_grade_id

Line 268: => p_rec.gradual_value_number_from

264: (p_effective_date => p_effective_date
265: ,p_result_set_id
266: => p_rec.result_set_id
267: ,p_gradual_value_number_from
268: => p_rec.gradual_value_number_from
269: ,p_gradual_value_number_to
270: => p_rec.gradual_value_number_to
271: ,p_grade_id
272: => p_rec.grade_id

Line 269: ,p_gradual_value_number_to

265: ,p_result_set_id
266: => p_rec.result_set_id
267: ,p_gradual_value_number_from
268: => p_rec.gradual_value_number_from
269: ,p_gradual_value_number_to
270: => p_rec.gradual_value_number_to
271: ,p_grade_id
272: => p_rec.grade_id
273: ,p_object_version_number

Line 270: => p_rec.gradual_value_number_to

266: => p_rec.result_set_id
267: ,p_gradual_value_number_from
268: => p_rec.gradual_value_number_from
269: ,p_gradual_value_number_to
270: => p_rec.gradual_value_number_to
271: ,p_grade_id
272: => p_rec.grade_id
273: ,p_object_version_number
274: => p_rec.object_version_number

Line 341: ,p_gradual_value_number_from in number

337: -- |---------------------------------< ins >----------------------------------|
338: -- ----------------------------------------------------------------------------
339: Procedure ins
340: (p_effective_date in date
341: ,p_gradual_value_number_from in number
342: ,p_gradual_value_number_to in number
343: ,p_grade_id in number
344: ,p_result_set_id out nocopy number
345: ,p_object_version_number out nocopy number

Line 342: ,p_gradual_value_number_to in number

338: -- ----------------------------------------------------------------------------
339: Procedure ins
340: (p_effective_date in date
341: ,p_gradual_value_number_from in number
342: ,p_gradual_value_number_to in number
343: ,p_grade_id in number
344: ,p_result_set_id out nocopy number
345: ,p_object_version_number out nocopy number
346: ) is

Line 360: ,p_gradual_value_number_from

356: --
357: l_rec :=
358: pqh_rss_shd.convert_args
359: (null
360: ,p_gradual_value_number_from
361: ,p_gradual_value_number_to
362: ,p_grade_id
363: ,null
364: );

Line 361: ,p_gradual_value_number_to

357: l_rec :=
358: pqh_rss_shd.convert_args
359: (null
360: ,p_gradual_value_number_from
361: ,p_gradual_value_number_to
362: ,p_grade_id
363: ,null
364: );
365: --