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_DT_API dependencies on BEN_BATCH_DT_API

Line 1: package body ben_batch_dt_api as

1: package body ben_batch_dt_api as
2: /* $Header: bendtapi.pkb 120.1 2011/03/06 10:46:48 pvelvano ship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 26: g_package varchar2(30) := 'ben_batch_dt_api.';

22: APIs.
23: */
24: --------------------------------------------------------------------------------
25: --
26: g_package varchar2(30) := 'ben_batch_dt_api.';
27: g_hash_key number := ben_hash_utility.get_hash_key;
28: g_hash_jump number := ben_hash_utility.get_hash_jump;
29: --
30: g_batch_api pls_integer := 0;

Line 195: fnd_message.set_token('PROC','ben_batch_dt_api.get_personobject');

191: if c1%notfound then
192: --
193: close c1;
194: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
195: fnd_message.set_token('PROC','ben_batch_dt_api.get_personobject');
196: fnd_message.set_token('person',p_person_id);
197: fnd_message.raise_error;
198: --
199: end if;

Line 332: fnd_message.set_token('PROC','ben_batch_dt_api.get_lerobject');

328: if c1%notfound then
329: --
330: close c1;
331: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
332: fnd_message.set_token('PROC','ben_batch_dt_api.get_lerobject');
333: fnd_message.set_token('ler',p_ler_id);
334: fnd_message.raise_error;
335: --
336: end if;

Line 469: fnd_message.set_token('PROC','ben_batch_dt_api.get_pgmobject');

465: if c1%notfound then
466: --
467: close c1;
468: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
469: fnd_message.set_token('PROC','ben_batch_dt_api.get_pgmobject');
470: fnd_message.set_token('PGM',p_pgm_id);
471: fnd_message.raise_error;
472: --
473: end if;

Line 606: fnd_message.set_token('PROC','ben_batch_dt_api.get_ptipobject');

602: if c1%notfound then
603: --
604: close c1;
605: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
606: fnd_message.set_token('PROC','ben_batch_dt_api.get_ptipobject');
607: fnd_message.set_token('ptip',p_ptip_id);
608: fnd_message.raise_error;
609: --
610: end if;

Line 743: fnd_message.set_token('PROC','ben_batch_dt_api.get_plipobject');

739: if c1%notfound then
740: --
741: close c1;
742: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
743: fnd_message.set_token('PROC','ben_batch_dt_api.get_plipobject');
744: fnd_message.set_token('plip',p_plip_id);
745: fnd_message.raise_error;
746: --
747: end if;

Line 880: fnd_message.set_token('PROC','ben_batch_dt_api.get_plobject');

876: if c1%notfound then
877: --
878: close c1;
879: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
880: fnd_message.set_token('PROC','ben_batch_dt_api.get_plobject');
881: fnd_message.set_token('pl',p_pl_id);
882: fnd_message.raise_error;
883: --
884: end if;

Line 1017: fnd_message.set_token('PROC','ben_batch_dt_api.get_elig_perobject');

1013: if c1%notfound then
1014: --
1015: close c1;
1016: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
1017: fnd_message.set_token('PROC','ben_batch_dt_api.get_elig_perobject');
1018: fnd_message.set_token('elig_per',p_elig_per_id);
1019: fnd_message.raise_error;
1020: --
1021: end if;

Line 1106: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

1102: ,p_effective_end_date in out nocopy date
1103: )
1104: is
1105: --
1106: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
1107: --
1108: l_effective_start_date date;
1109: l_effective_end_date date;
1110: --

Line 1118: ben_batch_dt_api.get_personobject

1114: l_effective_end_date := hr_api.g_eot;
1115: --
1116: -- Person
1117: --
1118: ben_batch_dt_api.get_personobject
1119: (p_person_id => p_person_id
1120: ,p_rec => l_minmax_rec
1121: );
1122: --

Line 1123: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1119: (p_person_id => p_person_id
1120: ,p_rec => l_minmax_rec
1121: );
1122: --
1123: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1124: (p_effective_date => p_effective_date
1125: ,p_parcolumn_name => 'person_id'
1126: ,p_min_esd => l_minmax_rec.min_esd
1127: ,p_max_eed => l_minmax_rec.max_eed

Line 1135: ben_batch_dt_api.get_lerobject

1131: );
1132: --
1133: if p_ler_id is not null then
1134: --
1135: ben_batch_dt_api.get_lerobject
1136: (p_ler_id => p_ler_id
1137: ,p_rec => l_minmax_rec
1138: );
1139: --

