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_PRTT_REIMBMT_RQST_API dependencies on HR_API

Line 27: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

23: and pen.business_group_id = p_business_group_id
24: and pen.prtt_enrt_rslt_stat_cd is null
25: and p_effective_date between
26: pen.effective_start_date and pen.effective_end_date
27: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
28: --
29: l_pen c_pen%rowtype;
30: l_proc_cd varchar2(30) := null;
31: l_proc varchar2(72) := g_package||'generate_communications';

Line 161: and prc.effective_end_date = hr_api.g_eot

157: and ((prc.popl_yr_perd_id_1 = p_popl_yr_perd and
158: prc.amt_year2 is null) or
159: (prc.popl_yr_perd_id_2 = p_popl_yr_perd
160: and prc.amt_year1 is null))
161: and prc.effective_end_date = hr_api.g_eot
162: and prc.prtt_reimbmt_rqst_id = pry.prtt_reimbmt_rqst_id
163: ;
164: cursor c_prc_overlap(p_pl_id number ,
165: p_person_id number,

Line 754: when hr_api.cannot_find_prog_unit then

750: ,p_Aprvd_for_pymt_amt => p_Aprvd_for_pymt_amt
751: ,p_exp_incurd_dt => p_exp_incurd_dt
752: );
753: exception
754: when hr_api.cannot_find_prog_unit then
755: hr_api.cannot_find_prog_unit_error
756: (
757: p_module_name => 'CREATE_PRTT_REIMBMT_RQST'
758: ,p_hook_type => 'BP'

Line 755: hr_api.cannot_find_prog_unit_error

751: ,p_exp_incurd_dt => p_exp_incurd_dt
752: );
753: exception
754: when hr_api.cannot_find_prog_unit then
755: hr_api.cannot_find_prog_unit_error
756: (
757: p_module_name => 'CREATE_PRTT_REIMBMT_RQST'
758: ,p_hook_type => 'BP'
759: );

Line 930: when hr_api.cannot_find_prog_unit then

926: ,p_Aprvd_for_pymt_amt => p_Aprvd_for_pymt_amt
927: ,p_exp_incurd_dt => p_exp_incurd_dt
928: );
929: exception
930: when hr_api.cannot_find_prog_unit then
931: hr_api.cannot_find_prog_unit_error
932: (p_module_name => 'CREATE_PRTT_REIMBMT_RQST'
933: ,p_hook_type => 'AP'
934: );

Line 931: hr_api.cannot_find_prog_unit_error

927: ,p_exp_incurd_dt => p_exp_incurd_dt
928: );
929: exception
930: when hr_api.cannot_find_prog_unit then
931: hr_api.cannot_find_prog_unit_error
932: (p_module_name => 'CREATE_PRTT_REIMBMT_RQST'
933: ,p_hook_type => 'AP'
934: );
935: --

Line 981: raise hr_api.validate_enabled;

977: --
978: -- When in validation only mode raise the Validate_Enabled exception
979: --
980: if p_validate then
981: raise hr_api.validate_enabled;
982: end if;
983: --
984: -- Set all output arguments
985: --

Line 995: when hr_api.validate_enabled then

991: hr_utility.set_location(' Leaving:'||l_proc, 70);
992: --
993: exception
994: --
995: when hr_api.validate_enabled then
996: --
997: -- As the Validate_Enabled exception has been raised
998: -- we must rollback to the savepoint
999: --

Line 1029: ,p_incrd_from_dt in date default hr_api.g_date

