APPS.BEN_BNR_SHD dependencies on BEN_RPTG_GRP

Line 36: If (p_constraint_name = 'BEN_RPTG_GRP_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_RPTG_GRP_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'BEN_RPTG_GRP_PK') Then

37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_RPTG_GRP_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 116: from ben_rptg_grp

112: function_code,
113: legislation_code,
114: object_version_number,
115: ordr_num --iRec
116: from ben_rptg_grp
117: where rptg_grp_id = p_rptg_grp_id;
118: --
119: l_proc varchar2(72) := g_package||'api_updating';
120: l_fct_ret boolean;

Line 225: from ben_rptg_grp

221: function_code,
222: legislation_code,
223: object_version_number,
224: ordr_num --iRec
225: from ben_rptg_grp
226: where rptg_grp_id = p_rptg_grp_id
227: for update nowait;
228: --
229: l_proc varchar2(72) := g_package||'lck';

Line 268: fnd_message.set_token('TABLE_NAME', 'ben_rptg_grp');

264: -- The object is locked therefore we need to supply a meaningful
265: -- error message.
266: --
267: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
268: fnd_message.set_token('TABLE_NAME', 'ben_rptg_grp');
269: fnd_message.raise_error;
270: End lck;
271: --
272: -- ----------------------------------------------------------------------------

Line 385: delete from BEN_RPTG_GRP_TL T

381: Procedure add_language
382: is
383: begin
384:
385: delete from BEN_RPTG_GRP_TL T
386: where not exists
387: (select NULL
388: from BEN_RPTG_GRP B
389: where B.RPTG_GRP_ID = T.RPTG_GRP_ID

Line 388: from BEN_RPTG_GRP B

384:
385: delete from BEN_RPTG_GRP_TL T
386: where not exists
387: (select NULL
388: from BEN_RPTG_GRP B
389: where B.RPTG_GRP_ID = T.RPTG_GRP_ID
390: );
391:
392: update ben_rptg_grp_tl t set (

Line 392: update ben_rptg_grp_tl t set (

388: from BEN_RPTG_GRP B
389: where B.RPTG_GRP_ID = T.RPTG_GRP_ID
390: );
391:
392: update ben_rptg_grp_tl t set (
393: function_code,
394: name
395: ) = (select
396: b.function_code,

Line 398: from ben_rptg_grp_tl b

394: name
395: ) = (select
396: b.function_code,
397: b.name
398: from ben_rptg_grp_tl b
399: where b.RPTG_GRP_ID = t.RPTG_GRP_ID
400: and b.language = t.source_lang)
401: where (
402: t.RPTG_GRP_ID,

Line 407: from ben_rptg_grp_tl subb, ben_rptg_grp_tl subt

403: t.language
404: ) in (select
405: subt.RPTG_GRP_ID,
406: subt.language
407: from ben_rptg_grp_tl subb, ben_rptg_grp_tl subt
408: where subb.RPTG_GRP_ID = subt.RPTG_GRP_ID
409: and subb.language = subt.source_lang
410: and (subb.name <> subt.name
411: or subb.function_code <> subt.function_code

Line 414: insert into ben_rptg_grp_tl (

410: and (subb.name <> subt.name
411: or subb.function_code <> subt.function_code
412: ));
413:
414: insert into ben_rptg_grp_tl (
415: RPTG_GRP_ID,
416: function_code,
417: name,
418: language,

Line 436: from ben_rptg_grp_tl b, fnd_languages l

432: b.last_updated_by,
433: b.last_update_login,
434: b.created_by,
435: b.creation_date
436: from ben_rptg_grp_tl b, fnd_languages l
437: where l.installed_flag in ('I', 'B')
438: and b.language = userenv('LANG')
439: and not exists
440: (select null

Line 441: from ben_rptg_grp_tl t

437: where l.installed_flag in ('I', 'B')
438: and b.language = userenv('LANG')
439: and not exists
440: (select null
441: from ben_rptg_grp_tl t
442: where t.rptg_grp_id = b.rptg_grp_id
443: and t.language = l.language_code);
444: end add_language;
445: --