eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BATCH_UTILS dependencies on HR_API

Line 158: ,p_cvg_thru_dt in date Default hr_api.g_eot

154: ,p_uom in varchar2 Default NULL
155: ,p_cst_amt in number Default NULL
156: ,p_credit_amt in number Default NULL
157: ,p_cvg_strt_dt in date Default NULL
158: ,p_cvg_thru_dt in date Default hr_api.g_eot
159: ,p_prtt_enrt_rslt_id in number default NULL
160: ,p_effective_date in date
161: ,P_actn_cd in varchar2
162: ,p_suspended in varchar2 default 'N'

Line 374: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is

370: -- ============================================================================
371: -- <>
372: -- ============================================================================
373: --
374: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is
375: L_proc varchar2(80) := g_package||'.ini';
376: Begin
377: hr_utility.set_location ('Entering '||l_proc,05);
378: If(p_actn_cd = hr_api.g_varchar2) then

Line 378: If(p_actn_cd = hr_api.g_varchar2) then

374: Procedure ini(p_actn_cd varchar2 default hr_api.g_varchar2) is
375: L_proc varchar2(80) := g_package||'.ini';
376: Begin
377: hr_utility.set_location ('Entering '||l_proc,05);
378: If(p_actn_cd = hr_api.g_varchar2) then
379: ini_comp_obj;
380: ini_person;
381: ini_comp_obj_name;
382: Elsif(upper(substr(p_actn_cd,1,6)) = 'PERSON' ) then

Line 1238: ,p_pgm_id in number default hr_api.g_number

1234: ,p_validate in varchar2
1235: ,p_benefit_action_id in number
1236: ,p_effective_date in date
1237: ,p_business_group_id in number
1238: ,p_pgm_id in number default hr_api.g_number
1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number

Line 1239: ,p_pl_id in number default hr_api.g_number

1235: ,p_benefit_action_id in number
1236: ,p_effective_date in date
1237: ,p_business_group_id in number
1238: ,p_pgm_id in number default hr_api.g_number
1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number

Line 1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number

1236: ,p_effective_date in date
1237: ,p_business_group_id in number
1238: ,p_pgm_id in number default hr_api.g_number
1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number

Line 1241: ,p_person_id in number default hr_api.g_number

1237: ,p_business_group_id in number
1238: ,p_pgm_id in number default hr_api.g_number
1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number

Line 1242: ,p_person_type_id in number default hr_api.g_number

1238: ,p_pgm_id in number default hr_api.g_number
1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number

Line 1243: ,p_ler_id in number default hr_api.g_number

1239: ,p_pl_id in number default hr_api.g_number
1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number

Line 1244: ,p_organization_id in number default hr_api.g_number

1240: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number

Line 1245: ,p_benfts_grp_id in number default hr_api.g_number

1241: ,p_person_id in number default hr_api.g_number
1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2

Line 1246: ,p_location_id in number default hr_api.g_number

1242: ,p_person_type_id in number default hr_api.g_number
1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2

Line 1247: ,p_legal_entity_id in number default hr_api.g_number

1243: ,p_ler_id in number default hr_api.g_number
1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number

Line 1248: ,p_payroll_id in number default hr_api.g_number

1244: ,p_organization_id in number default hr_api.g_number
1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number

Line 1249: ,p_no_programs in varchar2 default hr_api.g_varchar2

1245: ,p_benfts_grp_id in number default hr_api.g_number
1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number

Line 1250: ,p_no_plans in varchar2 default hr_api.g_varchar2

1246: ,p_location_id in number default hr_api.g_number
1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number

Line 1251: ,p_rptg_grp_id in number default hr_api.g_number

1247: ,p_legal_entity_id in number default hr_api.g_number
1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

Line 1252: ,p_pl_typ_id in number default hr_api.g_number

1248: ,p_payroll_id in number default hr_api.g_number
1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2

Line 1253: ,p_opt_id in number default hr_api.g_number

1249: ,p_no_programs in varchar2 default hr_api.g_varchar2
1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number

Line 1254: ,p_eligy_prfl_id in number default hr_api.g_number

1250: ,p_no_plans in varchar2 default hr_api.g_varchar2
1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number

Line 1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

1251: ,p_rptg_grp_id in number default hr_api.g_number
1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number