1025: (p_validate in boolean default false
1026: ,p_prtt_reimbmt_rqst_id in number
1027: ,p_effective_start_date out nocopy date
1028: ,p_effective_end_date out nocopy date
1029: ,p_incrd_from_dt in date default hr_api.g_date
1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2

Line 1030: ,p_incrd_to_dt in date default hr_api.g_date

1026: ,p_prtt_reimbmt_rqst_id in number
1027: ,p_effective_start_date out nocopy date
1028: ,p_effective_end_date out nocopy date
1029: ,p_incrd_from_dt in date default hr_api.g_date
1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number

Line 1031: ,p_rqst_num in number default hr_api.g_number

1027: ,p_effective_start_date out nocopy date
1028: ,p_effective_end_date out nocopy date
1029: ,p_incrd_from_dt in date default hr_api.g_date
1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2

Line 1032: ,p_rqst_amt in number default hr_api.g_number

1028: ,p_effective_end_date out nocopy date
1029: ,p_incrd_from_dt in date default hr_api.g_date
1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2

Line 1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2

1029: ,p_incrd_from_dt in date default hr_api.g_date
1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2

Line 1034: ,p_rqst_btch_num in number default hr_api.g_number

1030: ,p_incrd_to_dt in date default hr_api.g_date
1031: ,p_rqst_num in number default hr_api.g_number
1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number

Line 1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2

1032: ,p_rqst_amt in number default hr_api.g_number
1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number

Line 1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2

1033: ,p_rqst_amt_uom in varchar2 default hr_api.g_varchar2
1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number

Line 1038: ,p_submitter_person_id in number default hr_api.g_number

1034: ,p_rqst_btch_num in number default hr_api.g_number
1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number

Line 1039: ,p_recipient_person_id in number default hr_api.g_number

1035: ,p_prtt_reimbmt_rqst_stat_cd in out nocopy varchar2
1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number

Line 1040: ,p_provider_person_id in number default hr_api.g_number

1036: ,p_reimbmt_ctfn_typ_prvdd_cd in varchar2 default hr_api.g_varchar2
1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number

Line 1041: ,p_provider_ssn_person_id in number default hr_api.g_number

1037: ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number

Line 1042: ,p_pl_id in number default hr_api.g_number

1038: ,p_submitter_person_id in number default hr_api.g_number
1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number

Line 1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number

1039: ,p_recipient_person_id in number default hr_api.g_number
1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number

Line 1044: ,p_contact_relationship_id in number default hr_api.g_number

1040: ,p_provider_person_id in number default hr_api.g_number
1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number

Line 1045: ,p_business_group_id in number default hr_api.g_number

1041: ,p_provider_ssn_person_id in number default hr_api.g_number
1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number

Line 1046: ,p_opt_id in number default hr_api.g_number

1042: ,p_pl_id in number default hr_api.g_number
1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number

Line 1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number

1043: ,p_gd_or_svc_typ_id in number default hr_api.g_number
1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2

Line 1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number

1044: ,p_contact_relationship_id in number default hr_api.g_number
1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_amt_year1 in number default hr_api.g_number

1045: ,p_business_group_id in number default hr_api.g_number
1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_amt_year2 in number default hr_api.g_number

1046: ,p_opt_id in number default hr_api.g_number
1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2

Line 1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2

1047: ,p_popl_yr_perd_id_1 in number default hr_api.g_number
1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2

Line 1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2

1048: ,p_popl_yr_perd_id_2 in number default hr_api.g_number
1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2

Line 1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2

1049: ,p_amt_year1 in number default hr_api.g_number
1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2

Line 1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2

1050: ,p_amt_year2 in number default hr_api.g_number
1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2

Line 1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2

1051: ,p_prc_attribute_category in varchar2 default hr_api.g_varchar2
1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2

Line 1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2

1052: ,p_prc_attribute1 in varchar2 default hr_api.g_varchar2
1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2

1053: ,p_prc_attribute2 in varchar2 default hr_api.g_varchar2
1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2

1054: ,p_prc_attribute3 in varchar2 default hr_api.g_varchar2
1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2

1055: ,p_prc_attribute4 in varchar2 default hr_api.g_varchar2
1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2

1056: ,p_prc_attribute5 in varchar2 default hr_api.g_varchar2
1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2

1057: ,p_prc_attribute6 in varchar2 default hr_api.g_varchar2
1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2

Line 1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2

1058: ,p_prc_attribute7 in varchar2 default hr_api.g_varchar2
1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2

Line 1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2

1059: ,p_prc_attribute8 in varchar2 default hr_api.g_varchar2
1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2

Line 1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2

1060: ,p_prc_attribute9 in varchar2 default hr_api.g_varchar2
1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2

Line 1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2

1061: ,p_prc_attribute10 in varchar2 default hr_api.g_varchar2
1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2

Line 1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2

1062: ,p_prc_attribute11 in varchar2 default hr_api.g_varchar2
1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2

Line 1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2

1063: ,p_prc_attribute12 in varchar2 default hr_api.g_varchar2
1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2

Line 1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2

1064: ,p_prc_attribute13 in varchar2 default hr_api.g_varchar2
1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2

Line 1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2

1065: ,p_prc_attribute14 in varchar2 default hr_api.g_varchar2
1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2

Line 1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2

1066: ,p_prc_attribute15 in varchar2 default hr_api.g_varchar2
1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2

Line 1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2

1067: ,p_prc_attribute16 in varchar2 default hr_api.g_varchar2
1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2

Line 1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2

1068: ,p_prc_attribute17 in varchar2 default hr_api.g_varchar2
1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2

Line 1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2

1069: ,p_prc_attribute18 in varchar2 default hr_api.g_varchar2
1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2

Line 1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2

1070: ,p_prc_attribute19 in varchar2 default hr_api.g_varchar2
1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2

Line 1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2

1071: ,p_prc_attribute20 in varchar2 default hr_api.g_varchar2
1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2

Line 1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2

1072: ,p_prc_attribute21 in varchar2 default hr_api.g_varchar2
1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2

Line 1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2

1073: ,p_prc_attribute22 in varchar2 default hr_api.g_varchar2
1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2

Line 1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2

1074: ,p_prc_attribute23 in varchar2 default hr_api.g_varchar2
1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2

1075: ,p_prc_attribute24 in varchar2 default hr_api.g_varchar2
1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1083: ,p_comment_id in number default hr_api.g_number

Line 1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2

1076: ,p_prc_attribute25 in varchar2 default hr_api.g_varchar2
1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1083: ,p_comment_id in number default hr_api.g_number
1084: ,p_object_version_number in out nocopy number

Line 1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2

1077: ,p_prc_attribute26 in varchar2 default hr_api.g_varchar2
1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1083: ,p_comment_id in number default hr_api.g_number
1084: ,p_object_version_number in out nocopy number
1085: ,p_effective_date in date

Line 1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1078: ,p_prc_attribute27 in varchar2 default hr_api.g_varchar2
1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1083: ,p_comment_id in number default hr_api.g_number
1084: ,p_object_version_number in out nocopy number
1085: ,p_effective_date in date
1086: ,p_datetrack_mode in varchar2

Line 1083: ,p_comment_id in number default hr_api.g_number

1079: ,p_prc_attribute28 in varchar2 default hr_api.g_varchar2
1080: ,p_prc_attribute29 in varchar2 default hr_api.g_varchar2
1081: ,p_prc_attribute30 in varchar2 default hr_api.g_varchar2
1082: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1083: ,p_comment_id in number default hr_api.g_number
1084: ,p_object_version_number in out nocopy number
1085: ,p_effective_date in date
1086: ,p_datetrack_mode in varchar2
1087: ,p_stat_rsn_cd in out nocopy varchar2

Line 1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2

1086: ,p_datetrack_mode in varchar2
1087: ,p_stat_rsn_cd in out nocopy varchar2
1088: ,p_pymt_stat_cd in out nocopy varchar2
1089: ,p_pymt_stat_rsn_cd in out nocopy varchar2
1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2

1087: ,p_stat_rsn_cd in out nocopy varchar2
1088: ,p_pymt_stat_cd in out nocopy varchar2
1089: ,p_pymt_stat_rsn_cd in out nocopy varchar2
1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2

Line 1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2

1088: ,p_pymt_stat_cd in out nocopy varchar2
1089: ,p_pymt_stat_rsn_cd in out nocopy varchar2
1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2

Line 1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2

1089: ,p_pymt_stat_rsn_cd in out nocopy varchar2
1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date

Line 1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2

1090: ,p_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number

Line 1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2

1091: ,p_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number
1099: ,p_Aprvd_for_pymt_amt in out nocopy number

Line 1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2

1092: ,p_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number
1099: ,p_Aprvd_for_pymt_amt in out nocopy number
1100: ,p_exp_incurd_dt in date default hr_api.g_date

Line 1097: ,p_Submtd_dt in date default hr_api.g_date

1093: ,p_pymt_stat_ovrdn_flag in varchar2 default hr_api.g_varchar2
1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number
1099: ,p_Aprvd_for_pymt_amt in out nocopy number
1100: ,p_exp_incurd_dt in date default hr_api.g_date
1101: ) is

