46:
47:
48:
49: PROCEDURE get_wf_attributes (
50: p_item_type in wf_items.item_type%TYPE
51: ,p_item_key in wf_items.item_key%TYPE
52: ,p_actid in number
53: );
54:
47:
48:
49: PROCEDURE get_wf_attributes (
50: p_item_type in wf_items.item_type%TYPE
51: ,p_item_key in wf_items.item_key%TYPE
52: ,p_actid in number
53: );
54:
55:
55:
56: PROCEDURE get_default_approvers(
57: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
58: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
59: p_item_type IN wf_items.item_type%TYPE,
60: p_item_key IN wf_items.item_key%TYPE
61: );
62:
63: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
56: PROCEDURE get_default_approvers(
57: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
58: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
59: p_item_type IN wf_items.item_type%TYPE,
60: p_item_key IN wf_items.item_key%TYPE
61: );
62:
63: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
64: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
63: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
64: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
65: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
66: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
67: p_item_type IN wf_items.item_type%TYPE,
68: p_item_key IN wf_items.item_key%TYPE,
69: p_effective_date IN DATE DEFAULT SYSDATE);
70:
71:
64: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
65: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
66: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
67: p_item_type IN wf_items.item_type%TYPE,
68: p_item_key IN wf_items.item_key%TYPE,
69: p_effective_date IN DATE DEFAULT SYSDATE);
70:
71:
72:
73: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
74: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
75: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
76: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
77: p_item_type IN wf_items.item_type%TYPE,
78: p_item_key IN wf_items.item_key%TYPE ,
79: p_variable_name in varchar2,
80: p_variable_value in varchar2 DEFAULT NULL
81: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG ;
74: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
75: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
76: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
77: p_item_type IN wf_items.item_type%TYPE,
78: p_item_key IN wf_items.item_key%TYPE ,
79: p_variable_name in varchar2,
80: p_variable_value in varchar2 DEFAULT NULL
81: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG ;
82:
81: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG ;
82:
83: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
84: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
85: p_item_type IN wf_items.item_type%TYPE,
86: p_item_key IN wf_items.item_key%TYPE,
87: p_approver_index IN NUMBER DEFAULT 0);
88:
89: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
82:
83: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
84: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
85: p_item_type IN wf_items.item_type%TYPE,
86: p_item_key IN wf_items.item_key%TYPE,
87: p_approver_index IN NUMBER DEFAULT 0);
88:
89: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
90: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
87: p_approver_index IN NUMBER DEFAULT 0);
88:
89: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
90: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
91: p_item_type IN wf_items.item_type%TYPE,
92: p_item_key IN wf_items.item_key%TYPE,
93: p_approver_index IN NUMBER DEFAULT 1);
94:
95:
88:
89: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
90: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
91: p_item_type IN wf_items.item_type%TYPE,
92: p_item_key IN wf_items.item_key%TYPE,
93: p_approver_index IN NUMBER DEFAULT 1);
94:
95:
96:
97: PROCEDURE add_notifier(
98: p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
99: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
100: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
101: p_item_type IN wf_items.item_type%TYPE
102: ,p_item_key IN wf_items.item_key%TYPE
103: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
104: ,p_person_id IN per_all_people_f.person_id%TYPE
105: );
98: p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
99: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
100: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
101: p_item_type IN wf_items.item_type%TYPE
102: ,p_item_key IN wf_items.item_key%TYPE
103: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
104: ,p_person_id IN per_all_people_f.person_id%TYPE
105: );
106:
109: PROCEDURE Get_all_notifiers(
110: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
111: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
112: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
113: p_item_type IN wf_items.item_type%TYPE,
114: p_item_key IN wf_items.item_key%TYPE,
115: p_effective_date IN DATE
116: );
117:
110: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
111: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
112: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
113: p_item_type IN wf_items.item_type%TYPE,
114: p_item_key IN wf_items.item_key%TYPE,
115: p_effective_date IN DATE
116: );
117:
118:
117:
118:
119:
120: PROCEDURE update_notifiers(
121: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
122: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
123: p_act_id IN NUMBER ,
124: p_notifiers_num IN NUMBER DEFAULT 0,
125: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
118:
119:
120: PROCEDURE update_notifiers(
121: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
122: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
123: p_act_id IN NUMBER ,
124: p_notifiers_num IN NUMBER DEFAULT 0,
125: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
126: hr_util_misc_web.g_varchar2_tab_default,
128: hr_util_misc_web.g_varchar2_tab_default
129:
130: );
131:
132: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
133: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
134: p_act_id IN NUMBER ,
135: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type
136: );
129:
130: );
131:
132: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
133: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
134: p_act_id IN NUMBER ,
135: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type
136: );
137:
266: ||
267: ||-----------------------------------------------------------------------*/
268:
269: PROCEDURE get_default_approvers_list(
270: p_item_type IN wf_items.item_type%TYPE,
271: p_item_key IN wf_items.item_key%TYPE,
272: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
273:
274: PROCEDURE get_default_approvers_list(
267: ||-----------------------------------------------------------------------*/
268:
269: PROCEDURE get_default_approvers_list(
270: p_item_type IN wf_items.item_type%TYPE,
271: p_item_key IN wf_items.item_key%TYPE,
272: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
273:
274: PROCEDURE get_default_approvers_list(
275: p_item_type IN wf_items.item_type%TYPE,
271: p_item_key IN wf_items.item_key%TYPE,
272: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
273:
274: PROCEDURE get_default_approvers_list(
275: p_item_type IN wf_items.item_type%TYPE,
276: p_item_key IN wf_items.item_key%TYPE,
277: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
278: p_error_message OUT NOCOPY varchar);
279:
272: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
273:
274: PROCEDURE get_default_approvers_list(
275: p_item_type IN wf_items.item_type%TYPE,
276: p_item_key IN wf_items.item_key%TYPE,
277: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
278: p_error_message OUT NOCOPY varchar);
279:
280:
288: ||
289: ||
290: ||-----------------------------------------------------------------------*/
291: PROCEDURE get_ame_approvers_list(
292: p_item_type IN wf_items.item_type%TYPE,
293: p_item_key IN wf_items.item_key%TYPE,
294: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
295:
296:
289: ||
290: ||-----------------------------------------------------------------------*/
291: PROCEDURE get_ame_approvers_list(
292: p_item_type IN wf_items.item_type%TYPE,
293: p_item_key IN wf_items.item_key%TYPE,
294: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss);
295:
296:
297: /*-----------------------------------------------------------------------
305: ||
306: ||-----------------------------------------------------------------------*/
307:
308: PROCEDURE set_ame_approvers_list(
309: p_item_type IN wf_items.item_type%TYPE,
310: p_item_key IN wf_items.item_key%TYPE,
311: p_default_approvers_list IN hr_dynamic_approver_list_ss);
312:
313: /*-----------------------------------------------------------------------
306: ||-----------------------------------------------------------------------*/
307:
308: PROCEDURE set_ame_approvers_list(
309: p_item_type IN wf_items.item_type%TYPE,
310: p_item_key IN wf_items.item_key%TYPE,
311: p_default_approvers_list IN hr_dynamic_approver_list_ss);
312:
313: /*-----------------------------------------------------------------------
314:
321: ||
322: ||-----------------------------------------------------------------------*/
323:
324: PROCEDURE get_additional_notifiers_list(
325: p_item_type IN wf_items.item_type%TYPE,
326: p_item_key IN wf_items.item_key%TYPE,
327: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss);
328:
329:
322: ||-----------------------------------------------------------------------*/
323:
324: PROCEDURE get_additional_notifiers_list(
325: p_item_type IN wf_items.item_type%TYPE,
326: p_item_key IN wf_items.item_key%TYPE,
327: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss);
328:
329:
330: end hr_dynamic_approval_web; -- Package spec