Line 1256: ,p_mode in varchar2 default hr_api.g_varchar2

1252: ,p_pl_typ_id in number default hr_api.g_number
1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2

Line 1257: ,p_person_selection_rule_id in number default hr_api.g_number

1253: ,p_opt_id in number default hr_api.g_number
1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1261: ,p_audit_log in varchar2 default hr_api.g_varchar2

Line 1258: ,p_comp_selection_rule_id in number default hr_api.g_number

1254: ,p_eligy_prfl_id in number default hr_api.g_number
1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1261: ,p_audit_log in varchar2 default hr_api.g_varchar2
1262: ) is

Line 1259: ,p_enrt_perd_id in number default hr_api.g_number

1255: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1261: ,p_audit_log in varchar2 default hr_api.g_varchar2
1262: ) is
1263: l_proc varchar2(80) := g_package||'.print_parameters';

Line 1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2

1256: ,p_mode in varchar2 default hr_api.g_varchar2
1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1261: ,p_audit_log in varchar2 default hr_api.g_varchar2
1262: ) is
1263: l_proc varchar2(80) := g_package||'.print_parameters';
1264: l_string varchar2(80);

Line 1261: ,p_audit_log in varchar2 default hr_api.g_varchar2

1257: ,p_person_selection_rule_id in number default hr_api.g_number
1258: ,p_comp_selection_rule_id in number default hr_api.g_number
1259: ,p_enrt_perd_id in number default hr_api.g_number
1260: ,p_derivable_factors in varchar2 default hr_api.g_varchar2
1261: ,p_audit_log in varchar2 default hr_api.g_varchar2
1262: ) is
1263: l_proc varchar2(80) := g_package||'.print_parameters';
1264: l_string varchar2(80);
1265: l_actn varchar2(80);

Line 1271: if p_mode is not null AND p_mode <> hr_api.g_varchar2

1267: hr_utility.set_location ('Entering '||l_proc,10);
1268: write(p_text => 'Runtime Parameters');
1269: write(p_text => '------------------');
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

Line 1285: if (nvl(p_enrt_perd_id, -1) <> hr_api.g_number) then

1281: to_char(p_benefit_action_id));
1282: write(p_text => 'Effective Date :' ||
1283: to_char(p_effective_date,'DD/MM/YYYY'));
1284: write(p_text =>'Business Group ID :' || p_business_group_id);
1285: if (nvl(p_enrt_perd_id, -1) <> hr_api.g_number) then
1286: write(p_text =>'Enrollment period Id :' || p_enrt_perd_id);
1287: end if;
1288: --
1289: l_actn := 'printing p_derivable_factors';

Line 1290: If (nvl(p_derivable_factors,'xxxx') <> hr_api.g_varchar2) then

1286: write(p_text =>'Enrollment period Id :' || p_enrt_perd_id);
1287: end if;
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: --

Line 1296: If (nvl(p_pgm_id,-1) <> hr_api.g_number) then

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
1297: write(p_text => 'Program ID :'||
1298: benutils.iftrue
1299: (p_expression => p_pgm_id is null
1300: ,p_true => 'All'

Line 1305: If (nvl(p_pl_id,-1) <> hr_api.g_number) then

1301: ,p_false => p_pgm_id));
1302: End if;
1303: --
1304: l_actn := 'printing p_pl_id...';
1305: If (nvl(p_pl_id,-1) <> hr_api.g_number) then
1306: write(p_text => 'Plan ID :'||
1307: benutils.iftrue
1308: (p_expression => p_pl_id is null
1309: ,p_true => 'All'

Line 1314: If (nvl(p_pl_typ_id,-1) <> hr_api.g_number) then

1310: ,p_false => p_pl_id));
1311: End if;
1312: --
1313: l_actn := 'Printing p_pl_typ_id...';
1314: If (nvl(p_pl_typ_id,-1) <> hr_api.g_number) then
1315: write(p_text => 'Plan Type ID :'||
1316: benutils.iftrue
1317: (p_expression => p_pl_typ_id is null
1318: ,p_true => 'All'

Line 1323: If (nvl(p_opt_id,-1) <> hr_api.g_number) then

1319: ,p_false => p_pl_typ_id));
1320: End if;
1321: --
1322: l_actn := 'Printting p_opt_id... ';
1323: If (nvl(p_opt_id,-1) <> hr_api.g_number) then
1324: write(p_text => 'Option ID :'||
1325: benutils.iftrue
1326: (p_expression => p_opt_id is null
1327: ,p_true => 'All'

Line 1332: If (nvl(p_popl_enrt_typ_cycl_id,-1) <> hr_api.g_number) then

1328: ,p_false => p_opt_id));
1329: End if;
1330: --
1331: l_actn := 'Printting p_popl_enrt_typ_cycl...';
1332: If (nvl(p_popl_enrt_typ_cycl_id,-1) <> hr_api.g_number) then
1333: write(p_text => 'Enrollment Type Cycle :'||
1334: benutils.iftrue
1335: (p_expression => p_popl_enrt_typ_cycl_id is null
1336: ,p_true => 'All'

Line 1341: If (nvl(p_no_programs,'xxxx') <> hr_api.g_varchar2) then

1337: ,p_false => p_popl_enrt_typ_cycl_id));
1338: End if;
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: --

