25: l_item_key VARCHAR2(240);
26: l_process VARCHAR2(30);
27: l_user_key VARCHAR2(240);
28: --
29: varname Wf_Engine.NameTabTyp;
30: varvalue Wf_Engine.TextTabTyp;
31: numname Wf_Engine.NameTabTyp;
32: numvalue Wf_Engine.NumTabTyp;
33: --
26: l_process VARCHAR2(30);
27: l_user_key VARCHAR2(240);
28: --
29: varname Wf_Engine.NameTabTyp;
30: varvalue Wf_Engine.TextTabTyp;
31: numname Wf_Engine.NameTabTyp;
32: numvalue Wf_Engine.NumTabTyp;
33: --
34: BEGIN
27: l_user_key VARCHAR2(240);
28: --
29: varname Wf_Engine.NameTabTyp;
30: varvalue Wf_Engine.TextTabTyp;
31: numname Wf_Engine.NameTabTyp;
32: numvalue Wf_Engine.NumTabTyp;
33: --
34: BEGIN
35: l_proc:= 'per_ckl_fyi_notifications.start_wf_process';
28: --
29: varname Wf_Engine.NameTabTyp;
30: varvalue Wf_Engine.TextTabTyp;
31: numname Wf_Engine.NameTabTyp;
32: numvalue Wf_Engine.NumTabTyp;
33: --
34: BEGIN
35: l_proc:= 'per_ckl_fyi_notifications.start_wf_process';
36: hr_utility.set_location('Entering: '|| l_proc, 10);
41: l_user_key := l_item_key;
42: --
43: -- Initiate workflow process
44: --
45: Wf_Engine.CreateProcess(ItemType => l_item_type
46: ,ItemKey => l_item_key
47: ,Process => l_process
48: ,User_Key => l_user_key
49: ,Owner_Role => 'COREHR'
71: varvalue(9) := p_which_notification;
72: varname(10) := 'ALLOCATED_TO';
73: varvalue(10) := p_allocated_to;
74:
75: Wf_Engine.SetItemAttrTextArray(l_item_type
76: ,l_item_key
77: ,varname
78: ,varvalue
79: );
83: NULL;
84: --
85: -- Set date item attributes
86: --
87: Wf_Engine.SetItemAttrDate(itemtype => l_item_type
88: ,itemkey => l_item_key
89: ,aname => 'TARGET_START_DATE'
90: ,avalue => p_target_start_date
91: );
88: ,itemkey => l_item_key
89: ,aname => 'TARGET_START_DATE'
90: ,avalue => p_target_start_date
91: );
92: Wf_Engine.SetItemAttrDate(itemtype => l_item_type
93: ,itemkey => l_item_key
94: ,aname => 'TARGET_END_DATE'
95: ,avalue => p_target_end_date
96: );
93: ,itemkey => l_item_key
94: ,aname => 'TARGET_END_DATE'
95: ,avalue => p_target_end_date
96: );
97: Wf_Engine.SetItemAttrDate(itemtype => l_item_type
98: ,itemkey => l_item_key
99: ,aname => 'ACTUAL_START_DATE'
100: ,avalue => p_actual_start_date
101: );
98: ,itemkey => l_item_key
99: ,aname => 'ACTUAL_START_DATE'
100: ,avalue => p_actual_start_date
101: );
102: Wf_Engine.SetItemAttrDate(itemtype => l_item_type
103: ,itemkey => l_item_key
104: ,aname => 'ACTUAL_END_DATE'
105: ,avalue => p_actual_end_date
106: );
106: );
107: --
108: -- Start workflow process
109: --
110: Wf_Engine.StartProcess(ItemType => l_item_type
111: ,ItemKey => l_item_key
112: );
113: --
114: COMMIT;
137: l_proc:= 'per_ckl_fyi_notifications.which_notification';
138: hr_utility.set_location('Entering: '|| l_proc, 10);
139: --
140: IF funcmode = 'RUN' THEN
141: resultout := Wf_Engine.GetItemAttrText(itemtype => itemtype
142: ,itemkey => itemkey
143: ,aname => 'WHICH_NOTIFICATION'
144: ,ignore_notfound => FALSE
145: );