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 HR_UTIL_MISC_WEB

Line 57: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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

Line 58: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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

Line 63: PROCEDURE get_all_approvers(p_approver_name 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,
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,

Line 64: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

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

Line 65: p_approver_flag hr_util_misc_web.g_varchar2_tab_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,
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);

Line 66: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

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

Line 73: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_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,

Line 74: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

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 ,

Line 75: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

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,

Line 76: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

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

Line 83: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_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:
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);

Line 84: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

80: p_variable_value in varchar2 DEFAULT NULL
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:

Line 89: PROCEDURE delete_approver(p_approver_name 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,
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);

Line 90: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_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,
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:

Line 98: p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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

Line 99: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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

Line 100: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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

Line 110: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,

106:
107:
108:
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,

Line 111: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,

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

Line 112: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,

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

Line 125: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT

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,
127: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
128: hr_util_misc_web.g_varchar2_tab_default
129:

Line 126: hr_util_misc_web.g_varchar2_tab_default,

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,
127: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
128: hr_util_misc_web.g_varchar2_tab_default
129:
130: );

Line 127: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT

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,
127: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
128: hr_util_misc_web.g_varchar2_tab_default
129:
130: );
131:

Line 128: hr_util_misc_web.g_varchar2_tab_default

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,
127: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type 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 ,

Line 135: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type

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