DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on HR_GENERAL

Line 64: * to hr_general.describe_procedure in procedure

60: * factors.
61: * 30-Jun-03 vsethi 115.37 Changed reference for table ben_rptg_grp
62: * MLS compliant view ben_rptg_grp_v
63: * 12-Jan-04 vvprabhu 115.38 Changed the calls to dbms_describe.dbms_procedure
64: * to hr_general.describe_procedure in procedure
65: * get_rpt_header
66: * 21-Jun-04 kmahendr 115.39 Corrected Prompt for legal Entity.
67: * 20-Aug-04 nhunur 115.40 Added a procedure for person selection rule
68: * with proper error handling.

Line 1274: nvl(hr_general.decode_lookup('BEN_BENMNGLE_MD',p_mode),

1270: -- bug 5450842
1271: if p_mode is not null AND p_mode <> hr_api.g_varchar2
1272: then
1273: write(p_text => 'Run Mode :' ||
1274: nvl(hr_general.decode_lookup('BEN_BENMNGLE_MD',p_mode),
1275: hr_general.decode_lookup('BEN_BENCLENR_MD',p_mode))); -- 1674123
1276: end if;
1277: -- end 5450842
1278: write(p_text => 'Validation Mode :' ||

Line 1275: hr_general.decode_lookup('BEN_BENCLENR_MD',p_mode))); -- 1674123

1271: if p_mode is not null AND p_mode <> hr_api.g_varchar2
1272: then
1273: write(p_text => 'Run Mode :' ||
1274: nvl(hr_general.decode_lookup('BEN_BENMNGLE_MD',p_mode),
1275: hr_general.decode_lookup('BEN_BENCLENR_MD',p_mode))); -- 1674123
1276: end if;
1277: -- end 5450842
1278: write(p_text => 'Validation Mode :' ||
1279: hr_general.decode_lookup('YES_NO',p_validate));

Line 1279: hr_general.decode_lookup('YES_NO',p_validate));

1275: hr_general.decode_lookup('BEN_BENCLENR_MD',p_mode))); -- 1674123
1276: end if;
1277: -- end 5450842
1278: write(p_text => 'Validation Mode :' ||
1279: hr_general.decode_lookup('YES_NO',p_validate));
1280: write(p_text => 'Benefit Action ID :' ||
1281: to_char(p_benefit_action_id));
1282: write(p_text => 'Effective Date :' ||
1283: to_char(p_effective_date,'DD/MM/YYYY'));

Line 1292: hr_general.decode_lookup('YES_NO',p_derivable_factors));

1288: --
1289: l_actn := 'printing p_derivable_factors';
1290: If (nvl(p_derivable_factors,'xxxx') <> hr_api.g_varchar2) then
1291: write(p_text =>'Derivable Factors :'||
1292: hr_general.decode_lookup('YES_NO',p_derivable_factors));
1293: End if;
1294: --
1295: l_actn := 'Printing p_pgm_id';
1296: If (nvl(p_pgm_id,-1) <> hr_api.g_number) then

Line 1343: hr_general.decode_lookup('YES_NO',p_no_programs));

1339: --
1340: l_actn := 'Printting p_no_program...';
1341: If (nvl(p_no_programs,'xxxx') <> hr_api.g_varchar2) then
1342: write(p_text => 'Just Plans not in Programs :'||
1343: hr_general.decode_lookup('YES_NO',p_no_programs));
1344: End if;
1345: --
1346: l_actn := 'Printting p_no_plans...';
1347: If (nvl(p_no_plans,'xxxx') <> hr_api.g_varchar2) then

Line 1349: hr_general.decode_lookup('YES_NO',p_no_plans));

1345: --
1346: l_actn := 'Printting p_no_plans...';
1347: If (nvl(p_no_plans,'xxxx') <> hr_api.g_varchar2) then
1348: write(p_text => 'Just Programs :'||
1349: hr_general.decode_lookup('YES_NO',p_no_plans));
1350: End if;
1351: --
1352: l_actn := 'Printting p_rptg_grp_id...';
1353: If (nvl(p_rptg_grp_id,-1) <> hr_api.g_number) then

Line 1472: hr_general.decode_lookup('YES_NO',p_audit_log));

1468: --
1469: l_actn := 'Printting p_audit_log...';
1470: If (nvl(p_audit_log,'xxxx') <> hr_api.g_varchar2) then
1471: write(p_text => 'Audit log flag :'||
1472: hr_general.decode_lookup('YES_NO',p_audit_log));
1473: End if;
1474: hr_utility.set_location ('Leaving '||l_proc,10);
1475: exception
1476: when others then

Line 1527: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'

1523: -- Get assignment ID form per_assignments_f table.
1524: --
1525: l_actn := 'Opening Assignment cursor...';
1526: -- Perf changes
1527: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
1528: then
1529: open c2;
1530: fetch c2 into l_assignment_id;
1531: If c2%notfound

Line 1960: l_actn := 'Calling hr_general.describe_procedure...'; -- Bug 1504327

1956: l_actn := 'Openning C1 cursor...';
1957: open c1;
1958: fetch c1 into l_exec;
1959: If c1%found then
1960: l_actn := 'Calling hr_general.describe_procedure...'; -- Bug 1504327
1961: hr_general.describe_procedure --dbms_desbribe.dbms_procedure Bug 1504327
1962: (object_name => l_exec
1963: ,reserved1 => NULL
1964: ,reserved2 => NULL

Line 1961: hr_general.describe_procedure --dbms_desbribe.dbms_procedure Bug 1504327

1957: open c1;
1958: fetch c1 into l_exec;
1959: If c1%found then
1960: l_actn := 'Calling hr_general.describe_procedure...'; -- Bug 1504327
1961: hr_general.describe_procedure --dbms_desbribe.dbms_procedure Bug 1504327
1962: (object_name => l_exec
1963: ,reserved1 => NULL
1964: ,reserved2 => NULL
1965: ,overload => l_OverLoadNum

Line 2423: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'

2419: -- Get assignment ID form per_assignments_f table.
2420: --
2421: l_actn := 'Opening Assignment cursor...';
2422: --
2423: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
2424: then
2425: open c2;
2426: fetch c2 into l_assignment_id;
2427: If c2%notfound