DBA Data[Home] [Help]

APPS.HR_SCH_ELIG_OBJ_PKG dependencies on WF_EVENT

Line 11: ,p_event IN OUT NOCOPY wf_event_t

7: ---------------------------< create_sch_elig_obj >---------------------------
8: -----------------------------------------------------------------------------
9: --
10: FUNCTION create_sch_elig_obj(p_subscription_guid IN RAW
11: ,p_event IN OUT NOCOPY wf_event_t
12: ) RETURN VARCHAR2 IS
13: -- In Params
14: l_bg_id NUMBER;
15: l_sch_id NUMBER;

Line 33: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);

29: l_routine := 'create_sch_elig_obj';
30: hr_utility.trace('Entering '||g_module||l_routine);
31: --
32: l_bg_id := hr_general.get_business_group_id();
33: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
34: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
35: l_obj_start_date := hr_api.g_sot;
36: --
37: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);

Line 34: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');

30: hr_utility.trace('Entering '||g_module||l_routine);
31: --
32: l_bg_id := hr_general.get_business_group_id();
33: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
34: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
35: l_obj_start_date := hr_api.g_sot;
36: --
37: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);
38: --

Line 62: wf_event.seterrorinfo (p_event, 'WARNING');

58: l_routine,
59: p_event.event_name,
60: p_subscription_guid
61: );
62: wf_event.seterrorinfo (p_event, 'WARNING');
63: l_ret_mode := 'WARNING';
64: END IF;
65: --
66: hr_utility.trace('Leaving '||g_module||l_routine);

Line 78: wf_event.seterrorinfo (p_event, 'ERROR');

74: 'create_sch_elig_obj',
75: p_event.event_name,
76: p_subscription_guid
77: );
78: wf_event.seterrorinfo (p_event, 'ERROR');
79: RETURN 'ERROR';
80: END create_sch_elig_obj;
81: --
82: -----------------------------------------------------------------------------

Line 87: ,p_event IN OUT NOCOPY wf_event_t

83: ---------------------------< delete_sch_elig_obj >---------------------------
84: -----------------------------------------------------------------------------
85: --
86: FUNCTION delete_sch_elig_obj(p_subscription_guid IN RAW
87: ,p_event IN OUT NOCOPY wf_event_t
88: ) RETURN VARCHAR2 IS
89: -- In Params
90: l_bg_id NUMBER;
91: l_sch_id NUMBER;

Line 122: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);

118: l_routine := 'delete_sch_elig_obj';
119: hr_utility.trace('Entering '||g_module||l_routine);
120: --
121: l_bg_id := hr_general.get_business_group_id();
122: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
123: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
124: --
125: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);
126: --

Line 123: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');

119: hr_utility.trace('Entering '||g_module||l_routine);
120: --
121: l_bg_id := hr_general.get_business_group_id();
122: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
123: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
124: --
125: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);
126: --
127: l_mode := 'DELETE';

Line 158: wf_event.seterrorinfo (p_event, 'WARNING');

154: l_routine,
155: p_event.event_name,
156: p_subscription_guid
157: );
158: wf_event.seterrorinfo (p_event, 'WARNING');
159: l_ret_mode := 'WARNING';
160: END IF;
161: --
162: hr_utility.trace('Leaving '||g_module||l_routine);

Line 174: wf_event.seterrorinfo (p_event, 'ERROR');

170: l_routine,
171: p_event.event_name,
172: p_subscription_guid
173: );
174: wf_event.seterrorinfo (p_event, 'ERROR');
175: RETURN 'ERROR';
176: END delete_sch_elig_obj;
177: --
178: END hr_sch_elig_obj_pkg;