eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on WF_ITEMS

Line 50: p_item_type in wf_items.item_type%TYPE

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:

Line 51: ,p_item_key in wf_items.item_key%TYPE

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:

Line 59: p_item_type IN wf_items.item_type%TYPE,

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

Line 60: p_item_key IN wf_items.item_key%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,

Line 67: p_item_type IN wf_items.item_type%TYPE,

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:

Line 68: p_item_key IN wf_items.item_key%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:
72:

Line 77: p_item_type IN wf_items.item_type%TYPE,

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 ;

Line 78: p_item_key IN wf_items.item_key%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 ;
82:

Line 85: p_item_type IN wf_items.item_type%TYPE,

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,

Line 86: p_item_key IN wf_items.item_key%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,

Line 91: p_item_type IN wf_items.item_type%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:

Line 92: p_item_key IN wf_items.item_key%TYPE,

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:

Line 101: p_item_type IN wf_items.item_type%TYPE

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

Line 102: ,p_item_key IN wf_items.item_key%TYPE

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:

Line 113: p_item_type IN wf_items.item_type%TYPE,

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:

Line 114: p_item_key IN wf_items.item_key%TYPE,

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:

Line 121: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

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

Line 122: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

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,

Line 132: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

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

Line 133: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

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:

Line 270: p_item_type IN wf_items.item_type%TYPE,

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(

Line 271: p_item_key IN wf_items.item_key%TYPE,

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,

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

Line 276: 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:
280:

Line 292: p_item_type IN wf_items.item_type%TYPE,

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:

Line 293: p_item_key IN wf_items.item_key%TYPE,

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

Line 309: p_item_type IN wf_items.item_type%TYPE,

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

Line 310: p_item_key IN wf_items.item_key%TYPE,

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:

Line 325: p_item_type IN wf_items.item_type%TYPE,

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:

Line 326: p_item_key IN wf_items.item_key%TYPE,

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