APPS.IRC_WEB dependencies on ICX_ON_UTILITIES

Line 7: l_parameters icx_on_utilities.v80_table;

3:
4: procedure show_vacancy (M in VARCHAR2) is
5:
6: l_text varchar2(2000);
7: l_parameters icx_on_utilities.v80_table;
8: l_url varchar2(2000);
9: l_vacancy_id varchar2(30);
10: l_posting_id varchar2(30);
11: l_function_name fnd_form_functions.function_name%type;

Line 30: icx_on_utilities.unpack_parameters(l_text,l_parameters);

26: --
27: l_function_name:=fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
28: --
29: l_text := icx_call.decrypt(M);
30: icx_on_utilities.unpack_parameters(l_text,l_parameters);
31: l_vacancy_id:=l_parameters(1);
32: --
33: open csr_posting(to_number(l_vacancy_id));
34: fetch csr_posting into l_posting_id;

Line 71: l_parameters icx_on_utilities.v80_table;

67:
68: procedure show_candidate (M in VARCHAR2) is
69:
70: l_text varchar2(2000);
71: l_parameters icx_on_utilities.v80_table;
72: l_url varchar2(2000);
73: l_party_id varchar2(30);
74: l_function_name fnd_form_functions.function_name%type;
75: l_session_id number;

Line 98: icx_on_utilities.unpack_parameters(l_text,l_parameters);

94: --
95: l_function_name:=fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
96: --
97: l_text := icx_call.decrypt(M);
98: icx_on_utilities.unpack_parameters(l_text,l_parameters);
99: l_party_id:=l_parameters(1);
100: open c1;
101: fetch c1 into l_person_id;
102: if c1%notfound then

Line 121: l_parameters icx_on_utilities.v80_table;

117:
118: procedure show_approval (M in VARCHAR2) is
119:
120: l_text varchar2(2000);
121: l_parameters icx_on_utilities.v80_table;
122: l_url varchar2(2000);
123: itemkey varchar2(30);
124: l_function_name fnd_form_functions.function_name%type;
125: itemtype varchar2(30);

Line 142: icx_on_utilities.unpack_parameters(l_text,l_parameters);

138: l_b:= icx_sec.validateSession(c_validate_only=>'Y');
139: l_session_id:=icx_sec.getSessionCookie;
140: --
141: l_text := icx_call.decrypt(M);
142: icx_on_utilities.unpack_parameters(l_text,l_parameters);
143: itemkey:=l_parameters(1);
144: --
145: itemtype:=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');
146: --

Line 186: l_parameters icx_on_utilities.v80_table;

182: --
183: procedure correct_approval (M in VARCHAR2) is
184:
185: l_text varchar2(2000);
186: l_parameters icx_on_utilities.v80_table;
187: l_url varchar2(2000);
188: itemkey varchar2(30);
189: l_function_name fnd_form_functions.function_name%type;
190: itemtype varchar2(30);

Line 207: icx_on_utilities.unpack_parameters(l_text,l_parameters);

203: l_b:= icx_sec.validateSession(c_validate_only=>'Y');
204: l_session_id:=icx_sec.getSessionCookie;
205: --
206: l_text := icx_call.decrypt(M);
207: icx_on_utilities.unpack_parameters(l_text,l_parameters);
208: itemkey:=l_parameters(1);
209: l_function_name:=l_parameters(2);
210: --
211: itemtype:=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');