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 140: -- If Partner Usertype, call PRM API using dynamic sql, through dbms_sql

136:
137: /* Bug 7145499 : PRM team responded that no records to inactivate in their tables
138: on rejection
139:
140: -- If Partner Usertype, call PRM API using dynamic sql, through dbms_sql
141:
142: l_usertype_partner := getIsPartnerUser(l_userreg_id);
143: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);
144:

Line 147: DBMS_SQL.PARSE (cur,

143: IBE_UTIL.debug('l_usertype_partner=' || l_usertype_partner);
144:
145: If l_usertype_partner = FND_API.G_TRUE Then
146:
147: DBMS_SQL.PARSE (cur,
148: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);

Line 149: DBMS_SQL.NATIVE);

145: If l_usertype_partner = FND_API.G_TRUE Then
146:
147: DBMS_SQL.PARSE (cur,
148: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);

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

146:
147: DBMS_SQL.PARSE (cur,
148: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);

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

147: DBMS_SQL.PARSE (cur,
148: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);

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

148: 'BEGIN PRM_USER_PVT.INACTIVATEPARTNERUSER(:userid, :usertype, :appid, :partyid, :x_returnstatus, :x_msgcount, :x_msgdata); END;',
149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:

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

149: DBMS_SQL.NATIVE);
150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);

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

150: DBMS_SQL.BIND_VARIABLE (cur, 'usertype', l_usertype_key);
151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);

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

151: DBMS_SQL.BIND_VARIABLE (cur, 'appid', l_usertype_appId);
152: DBMS_SQL.BIND_VARIABLE (cur, 'partyid', l_party_id);
153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
159: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);

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

153: DBMS_SQL.BIND_VARIABLE (cur, 'x_returnstatus', x_prm_return_status);
154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
159: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
160: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
161:

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

154: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgcount', x_prm_msg_count);
155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
159: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
160: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
161:
162: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);

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

155: DBMS_SQL.BIND_VARIABLE (cur, 'x_msgdata', x_prm_msg_data);
156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
159: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
160: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
161:
162: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
163: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));

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

156:
157: fdbk := DBMS_SQL.EXECUTE (cur);
158: DBMS_SQL.VARIABLE_VALUE (cur, 'x_returnstatus', x_prm_return_status);
159: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgcount', x_prm_msg_count);
160: DBMS_SQL.VARIABLE_VALUE (cur, 'x_msgdata', x_prm_msg_data);
161:
162: IBE_UTIL.debug('x_prm_return_status ' || x_prm_return_status);
163: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
164: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);

Line 167: DBMS_SQL.CLOSE_CURSOR (cur);

163: IBE_UTIL.debug('x_prm_msg_count ' || to_char(x_prm_msg_count));
164: IBE_UTIL.debug('x_prm_msg_data ' || x_prm_msg_data);
165:
166: If x_prm_return_status = FND_API.G_FALSE Then
167: DBMS_SQL.CLOSE_CURSOR (cur);
168: IBE_UTIL.debug('Returning ERROR due to PRM');
169: WF_CORE.CONTEXT('IBE', 'postRejection',
170: p_event.getEventName(), p_subscription_guid);
171: WF_EVENT.setErrorInfo(p_event, 'ERROR due to PRM : x_prm_msg_data=' || x_prm_msg_data);

Line 177: DBMS_SQL.CLOSE_CURSOR (cur);

173: End If;
174:
175: End If;
176:
177: DBMS_SQL.CLOSE_CURSOR (cur);
178: */
179: End If;
180:
181: END IF;