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.IBE_JTA_INTEGRATION_GRP dependencies on DBMS_SQL

Line 41: cur BINARY_INTEGER := DBMS_SQL.OPEN_CURSOR;

37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(240);
39: l_usertype_partner VARCHAR2(240);
40:
41: cur BINARY_INTEGER := DBMS_SQL.OPEN_CURSOR;
42: fdbk BINARY_INTEGER;
43: x_prm_return_status VARCHAR2(40);
44: x_prm_msg_count NUMBER;
45: x_prm_msg_data VARCHAR2(40);

Line 152: -- If Partner Usertype, call PRM API using dynamic sql, through dbms_sql

148:
149: /* Bug 7145499 : PRM team responded that no records to inactivate in their tables
150: on rejection
151:
152: -- If Partner Usertype, call PRM API using dynamic sql, through dbms_sql
153:
154: l_usertype_partner := getIsPartnerUser(l_userreg_id);
155: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);
156:

Line 159: DBMS_SQL.PARSE (cur,

155: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);
156:
157: If l_usertype_partner = FND_API.G_TRUE Then
158:
159: DBMS_SQL.PARSE (cur,
160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);

Line 161: DBMS_SQL.NATIVE);

157: If l_usertype_partner = FND_API.G_TRUE Then
158:
159: DBMS_SQL.PARSE (cur,
160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);

Line 162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);

158:
159: DBMS_SQL.PARSE (cur,
160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);

Line 163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);

159: DBMS_SQL.PARSE (cur,
160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);

Line 164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);

160: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:

Line 165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);

161: DBMS_SQL.NATIVE);
162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);

Line 166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);

162: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);

Line 167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);

163: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
164: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);

Line 169: fdbk := DBMS_SQL.EXECUTE (cur);

165: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:

Line 170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);

166: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);

Line 171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);

167: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));

Line 172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);

168:
169: fdbk := DBMS_SQL.EXECUTE (cur);
170: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
171: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
172: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
173:
174: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);

Line 179: DBMS_SQL.CLOSE_CURSOR (cur);

175: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
176: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
177:
178: If x_prm_return_status = FND_API.G_FALSE Then
179: DBMS_SQL.CLOSE_CURSOR (cur);
180: IBE_UTIL.debug('Returning ERROR due to PRM');
181: WF_CORE.CONTEXT('IBE', 'postRejection',
182: p_event.getEventName(), p_subscription_guid);
183: WF_EVENT.setErrorInfo(p_event, 'ERROR due to PRM : x_prm_msg_data=' || x_prm_msg_data);

Line 189: DBMS_SQL.CLOSE_CURSOR (cur);

185: End If;
186:
187: End If;
188:
189: DBMS_SQL.CLOSE_CURSOR (cur);
190: */
191: End If;
192:
193: END IF;