DBA Data[Home] [Help]

APPS.BEN_MANAGE_OVERRIDE dependencies on HR_API

Line 842: l_ppe_dt_mode := hr_api.g_zap ;

838: p_delete_next_change => l_delete_next_change );
839: */
840: --
841: if p_enrt_cvg_thru_dt < l_ppe.effective_start_date then
842: l_ppe_dt_mode := hr_api.g_zap ;
843: else
844: l_ppe_dt_mode := hr_api.g_delete ;
845: end if;
846: --

Line 844: l_ppe_dt_mode := hr_api.g_delete ;

840: --
841: if p_enrt_cvg_thru_dt < l_ppe.effective_start_date then
842: l_ppe_dt_mode := hr_api.g_zap ;
843: else
844: l_ppe_dt_mode := hr_api.g_delete ;
845: end if;
846: --
847: if l_ppe.effective_end_date > p_enrt_cvg_thru_dt then
848: --

Line 945: and ppe.effective_end_date <> hr_api.g_eot

941: and pil.per_in_ler_id=ppe.per_in_ler_id
942: and pil.business_group_id=ppe.business_group_id
943: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
944: and p_ppe_dt_to_use between ppe.effective_start_date and ppe.effective_end_date
945: and ppe.effective_end_date <> hr_api.g_eot
946: UNION
947: select ppe1.prtt_prem_id,
948: ppe1.object_version_number,
949: ppe1.effective_start_date,

Line 960: and ppe1.effective_end_date <> hr_api.g_eot

956: and pil.per_in_ler_id=ppe1.per_in_ler_id
957: and pil.business_group_id=ppe1.business_group_id
958: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
959: and ppe1.effective_start_date > p_ppe_dt_to_use
960: and ppe1.effective_end_date <> hr_api.g_eot
961: and not exists
962: (select 1
963: from ben_prtt_prem_f ppe2,
964: ben_per_in_ler pil

Line 972: and ppe2.effective_end_date <> hr_api.g_eot );

968: and pil.business_group_id=ppe2.business_group_id
969: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
970: and p_ppe_dt_to_use between
971: ppe2.effective_start_date and ppe2.effective_end_date
972: and ppe2.effective_end_date <> hr_api.g_eot );
973: --
974: l_ppe c_ppe%rowtype;
975: l_effective_start_date date;
976: l_effective_end_date date;

Line 1075: p_datetrack_mode => hr_api.g_future_change

1071: p_object_version_number => l_ppe.object_version_number,
1072: p_effective_date => l_ppe.effective_end_date,
1073: p_effective_start_date => l_effective_end_date,
1074: p_effective_end_date => l_effective_start_date,
1075: p_datetrack_mode => hr_api.g_future_change
1076: );
1077: --
1078: end if;
1079: --

Line 1261: l_ppe_datetrack_mode := hr_api.g_update_override;

1257: p_update_change_insert => l_update_change_insert);
1258:
1259: if l_update_override then
1260: --
1261: l_ppe_datetrack_mode := hr_api.g_update_override;
1262: --
1263: elsif l_update then
1264: --
1265: l_ppe_datetrack_mode := hr_api.g_update;

Line 1265: l_ppe_datetrack_mode := hr_api.g_update;

1261: l_ppe_datetrack_mode := hr_api.g_update_override;
1262: --
1263: elsif l_update then
1264: --
1265: l_ppe_datetrack_mode := hr_api.g_update;
1266: --
1267: else
1268: --
1269: l_ppe_datetrack_mode := hr_api.g_correction;

Line 1269: l_ppe_datetrack_mode := hr_api.g_correction;