Line 1098: ,p_Ttl_rqst_amt in number default hr_api.g_number

1094: ,p_pymt_stat_ovrdn_rsn_cd in varchar2 default hr_api.g_varchar2
1095: ,p_pymt_stat_prr_to_ovrd in varchar2 default hr_api.g_varchar2
1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number
1099: ,p_Aprvd_for_pymt_amt in out nocopy number
1100: ,p_exp_incurd_dt in date default hr_api.g_date
1101: ) is
1102: -- DECLARE CURSORS

Line 1100: ,p_exp_incurd_dt in date default hr_api.g_date

1096: ,p_Adjmt_flag in varchar2 default hr_api.g_varchar2
1097: ,p_Submtd_dt in date default hr_api.g_date
1098: ,p_Ttl_rqst_amt in number default hr_api.g_number
1099: ,p_Aprvd_for_pymt_amt in out nocopy number
1100: ,p_exp_incurd_dt in date default hr_api.g_date
1101: ) is
1102: -- DECLARE CURSORS
1103: --- Select old information to find the status
1104: Cursor c_prcold is

Line 1164: if p_exp_incurd_dt <> hr_api.g_date then

1160: close c_prcold ;
1161: --
1162: l_object_version_number := p_object_version_number;
1163: --
1164: if p_exp_incurd_dt <> hr_api.g_date then
1165: find_popl_yr_perd (p_pl_id => p_pl_id,
1166: p_business_group_id => p_business_group_id,
1167: p_effective_date => l_prc_old.SUBMTD_DT,
1168: p_exp_incurd_dt => p_exp_incurd_dt,

Line 1253: when hr_api.cannot_find_prog_unit then

1249: ,p_Aprvd_for_pymt_amt => p_Aprvd_for_pymt_amt
1250: ,p_exp_incurd_dt => p_exp_incurd_dt
1251: );
1252: exception
1253: when hr_api.cannot_find_prog_unit then
1254: hr_api.cannot_find_prog_unit_error
1255: (p_module_name => 'UPDATE_PRTT_REIMBMT_RQST'
1256: ,p_hook_type => 'BP'
1257: );

