DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on HR_API

Line 21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;

17: USE_BNF constant varchar2(5) := 'BNF';
18: --
19: -- date track mode constants
20: --
21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;
22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;

Line 22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;

18: --
19: -- date track mode constants
20: --
21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;
22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;

Line 23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;

19: -- date track mode constants
20: --
21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;
22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;

Line 24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;

20: --
21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;
22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;
28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;

Line 25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;

21: DTMODE_INSERT constant varchar2(30) := hr_api.g_insert;
22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;
28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;
29:

Line 26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;

22: DTMODE_UPDATE constant varchar2(30) := hr_api.g_update;
23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;
28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;
29:
30: -- cursor to get pl data and to see if bnfs are required.

Line 27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;

23: DTMODE_CORRECT constant varchar2(30) := hr_api.g_correction;
24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;
28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;
29:
30: -- cursor to get pl data and to see if bnfs are required.
31: -- If bnf's are not rqd, action item isn't rqd either.

Line 28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;

24: DTMODE_DELETE constant varchar2(30) := hr_api.g_delete;
25: DTMODE_ZAP constant varchar2(30) := hr_api.g_zap;
26: DTMODE_SYSDATE constant varchar2(30) := hr_api.g_sys;
27: DTMODE_STARTOFTIME constant varchar2(30) := hr_api.g_sot;
28: DTMODE_ENDOFTIME constant varchar2(30) := hr_api.g_eot;
29:
30: -- cursor to get pl data and to see if bnfs are required.
31: -- If bnf's are not rqd, action item isn't rqd either.
32: cursor g_bnf_pl (p_prtt_enrt_rslt_id number

Line 65: ,p_datetrack_mode in varchar2 default hr_api.g_correction

61: ,p_effective_date in date
62: ,p_business_group_id in number
63: ,p_validate in boolean default false
64: ,p_enrt_bnft_id in number default null
65: ,p_datetrack_mode in varchar2 default hr_api.g_correction
66: ,p_post_rslt_flag in varchar2 default 'Y'
67: ,p_rslt_object_version_number in out nocopy number
68: ,p_suspend_flag out nocopy varchar2
69: ,p_dpnt_actn_warning out nocopy boolean

Line 89: ,p_datetrack_mode in varchar2 default hr_api.g_correction

85: (p_validate in boolean default FALSE
86: ,p_prtt_enrt_rslt_id in number
87: ,p_effective_date in date
88: ,p_business_group_id in number
89: ,p_datetrack_mode in varchar2 default hr_api.g_correction
90: ,p_post_rslt_flag in varchar2 default 'Y'
91: ,p_rslt_object_version_number in out nocopy number
92: ,p_suspend_flag in out nocopy varchar2);
93: --

Line 103: ,p_datetrack_mode in varchar2 default hr_api.g_correction

99: (p_validate in boolean default false
100: ,p_prtt_enrt_rslt_id in number
101: ,p_effective_date in date
102: ,p_business_group_id in number
103: ,p_datetrack_mode in varchar2 default hr_api.g_correction
104: ,p_post_rslt_flag in varchar2 default 'Y'
105: ,p_rslt_object_version_number in out nocopy number
106: ,p_suspend_flag in out nocopy varchar2
107: ,p_dpnt_actn_warning out nocopy boolean

Line 121: ,p_datetrack_mode in varchar2 default hr_api.g_correction

117: (p_validate in boolean default FALSE
118: ,p_prtt_enrt_rslt_id in number
119: ,p_effective_date in date
120: ,p_business_group_id in number
121: ,p_datetrack_mode in varchar2 default hr_api.g_correction
122: ,p_post_rslt_flag in varchar2 default 'Y'
123: ,p_rslt_object_version_number in out nocopy number
124: ,p_suspend_flag in out nocopy varchar2
125: ,p_pcp_actn_warning out nocopy boolean);

Line 136: ,p_datetrack_mode in varchar2 default hr_api.g_correction

132: (p_validate in boolean default FALSE
133: ,p_prtt_enrt_rslt_id in number
134: ,p_effective_date in date
135: ,p_business_group_id in number
136: ,p_datetrack_mode in varchar2 default hr_api.g_correction
137: ,p_post_rslt_flag in varchar2 default 'Y'
138: ,p_rslt_object_version_number in out nocopy number
139: ,p_suspend_flag in out nocopy varchar2
140: ,p_pcp_dpnt_actn_warning out nocopy boolean);

Line 151: ,p_datetrack_mode in varchar2 default hr_api.g_correction

147: (p_prtt_enrt_rslt_id in number
148: ,p_effective_date in date
149: ,p_business_group_id in number
150: ,p_validate in boolean default false
151: ,p_datetrack_mode in varchar2 default hr_api.g_correction
152: ,p_post_rslt_flag in varchar2 default 'Y'
153: ,p_rslt_object_version_number in out nocopy number
154: ,p_suspend_flag in out nocopy varchar2
155: ,p_bnf_actn_warning out nocopy boolean);

Line 165: ,p_datetrack_mode in varchar2 default hr_api.g_correction

161: procedure complete_this_action_item
162: (p_prtt_enrt_actn_id in number
163: ,p_effective_date in date
164: ,p_validate in boolean default false
165: ,p_datetrack_mode in varchar2 default hr_api.g_correction
166: ,p_post_rslt_flag in varchar2 default 'Y');
167: --
168: -- this procedure will set the completed date for a single open action item
169: -- for a participant result both dependent and beneficiary

Line 181: ,p_datetrack_mode in varchar2 default hr_api.g_correction

177: ,p_effective_date in date
178: ,p_business_group_id in number
179: ,p_validate in boolean default false
180: ,p_enrt_bnft_id in number default NULL
181: ,p_datetrack_mode in varchar2 default hr_api.g_correction
182: ,p_post_rslt_flag in varchar2 default 'Y'
183: ,p_rslt_object_version_number in out nocopy number
184: ,p_suspend_flag in out nocopy varchar2
185: ,p_ctfn_actn_warning out nocopy boolean