DBA Data[Home] [Help]

APPS.PER_CKL_FYI_NOTIFICATIONS dependencies on WF_ENGINE

Line 29: varname Wf_Engine.NameTabTyp;

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: --

Line 30: varvalue Wf_Engine.TextTabTyp;

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

Line 31: numname Wf_Engine.NameTabTyp;

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';

Line 32: numvalue Wf_Engine.NumTabTyp;

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);

Line 45: Wf_Engine.CreateProcess(ItemType => l_item_type

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'

Line 75: Wf_Engine.SetItemAttrTextArray(l_item_type

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: );

Line 87: Wf_Engine.SetItemAttrDate(itemtype => l_item_type

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: );

Line 92: Wf_Engine.SetItemAttrDate(itemtype => l_item_type

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: );

Line 97: Wf_Engine.SetItemAttrDate(itemtype => l_item_type

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: );

Line 102: Wf_Engine.SetItemAttrDate(itemtype => l_item_type

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: );

Line 110: Wf_Engine.StartProcess(ItemType => l_item_type

106: );
107: --
108: -- Start workflow process
109: --
110: Wf_Engine.StartProcess(ItemType => l_item_type
111: ,ItemKey => l_item_key
112: );
113: --
114: COMMIT;

Line 141: resultout := Wf_Engine.GetItemAttrText(itemtype => itemtype

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: );