Line 1254: hr_api.cannot_find_prog_unit_error

1250: ,p_exp_incurd_dt => p_exp_incurd_dt
1251: );
1252: exception
1253: when hr_api.cannot_find_prog_unit then
1254: hr_api.cannot_find_prog_unit_error
1255: (p_module_name => 'UPDATE_PRTT_REIMBMT_RQST'
1256: ,p_hook_type => 'BP'
1257: );
1258: --

Line 1511: when hr_api.cannot_find_prog_unit then

1507: ,p_Aprvd_for_pymt_amt => p_Aprvd_for_pymt_amt
1508: ,p_exp_incurd_dt => p_exp_incurd_dt
1509: );
1510: exception
1511: when hr_api.cannot_find_prog_unit then
1512: hr_api.cannot_find_prog_unit_error
1513: (p_module_name => 'UPDATE_PRTT_REIMBMT_RQST'
1514: ,p_hook_type => 'AP'
1515: );

Line 1512: hr_api.cannot_find_prog_unit_error

1508: ,p_exp_incurd_dt => p_exp_incurd_dt
1509: );
1510: exception
1511: when hr_api.cannot_find_prog_unit then
1512: hr_api.cannot_find_prog_unit_error
1513: (p_module_name => 'UPDATE_PRTT_REIMBMT_RQST'
1514: ,p_hook_type => 'AP'
1515: );
1516: --

