APPS.IEM_SPV_ACTIONS_PVT dependencies on FND_PROFILE

Line 24: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

20: l_msg_data VARCHAR2(2000);
21: l_post_mdts iem_rt_proc_emails%rowtype;
22: l_class_name iem_route_classifications.name%type;
23: MOVE_MSG_FAIL exception;
24: l_current_user NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: l_spv_resource_id number := 0;
26: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
27: l_interaction_id NUMBER;
28: l_activity_id NUMBER;

Line 96: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

92: where aa.action_id = 31 and aa.action_item_id = 45
93: and aa.default_wrap_id = wu.wrap_id;
94:
95: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
96: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
97: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
98: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
99: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
100: x_return_status => l_return_status,

Line 97: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

93: and aa.default_wrap_id = wu.wrap_id;
94:
95: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
96: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
97: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
98: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
99: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
100: x_return_status => l_return_status,
101: x_msg_count => l_msg_count,

Line 98: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

94:
95: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
96: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
97: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
98: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
99: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
100: x_return_status => l_return_status,
101: x_msg_count => l_msg_count,
102: x_msg_data => l_msg_data,

Line 99: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

95: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
96: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
97: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
98: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
99: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
100: x_return_status => l_return_status,
101: x_msg_count => l_msg_count,
102: x_msg_data => l_msg_data,
103: x_interaction_id => l_interaction_id,

Line 124: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

120: where aa.action_id = 31 and aa.action_item_id = 45
121: and aa.default_wrap_id = wu.wrap_id;
122:
123: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
124: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
125: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
126: p_user_id => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
127: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
128: x_return_status => l_return_status,

Line 125: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

121: and aa.default_wrap_id = wu.wrap_id;
122:
123: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
124: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
125: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
126: p_user_id => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
127: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,

Line 126: p_user_id => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

122:
123: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
124: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
125: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
126: p_user_id => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
127: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,
130: x_msg_data => l_msg_data,

Line 127: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

123: JTF_IH_PUB.Update_Interaction( p_api_version => 1.0,
124: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
125: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
126: p_user_id => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
127: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,
130: x_msg_data => l_msg_data,
131: p_interaction_rec => l_interaction_rec

Line 152: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

148: l_activity_rec.action_item_id := 45;-- EMAIL
149:
150:
151: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
152: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
153: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
154: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
155: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
156: x_return_status => l_return_status,

Line 153: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

149:
150:
151: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
152: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
153: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
154: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
155: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
156: x_return_status => l_return_status,
157: x_msg_count => l_msg_count,

Line 154: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

150:
151: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
152: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
153: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
154: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
155: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
156: x_return_status => l_return_status,
157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data,

Line 155: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

151: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
152: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
153: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
154: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
155: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
156: x_return_status => l_return_status,
157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data,
159: p_activity_rec => l_activity_rec,

Line 178: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

174:
175: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
176: 'T',
177: 'F',
178: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
179: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
180: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
181: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
182: l_return_status,

Line 179: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

175: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
176: 'T',
177: 'F',
178: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
179: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
180: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
181: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
182: l_return_status,
183: l_msg_count,

Line 180: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

176: 'T',
177: 'F',
178: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
179: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
180: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
181: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
182: l_return_status,
183: l_msg_count,
184: l_msg_data,

Line 181: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

177: 'F',
178: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
179: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
180: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
181: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
182: l_return_status,
183: l_msg_count,
184: l_msg_data,
185: l_media_lc_rec,

Line 195: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

191: -- Close Interaction
192: l_interaction_rec.interaction_id:=l_interaction_id;
193:
194: JTF_IH_PUB.Close_Interaction( p_api_version => 1.0,
195: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
196: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
197: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
198: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
199: x_return_status => l_return_status,

Line 196: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

192: l_interaction_rec.interaction_id:=l_interaction_id;
193:
194: JTF_IH_PUB.Close_Interaction( p_api_version => 1.0,
195: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
196: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
197: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
198: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
199: x_return_status => l_return_status,
200: x_msg_count => l_msg_count,

Line 197: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

193:
194: JTF_IH_PUB.Close_Interaction( p_api_version => 1.0,
195: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
196: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
197: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
198: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
199: x_return_status => l_return_status,
200: x_msg_count => l_msg_count,
201: x_msg_data => l_msg_data,

Line 198: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

194: JTF_IH_PUB.Close_Interaction( p_api_version => 1.0,
195: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
196: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
197: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
198: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
199: x_return_status => l_return_status,
200: x_msg_count => l_msg_count,
201: x_msg_data => l_msg_data,
202: p_interaction_rec => l_interaction_rec);