DBA Data[Home] [Help]

APPS.HXC_TKS_INS dependencies on HXC_TK_TIMEKEEPER_SUBMITS

Line 98: -- Insert the row into: hxc_tk_timekeeper_submits

94: --
95: --
96: --
97: --
98: -- Insert the row into: hxc_tk_timekeeper_submits
99: --
100: insert into hxc_tk_timekeeper_submits
101: (submission_id
102: ,resource_id

Line 100: insert into hxc_tk_timekeeper_submits

96: --
97: --
98: -- Insert the row into: hxc_tk_timekeeper_submits
99: --
100: insert into hxc_tk_timekeeper_submits
101: (submission_id
102: ,resource_id
103:
104: )

Line 178: Cursor C_Sel1 is select hxc_tk_timekeeper_submits_s.nextval from sys.dual;

174: Procedure pre_insert
175: (p_rec in out nocopy hxc_tks_shd.g_rec_type
176: ) is
177: --
178: Cursor C_Sel1 is select hxc_tk_timekeeper_submits_s.nextval from sys.dual;
179: --
180: Cursor C_Sel2 is
181: Select null
182: from hxc_tk_timekeeper_submits

Line 182: from hxc_tk_timekeeper_submits

178: Cursor C_Sel1 is select hxc_tk_timekeeper_submits_s.nextval from sys.dual;
179: --
180: Cursor C_Sel2 is
181: Select null
182: from hxc_tk_timekeeper_submits
183: where submission_id =
184: hxc_tks_ins.g_submission_id_i;
185: --
186: l_proc varchar2(72) ;

Line 208: fnd_message.set_token('TABLE_NAME','hxc_tk_timekeeper_submits');

204: --
205: -- The primary key values are already in use.
206: --
207: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
208: fnd_message.set_token('TABLE_NAME','hxc_tk_timekeeper_submits');
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel2;
212: --

Line 294: (p_module_name => 'HXC_TK_TIMEKEEPER_SUBMITS'

290: --
291: when hr_api.cannot_find_prog_unit then
292: --
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'HXC_TK_TIMEKEEPER_SUBMITS'
295: ,p_hook_type => 'AI'); */
296: null;
297: --
298: end;