Line 1539: raise hr_api.validate_enabled;

1535: --
1536: -- When in validation only mode raise the Validate_Enabled exception
1537: --
1538: if p_validate then
1539: raise hr_api.validate_enabled;
1540: end if;
1541: --
1542: -- Set all output arguments
1543: --

Line 1552: when hr_api.validate_enabled then

1548: hr_utility.set_location(' Leaving:'||l_proc, 70);
1549: --
1550: exception
1551: --
1552: when hr_api.validate_enabled then
1553: --
1554: -- As the Validate_Enabled exception has been raised
1555: -- we must rollback to the savepoint
1556: --

Line 1624: when hr_api.cannot_find_prog_unit then

1620: ,p_effective_date => trunc(p_effective_date)
1621: ,p_datetrack_mode => p_datetrack_mode
1622: );
1623: exception
1624: when hr_api.cannot_find_prog_unit then
1625: hr_api.cannot_find_prog_unit_error
1626: (p_module_name => 'DELETE_PRTT_REIMBMT_RQST'
1627: ,p_hook_type => 'BP'
1628: );

Line 1625: hr_api.cannot_find_prog_unit_error

1621: ,p_datetrack_mode => p_datetrack_mode
1622: );
1623: exception
1624: when hr_api.cannot_find_prog_unit then
1625: hr_api.cannot_find_prog_unit_error
1626: (p_module_name => 'DELETE_PRTT_REIMBMT_RQST'
1627: ,p_hook_type => 'BP'
1628: );
1629: --

Line 1659: when hr_api.cannot_find_prog_unit then

1655: ,p_effective_date => trunc(p_effective_date)
1656: ,p_datetrack_mode => p_datetrack_mode
1657: );
1658: exception
1659: when hr_api.cannot_find_prog_unit then
1660: hr_api.cannot_find_prog_unit_error
1661: (p_module_name => 'DELETE_PRTT_REIMBMT_RQST'
1662: ,p_hook_type => 'AP'
1663: );

Line 1660: hr_api.cannot_find_prog_unit_error

1656: ,p_datetrack_mode => p_datetrack_mode
1657: );
1658: exception
1659: when hr_api.cannot_find_prog_unit then
1660: hr_api.cannot_find_prog_unit_error
1661: (p_module_name => 'DELETE_PRTT_REIMBMT_RQST'
1662: ,p_hook_type => 'AP'
1663: );
1664: --

Line 1673: raise hr_api.validate_enabled;

1669: hr_utility.set_location(l_proc, 60);
1670: -- When in validation only mode raise the Validate_Enabled exception
1671: --
1672: if p_validate then
1673: raise hr_api.validate_enabled;
1674: end if;
1675: --
1676: hr_utility.set_location(' Leaving:'||l_proc, 70);
1677: --

Line 1680: when hr_api.validate_enabled then

1676: hr_utility.set_location(' Leaving:'||l_proc, 70);
1677: --
1678: exception
1679: --
1680: when hr_api.validate_enabled then
1681: --
1682: -- As the Validate_Enabled exception has been raised
1683: -- we must rollback to the savepoint
1684: --