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 1270: nvl(hr_general.decode_lookup('BEN_BENMNGLE_MD',p_mode),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1519: -- Get assignment ID form per_assignments_f table.
1520: --
1521: l_actn := 'Opening Assignment cursor...';
1522: -- Perf changes
1523: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
1524: then
1525: open c2;
1526: fetch c2 into l_assignment_id;
1527: If c2%notfound and g_audit_flag = true

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

1946: l_actn := 'Openning C1 cursor...';
1947: open c1;
1948: fetch c1 into l_exec;
1949: If c1%found then
1950: l_actn := 'Calling hr_general.describe_procedure...'; -- Bug 1504327
1951: hr_general.describe_procedure --dbms_desbribe.dbms_procedure Bug 1504327
1952: (object_name => l_exec
1953: ,reserved1 => NULL
1954: ,reserved2 => NULL

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

1947: open c1;
1948: fetch c1 into l_exec;
1949: If c1%found then
1950: l_actn := 'Calling hr_general.describe_procedure...'; -- Bug 1504327
1951: hr_general.describe_procedure --dbms_desbribe.dbms_procedure Bug 1504327
1952: (object_name => l_exec
1953: ,reserved1 => NULL
1954: ,reserved2 => NULL
1955: ,overload => l_OverLoadNum

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

2407: -- Get assignment ID form per_assignments_f table.
2408: --
2409: l_actn := 'Opening Assignment cursor...';
2410: --
2411: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
2412: then
2413: open c2;
2414: fetch c2 into l_assignment_id;
2415: If c2%notfound