1265: l_ppe_datetrack_mode := hr_api.g_update;
1266: --
1267: else
1268: --
1269: l_ppe_datetrack_mode := hr_api.g_correction;
1270: end if;
1271: --
1272: ben_prtt_prem_api.update_prtt_prem
1273: ( p_validate => FALSE

Line 1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

1333: end override_prtt_prem ;
1334: --
1335: procedure correct_prtt_enrt_rslt
1336: (p_prtt_enrt_rslt_id in number
1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date

Line 1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date

1334: --
1335: procedure correct_prtt_enrt_rslt
1336: (p_prtt_enrt_rslt_id in number
1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1339: ,p_bnft_amt in number default hr_api.g_number

1335: procedure correct_prtt_enrt_rslt
1336: (p_prtt_enrt_rslt_id in number
1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
1343: ,p_orgnl_enrt_dt in date default hr_api.g_date

Line 1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2

1336: (p_prtt_enrt_rslt_id in number
1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
1343: ,p_orgnl_enrt_dt in date default hr_api.g_date
1344: ,p_effective_date in date

Line 1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date

1337: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
1343: ,p_orgnl_enrt_dt in date default hr_api.g_date
1344: ,p_effective_date in date
1345: ) is

Line 1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2

1338: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
1343: ,p_orgnl_enrt_dt in date default hr_api.g_date
1344: ,p_effective_date in date
1345: ) is
1346: --

Line 1343: ,p_orgnl_enrt_dt in date default hr_api.g_date

1339: ,p_bnft_amt in number default hr_api.g_number
1340: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
1341: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
1342: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
1343: ,p_orgnl_enrt_dt in date default hr_api.g_date
1344: ,p_effective_date in date
1345: ) is
1346: --
1347: cursor c_pen(p_prtt_enrt_rslt_id number) is

Line 1357: l_desired_datetrack_mode varchar2(30) := hr_api.g_correction;

1353: --
1354: l_effective_date date;
1355: l_object_version_number number;
1356: l_dummy_date date;
1357: l_desired_datetrack_mode varchar2(30) := hr_api.g_correction;
1358: l_datetrack_mode varchar2(30);
1359: --
1360: begin
1361: --

Line 1580: ,p_person_id in number default hr_api.g_number

1576: procedure override_prtt_rt_val
1577: (
1578: p_validate in boolean default false
1579: ,p_prtt_rt_val_id in number
1580: ,p_person_id in number default hr_api.g_number
1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date

Line 1581: ,p_input_value_id in number default hr_api.g_number

1577: (
1578: p_validate in boolean default false
1579: ,p_prtt_rt_val_id in number
1580: ,p_person_id in number default hr_api.g_number
1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date

Line 1582: ,p_element_type_id in number default hr_api.g_number

1578: p_validate in boolean default false
1579: ,p_prtt_rt_val_id in number
1580: ,p_person_id in number default hr_api.g_number
1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2

Line 1583: ,p_enrt_rt_id in number default hr_api.g_number

1579: ,p_prtt_rt_val_id in number
1580: ,p_person_id in number default hr_api.g_number
1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

Line 1584: ,p_rt_strt_dt in date default hr_api.g_date

1580: ,p_person_id in number default hr_api.g_number
1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number

Line 1585: ,p_rt_end_dt in date default hr_api.g_date

1581: ,p_input_value_id in number default hr_api.g_number
1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

Line 1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2

1582: ,p_element_type_id in number default hr_api.g_number
1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2

Line 1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

1583: ,p_enrt_rt_id in number default hr_api.g_number
1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2

Line 1588: ,p_ordr_num in number default hr_api.g_number

1584: ,p_rt_strt_dt in date default hr_api.g_date
1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number

Line 1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

1585: ,p_rt_end_dt in date default hr_api.g_date
1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number

Line 1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2

1586: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number

Line 1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2

1587: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2

Line 1592: ,p_rt_val in number default hr_api.g_number

1588: ,p_ordr_num in number default hr_api.g_number
1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

Line 1593: ,p_ann_rt_val in number default hr_api.g_number

1589: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2

Line 1594: ,p_cmcd_rt_val in number default hr_api.g_number

1590: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2

Line 1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2

1591: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date

Line 1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

1592: ,p_rt_val in number default hr_api.g_number
1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date

Line 1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2

1593: ,p_ann_rt_val in number default hr_api.g_number
1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2

Line 1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2

1594: ,p_cmcd_rt_val in number default hr_api.g_number
1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date

1595: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number

Line 1600: ,p_elctns_made_dt in date default hr_api.g_date

1596: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number

Line 1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2

1597: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number

Line 1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1598: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number

Line 1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number

1599: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number

Line 1604: ,p_actl_prem_id in number default hr_api.g_number

1600: ,p_elctns_made_dt in date default hr_api.g_date
1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number

Line 1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number

1601: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number

Line 1606: ,p_element_entry_value_id in number default hr_api.g_number

1602: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number

Line 1607: ,p_per_in_ler_id in number default hr_api.g_number

1603: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number

Line 1608: ,p_ended_per_in_ler_id in number default hr_api.g_number

1604: ,p_actl_prem_id in number default hr_api.g_number
1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number

Line 1609: ,p_acty_base_rt_id in number default hr_api.g_number

1605: ,p_comp_lvl_fctr_id in number default hr_api.g_number
1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number

Line 1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number

1606: ,p_element_entry_value_id in number default hr_api.g_number
1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2

Line 1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number

1607: ,p_per_in_ler_id in number default hr_api.g_number
1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2

Line 1612: ,p_pp_in_yr_used_num in number default hr_api.g_number

1608: ,p_ended_per_in_ler_id in number default hr_api.g_number
1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2

Line 1613: ,p_business_group_id in number default hr_api.g_number

1609: ,p_acty_base_rt_id in number default hr_api.g_number
1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2

Line 1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2

1610: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2

Line 1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2

1611: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2

Line 1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2

1612: ,p_pp_in_yr_used_num in number default hr_api.g_number
1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2

Line 1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2

1613: ,p_business_group_id in number default hr_api.g_number
1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2

Line 1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2

1614: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2

Line 1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2

1615: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2

Line 1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2

1616: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2

Line 1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2

1617: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2

Line 1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2

1618: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2

Line 1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2

1619: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2

Line 1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2

1620: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2

Line 1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2

1621: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2

Line 1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2

1622: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2

Line 1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2

1623: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2

Line 1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2

1624: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2

Line 1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2

1625: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2

Line 1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2

1626: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2

Line 1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2

1627: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2

Line 1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2

1628: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2

Line 1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2

1629: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2

Line 1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2

1630: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2

Line 1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2

1631: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2

Line 1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2

1632: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2

Line 1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2

1633: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2

Line 1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2

1634: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2

Line 1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2

1635: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2

Line 1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2

1636: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2

Line 1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2

1637: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2

Line 1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2

1638: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number

Line 1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2

1639: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false

Line 1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2

1640: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false
1648: ,p_old_rt_strt_dt in date default hr_api.g_date

Line 1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2

1641: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false
1648: ,p_old_rt_strt_dt in date default hr_api.g_date
1649: ,p_old_rt_end_dt in date default hr_api.g_date

Line 1646: ,p_pk_id in number default hr_api.g_number

1642: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
1643: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false
1648: ,p_old_rt_strt_dt in date default hr_api.g_date
1649: ,p_old_rt_end_dt in date default hr_api.g_date
1650: ,p_object_version_number in out nocopy number

Line 1648: ,p_old_rt_strt_dt in date default hr_api.g_date

1644: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false
1648: ,p_old_rt_strt_dt in date default hr_api.g_date
1649: ,p_old_rt_end_dt in date default hr_api.g_date
1650: ,p_object_version_number in out nocopy number
1651: ,p_effective_date in date
1652: ) is

Line 1649: ,p_old_rt_end_dt in date default hr_api.g_date

1645: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
1646: ,p_pk_id in number default hr_api.g_number
1647: ,p_no_end_element in boolean default false
1648: ,p_old_rt_strt_dt in date default hr_api.g_date
1649: ,p_old_rt_end_dt in date default hr_api.g_date
1650: ,p_object_version_number in out nocopy number
1651: ,p_effective_date in date
1652: ) is
1653: --

Line 1861: ,p_datetrack_delete_mode =>hr_api.g_zap

1857: if l_zap_future_ee.creator_type ='F' and l_zap_future_ee.creator_id is not null then
1858: --
1859: py_element_entry_api.delete_element_entry
1860: (p_validate =>p_validate
1861: ,p_datetrack_delete_mode =>hr_api.g_zap
1862: ,p_effective_date =>l_zap_future_ee.effective_end_date
1863: ,p_element_entry_id =>l_zap_future_ee.element_entry_id
1864: ,p_object_version_number =>l_zap_future_ee.object_version_number
1865: ,p_effective_start_date =>l_effective_start_date

Line 1926: (l_rt_end_dt <> hr_api.g_eot and

1922: --
1923: --Even the amount is changed, we need to end the element properly if required
1924: --
1925: if p_rt_end_dt < p_rt_strt_dt or
1926: (l_rt_end_dt <> hr_api.g_eot and
1927: l_rt_end_dt <> p_old_rt_end_dt ) or
1928: (l_rt_end_dt <> hr_api.g_eot and (
1929: l_current_prv.rt_val <> p_rt_val or
1930: l_current_prv.ann_rt_val <> p_ann_rt_val or

Line 1928: (l_rt_end_dt <> hr_api.g_eot and (

1924: --
1925: if p_rt_end_dt < p_rt_strt_dt or
1926: (l_rt_end_dt <> hr_api.g_eot and
1927: l_rt_end_dt <> p_old_rt_end_dt ) or
1928: (l_rt_end_dt <> hr_api.g_eot and (
1929: l_current_prv.rt_val <> p_rt_val or
1930: l_current_prv.ann_rt_val <> p_ann_rt_val or
1931: l_current_prv.cmcd_rt_val <> p_cmcd_rt_val ))then
1932: --

Line 1993: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

1989: end override_prtt_rt_val ;
1990: --
1991: procedure override_certifications
1992: (p_prtt_enrt_rslt_id in number
1993: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1994: ,p_effective_date in date
1995: ,p_business_group_id in number
1996: ) is
1997: --

Line 2001: l_desired_datetrack_mode varchar2(30) := hr_api.g_correction;

1997: --
1998: l_effective_date date;
1999: l_object_version_number number;
2000: l_dummy_date date;
2001: l_desired_datetrack_mode varchar2(30) := hr_api.g_correction;
2002: l_datetrack_mode varchar2(30);
2003: l_pea_effective_start_date date;
2004: l_pea_effective_end_date date;
2005: --

Line 2063: ,p_datetrack_mode => hr_api.g_correction

2059: ,p_business_group_id => p_business_group_id
2060: ,p_effective_start_date => l_pea_effective_start_date
2061: ,p_effective_end_date => l_pea_effective_end_date
2062: ,p_object_version_number => l_pea.pea_object_version_number
2063: ,p_datetrack_mode => hr_api.g_correction
2064: );
2065: hr_utility.set_location('After ben_prtt_enrt_actn_api.update_prtt_enrt_actn ',20);
2066: --
2067: end loop ;

Line 2078: ,p_datetrack_mode => hr_api.g_correction

2074: ,p_effective_date => p_effective_date
2075: ,p_post_rslt_flag => 'N'
2076: ,p_business_group_id => p_business_group_id
2077: ,p_object_version_number => l_object_version_number
2078: ,p_datetrack_mode => hr_api.g_correction
2079: ,p_called_from => 'BENEOPEH' );
2080: --
2081: end if;
2082: close c_pen;