APPS.PQH_LCD_INS dependencies on DUAL

Line 94: ,gradual_value_number

90: (level_code_id
91: ,level_number_id
92: ,level_code
93: ,description
94: ,gradual_value_number
95: ,object_version_number
96: )
97: Values
98: (p_rec.level_code_id

Line 102: ,p_rec.gradual_value_number

98: (p_rec.level_code_id
99: ,p_rec.level_number_id
100: ,p_rec.level_code
101: ,p_rec.description
102: ,p_rec.gradual_value_number
103: ,p_rec.object_version_number
104: );
105: --
106: --

Line 171: Cursor C_Sel1 is select pqh_de_level_codes_s.nextval from sys.dual;

167: Procedure pre_insert
168: (p_rec in out nocopy pqh_lcd_shd.g_rec_type
169: ) is
170: --
171: Cursor C_Sel1 is select pqh_de_level_codes_s.nextval from sys.dual;
172: --
173: Cursor C_Sel2 is
174: Select null
175: from pqh_de_level_codes

Line 273: ,p_gradual_value_number

269: ,p_level_code
270: => p_rec.level_code
271: ,p_description
272: => p_rec.description
273: ,p_gradual_value_number
274: => p_rec.gradual_value_number
275: ,p_object_version_number
276: => p_rec.object_version_number
277: );

Line 274: => p_rec.gradual_value_number

270: => p_rec.level_code
271: ,p_description
272: => p_rec.description
273: ,p_gradual_value_number
274: => p_rec.gradual_value_number
275: ,p_object_version_number
276: => p_rec.object_version_number
277: );
278: --

Line 340: ,p_gradual_value_number in number

336: Procedure ins
337: (p_level_number_id in number
338: ,p_level_code in varchar2
339: ,p_description in varchar2
340: ,p_gradual_value_number in number
341: ,p_level_code_id out nocopy number
342: ,p_object_version_number out nocopy number
343: ) is
344: --

Line 360: ,p_gradual_value_number

356: (null
357: ,p_level_number_id
358: ,p_level_code
359: ,p_description
360: ,p_gradual_value_number
361: ,null
362: );
363: --
364: -- Having converted the arguments into the pqh_lcd_rec