APPS.HXC_TKGQC_INS dependencies on HXC_TKGQC_SHD

Line 82: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type

78: -- Internal Row Handler Use Only.
79: --
80: -- ----------------------------------------------------------------------------
81: Procedure insert_dml
82: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type
83: ) is
84: --
85: l_proc varchar2(72) ;
86: --

Line 96: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status

92: hr_utility.set_location('Entering:'||l_proc, 5);
93: end if;
94: p_rec.object_version_number := 1; -- Initialise the object version
95: --
96: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status
97: --
98: -- Insert the row into: hxc_tk_group_query_criteria
99: --
100: insert into hxc_tk_group_query_criteria

Line 125: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

121: ,sysdate
122: ,fnd_global.login_id
123: );
124: --
125: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: if g_debug then
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: end if;

Line 133: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

129: end if;
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
134: hxc_tkgqc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated

Line 134: hxc_tkgqc_shd.constraint_error

130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
134: hxc_tkgqc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

Line 138: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

134: hxc_tkgqc_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
139: hxc_tkgqc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated

Line 139: hxc_tkgqc_shd.constraint_error

135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
139: hxc_tkgqc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

Line 143: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

139: hxc_tkgqc_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
144: hxc_tkgqc_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

Line 144: hxc_tkgqc_shd.constraint_error

140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
144: hxc_tkgqc_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
148: Raise;

Line 147: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

143: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
144: hxc_tkgqc_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
148: Raise;
149: End insert_dml;
150: --
151: -- ----------------------------------------------------------------------------

Line 187: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type

183: -- Internal Row Handler Use Only.
184: --
185: -- ----------------------------------------------------------------------------
186: Procedure pre_insert
187: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type
188: ) is
189: --
190: Cursor C_Sel1 is select hxc_tk_group_query_criteria_s.nextval from sys.dual;
191: --

Line 279: (p_rec in hxc_tkgqc_shd.g_rec_type

275: -- Internal Row Handler Use Only.
276: --
277: -- ----------------------------------------------------------------------------
278: Procedure post_insert
279: (p_rec in hxc_tkgqc_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72) ;
283: --

Line 325: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type

321: -- ----------------------------------------------------------------------------
322: -- |---------------------------------< ins >----------------------------------|
323: -- ----------------------------------------------------------------------------
324: Procedure ins
325: (p_rec in out nocopy hxc_tkgqc_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) ;
329: --

Line 375: l_rec hxc_tkgqc_shd.g_rec_type;

371: ,p_tk_group_query_criteria_id out nocopy number
372: ,p_object_version_number out nocopy number
373: ) is
374: --
375: l_rec hxc_tkgqc_shd.g_rec_type;
376: l_proc varchar2(72) ;
377: --
378: Begin
379: g_debug :=hr_utility.debug_enabled;

Line 390: hxc_tkgqc_shd.convert_args

386: -- Call conversion function to turn arguments into the
387: -- p_rec structure.
388: --
389: l_rec :=
390: hxc_tkgqc_shd.convert_args
391: (null
392: ,p_tk_group_query_id
393: ,p_criteria_type
394: ,p_criteria_id