Line 1140: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1136: (p_ler_id => p_ler_id
1137: ,p_rec => l_minmax_rec
1138: );
1139: --
1140: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1141: (p_effective_date => p_effective_date
1142: ,p_parcolumn_name => 'ler_id'
1143: ,p_min_esd => l_minmax_rec.min_esd
1144: ,p_max_eed => l_minmax_rec.max_eed

Line 1156: ben_batch_dt_api.get_pgmobject

1152: -- Pgm
1153: --
1154: if p_pgm_id is not null then
1155: --
1156: ben_batch_dt_api.get_pgmobject
1157: (p_pgm_id => p_pgm_id
1158: ,p_rec => l_minmax_rec
1159: );
1160: --

Line 1161: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1157: (p_pgm_id => p_pgm_id
1158: ,p_rec => l_minmax_rec
1159: );
1160: --
1161: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1162: (p_effective_date => p_effective_date
1163: ,p_parcolumn_name => 'pgm_id'
1164: ,p_min_esd => l_minmax_rec.min_esd
1165: ,p_max_eed => l_minmax_rec.max_eed

Line 1177: ben_batch_dt_api.get_ptipobject

1173: -- Ptip
1174: --
1175: if p_ptip_id is not null then
1176: --
1177: ben_batch_dt_api.get_ptipobject
1178: (p_ptip_id => p_ptip_id
1179: ,p_rec => l_minmax_rec
1180: );
1181: --

Line 1182: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1178: (p_ptip_id => p_ptip_id
1179: ,p_rec => l_minmax_rec
1180: );
1181: --
1182: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1183: (p_effective_date => p_effective_date
1184: ,p_parcolumn_name => 'ptip_id'
1185: ,p_min_esd => l_minmax_rec.min_esd
1186: ,p_max_eed => l_minmax_rec.max_eed

Line 1198: ben_batch_dt_api.get_plipobject

1194: -- Plip
1195: --
1196: if p_plip_id is not null then
1197: --
1198: ben_batch_dt_api.get_plipobject
1199: (p_plip_id => p_plip_id
1200: ,p_rec => l_minmax_rec
1201: );
1202: --

Line 1203: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1199: (p_plip_id => p_plip_id
1200: ,p_rec => l_minmax_rec
1201: );
1202: --
1203: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1204: (p_effective_date => p_effective_date
1205: ,p_parcolumn_name => 'plip_id'
1206: ,p_min_esd => l_minmax_rec.min_esd
1207: ,p_max_eed => l_minmax_rec.max_eed

Line 1219: ben_batch_dt_api.get_plobject

1215: -- Plan
1216: --
1217: if p_pl_id is not null then
1218: --
1219: ben_batch_dt_api.get_plobject
1220: (p_pl_id => p_pl_id
1221: ,p_rec => l_minmax_rec
1222: );
1223: --

Line 1224: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

1220: (p_pl_id => p_pl_id
1221: ,p_rec => l_minmax_rec
1222: );
1223: --
1224: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
1225: (p_effective_date => p_effective_date
1226: ,p_parcolumn_name => 'pl_id'
1227: ,p_min_esd => l_minmax_rec.min_esd
1228: ,p_max_eed => l_minmax_rec.max_eed

Line 1409: ben_batch_dt_api.return_effective_dates

1405: --
1406: -- Must ensure that a row exists as of the effective date supplied
1407: -- and we need the current effective end date
1408: --
1409: ben_batch_dt_api.return_effective_dates
1410: (p_base_table_name => p_base_table_name
1411: ,p_effective_date => p_effective_date
1412: ,p_base_key_value => p_base_key_value
1413: ,p_effective_start_date => l_dummy_esd

Line 1421: ben_batch_dt_api.return_max_end_date

1417: -- We must select the maximum effective end date for the datetracked
1418: -- rows
1419: --
1420: l_max_effective_end_date :=
1421: ben_batch_dt_api.return_max_end_date
1422: (p_base_table_name => p_base_table_name
1423: ,p_base_key_value => p_base_key_value
1424: );
1425: --

Line 1463: ben_batch_dt_api.return_effective_dates

1459: --
1460: if p_datetrack_mode = hr_api.g_correction
1461: then
1462: --
1463: ben_batch_dt_api.return_effective_dates
1464: (p_base_table_name => l_table_name
1465: ,p_effective_date => p_effective_date
1466: ,p_base_key_value => p_elig_per_id
1467: ,p_effective_start_date => l_validation_start_date

Line 1476: If NOT (ben_batch_dt_api.Future_Rows_Exist

1472: then
1473: --
1474: -- Determine if any future rows exist
1475: --
1476: If NOT (ben_batch_dt_api.Future_Rows_Exist
1477: (p_base_table_name => l_table_name
1478: ,p_effective_date => p_effective_date
1479: ,p_base_key_value => p_elig_per_id
1480: )

Line 1484: ben_batch_dt_api.return_effective_dates

1480: )
1481: )
1482: then
1483: --
1484: ben_batch_dt_api.return_effective_dates
1485: (p_base_table_name => l_table_name
1486: ,p_effective_date => p_effective_date
1487: ,p_base_key_value => p_elig_per_id
1488: ,p_effective_start_date => l_effective_start_date

Line 1583: ben_batch_dt_api.return_effective_dates

1579: --
1580: if p_datetrack_mode = hr_api.g_correction
1581: then
1582: --
1583: ben_batch_dt_api.return_effective_dates
1584: (p_base_table_name => l_table_name
1585: ,p_effective_date => p_effective_date
1586: ,p_base_key_value => p_elig_per_opt_id
1587: ,p_effective_start_date => l_validation_start_date

Line 1596: If NOT (ben_batch_dt_api.Future_Rows_Exist

1592: then
1593: --
1594: -- Determine if any future rows exist
1595: --
1596: If NOT (ben_batch_dt_api.Future_Rows_Exist
1597: (p_base_table_name => l_table_name
1598: ,p_effective_date => p_effective_date
1599: ,p_base_key_value => p_elig_per_opt_id
1600: )

Line 1604: ben_batch_dt_api.return_effective_dates

1600: )
1601: )
1602: then
1603: --
1604: ben_batch_dt_api.return_effective_dates
1605: (p_base_table_name => l_table_name
1606: ,p_effective_date => p_effective_date
1607: ,p_base_key_value => p_elig_per_opt_id
1608: ,p_effective_start_date => l_effective_start_date

Line 1664: end ben_batch_dt_api;

1660: p_validation_end_date := l_validation_end_date;
1661: --
1662: end validate_dt_mode_epo;
1663: --
1664: end ben_batch_dt_api;