APPS.PQH_CGN_INS dependencies on PQH_DE_CASE_GROUPS

Line 87: -- Insert the row into: pqh_de_case_groups

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: pqh_de_case_groups
88: --
89: insert into pqh_de_case_groups
90: (case_group_id
91: ,case_group_number

Line 89: insert into pqh_de_case_groups

85: --
86: --
87: -- Insert the row into: pqh_de_case_groups
88: --
89: insert into pqh_de_case_groups
90: (case_group_id
91: ,case_group_number
92: ,description
93: ,advanced_pay_grade

Line 191: Cursor C_Sel1 is select pqh_de_case_groups_s.nextval from sys.dual;

187: Procedure pre_insert
188: (p_rec in out nocopy pqh_cgn_shd.g_rec_type
189: ) is
190: --
191: Cursor C_Sel1 is select pqh_de_case_groups_s.nextval from sys.dual;
192: --
193: Cursor C_Sel2 is
194: Select null
195: from pqh_de_case_groups

Line 195: from pqh_de_case_groups

191: Cursor C_Sel1 is select pqh_de_case_groups_s.nextval from sys.dual;
192: --
193: Cursor C_Sel2 is
194: Select null
195: from pqh_de_case_groups
196: where case_group_id =
197: pqh_cgn_ins.g_case_group_id_i;
198: --
199: l_proc varchar2(72) := g_package||'pre_insert';

Line 217: fnd_message.set_token('TABLE_NAME','pqh_de_case_groups');

213: --
214: -- The primary key values are already in use.
215: --
216: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
217: fnd_message.set_token('TABLE_NAME','pqh_de_case_groups');
218: fnd_message.raise_error;
219: End If;
220: Close C_Sel2;
221: --

Line 326: (p_module_name => 'PQH_DE_CASE_GROUPS'

322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'PQH_DE_CASE_GROUPS'
327: ,p_hook_type => 'AI');
328: --
329: end;
330: --