Line 1347: If (nvl(p_no_plans,'xxxx') <> hr_api.g_varchar2) then

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
1348: write(p_text => 'Just Programs :'||
1349: hr_general.decode_lookup('YES_NO',p_no_plans));
1350: End if;
1351: --

Line 1353: If (nvl(p_rptg_grp_id,-1) <> hr_api.g_number) then

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
1354: write(p_text => 'Reporting Group :'||
1355: benutils.iftrue
1356: (p_expression => p_rptg_grp_id is null
1357: ,p_true => 'All'

Line 1362: If (nvl(p_eligy_prfl_id,-1) <> hr_api.g_number) then

1358: ,p_false => p_rptg_grp_id));
1359: End if;
1360: --
1361: l_actn := 'Printting p_eligy_prfl_id...';
1362: If (nvl(p_eligy_prfl_id,-1) <> hr_api.g_number) then
1363: write(p_text => 'Eligiblity Profile :'||
1364: benutils.iftrue
1365: (p_expression => p_eligy_prfl_id is null
1366: ,p_true => 'All'

Line 1371: If (nvl(p_vrbl_rt_prfl_id,-1) <> hr_api.g_number) then

1367: ,p_false => p_eligy_prfl_id));
1368: End if;
1369: --
1370: l_actn := 'Printting p_vrbl_rt_prfl_id...';
1371: If (nvl(p_vrbl_rt_prfl_id,-1) <> hr_api.g_number) then
1372: write(p_text => 'Variable Rate Profile :'||
1373: benutils.iftrue
1374: (p_expression => p_vrbl_rt_prfl_id is null
1375: ,p_true => 'All'

Line 1380: If (nvl(p_person_selection_rule_id,-1) <> hr_api.g_number) then

1376: ,p_false => p_vrbl_rt_prfl_id));
1377: End if;
1378: --
1379: l_actn := 'Printting p_person_selection_rule_id...';
1380: If (nvl(p_person_selection_rule_id,-1) <> hr_api.g_number) then
1381: write(p_text => 'Person Selection Rule :'||
1382: benutils.iftrue
1383: (p_expression => p_person_selection_rule_id is null
1384: ,p_true => 'None'

Line 1389: If (nvl(p_person_id,-1) <> hr_api.g_number) then

1385: ,p_false => p_person_selection_rule_id));
1386: End if;
1387: --
1388: l_actn := 'Printting p_person_id...';
1389: If (nvl(p_person_id,-1) <> hr_api.g_number) then
1390: write(p_text => 'Person ID :'||
1391: benutils.iftrue
1392: (p_expression => p_person_id is null
1393: ,p_true => 'None'

Line 1398: If (nvl(p_person_type_id,-1) <> hr_api.g_number) then

1394: ,p_false => p_person_id));
1395: End if;
1396: --
1397: l_actn := 'Printting p_person_type_id...';
1398: If (nvl(p_person_type_id,-1) <> hr_api.g_number) then
1399: write(p_text => 'Person Type ID :'||
1400: benutils.iftrue
1401: (p_expression => p_person_type_id is null
1402: ,p_true => 'None'

Line 1407: If (nvl(p_ler_id,-1) <> hr_api.g_number) then

1403: ,p_false => p_person_type_id));
1404: End if;
1405: --
1406: l_actn := 'Printting p_ler_id...';
1407: If (nvl(p_ler_id,-1) <> hr_api.g_number) then
1408: write(p_text => 'Ler ID :'||
1409: benutils.iftrue
1410: (p_expression => p_ler_id is null
1411: ,p_true => 'None'

Line 1416: If (nvl(p_organization_id,-1) <> hr_api.g_number) then

1412: ,p_false => p_ler_id));
1413: End if;
1414: --
1415: l_actn := 'Printting p_organization_id...';
1416: If (nvl(p_organization_id,-1) <> hr_api.g_number) then
1417: write(p_text => 'Organization ID :'||
1418: benutils.iftrue
1419: (p_expression => p_organization_id is null
1420: ,p_true => 'None'

Line 1425: If (nvl(p_benfts_grp_id,-1) <> hr_api.g_number) then

1421: ,p_false => p_organization_id));
1422: End if;
1423: --
1424: l_actn := 'Printting p_benfts_grp_id...';
1425: If (nvl(p_benfts_grp_id,-1) <> hr_api.g_number) then
1426: write(p_text => 'Benefits Group ID :'||
1427: benutils.iftrue
1428: (p_expression => p_benfts_grp_id is null
1429: ,p_true => 'None'

Line 1434: If (nvl(p_location_id,-1) <> hr_api.g_number) then

1430: ,p_false => p_benfts_grp_id));
1431: End if;
1432: --
1433: l_actn := 'Printting p_location_id...';
1434: If (nvl(p_location_id,-1) <> hr_api.g_number) then
1435: write(p_text => 'Location ID :'||
1436: benutils.iftrue
1437: (p_expression => p_location_id is null
1438: ,p_true => 'None'

Line 1443: If (nvl(p_legal_entity_id,-1) <> hr_api.g_number) then

1439: ,p_false => p_location_id));
1440: End if;
1441: --
1442: l_actn := 'Printting p_legal_entity_id...';
1443: If (nvl(p_legal_entity_id,-1) <> hr_api.g_number) then
1444: write(p_text => 'Legal Entity ID :'||
1445: benutils.iftrue
1446: (p_expression => p_legal_entity_id is null
1447: ,p_true => 'None'

Line 1452: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then

1448: ,p_false => p_legal_entity_id));
1449: End if;
1450: --
1451: l_actn := 'Printting p_payroll_id...';
1452: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then
1453: write(p_text => 'Payroll ID :'||
1454: benutils.iftrue
1455: (p_expression => p_payroll_id is null
1456: ,p_true => 'None'

Line 1461: If (nvl(p_comp_selection_rule_id,-1) <> hr_api.g_number) then

1457: ,p_false => p_payroll_id));
1458: End if;
1459: --
1460: l_actn := 'Printting p_comp_selection_rule_id...';
1461: If (nvl(p_comp_selection_rule_id,-1) <> hr_api.g_number) then
1462: write(p_text => 'Comp Object Selection Rule :'||
1463: benutils.iftrue
1464: (p_expression => p_comp_selection_rule_id is null
1465: ,p_true => 'None'

Line 1470: If (nvl(p_audit_log,'xxxx') <> hr_api.g_varchar2) then

1466: ,p_false => p_comp_selection_rule_id));
1467: End if;
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);

Line 2330: hr_api.mandatory_arg_error

2326: IF (p_base_key_value IS NOT NULL) THEN
2327: IF p_base_table_name IS NULL OR
2328: p_base_key_column IS NULL THEN
2329: -- Mandatory arg checking
2330: hr_api.mandatory_arg_error
2331: (p_api_name => l_proc,
2332: p_argument => 'p_base_table_name',
2333: p_argument_value => p_base_table_name);
2334: --

Line 2335: hr_api.mandatory_arg_error

2331: (p_api_name => l_proc,
2332: p_argument => 'p_base_table_name',
2333: p_argument_value => p_base_table_name);
2334: --
2335: hr_api.mandatory_arg_error
2336: (p_api_name => l_proc,
2337: p_argument => 'p_base_key_column',
2338: p_argument_value => p_base_key_column);
2339: --