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

Line 64: l_cursorid := DBMS_SQL.open_cursor;

60: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
61: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
62:
63: if (l_JTM_enable_prof_value = 'Y') then
64: l_cursorid := DBMS_SQL.open_cursor;
65: l_strBuffer :=
66: ' begin ' || 'JTM_RS_GROUP_MEMBER_VUHK' || '.' || 'create_group_members_post' ||
67: '(:1,:2,:3,:4); ' ||
68: ' exception ' ||

Line 72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

68: ' exception ' ||
69: ' when others then ' ||
70: l_strLogBuffer ||
71: ' end; ';
72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);

Line 73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);

69: ' when others then ' ||
70: l_strLogBuffer ||
71: ' end; ';
72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
77: begin

Line 74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);

70: l_strLogBuffer ||
71: ' end; ';
72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
77: begin
78: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);

71: ' end; ';
72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
77: begin
78: l_execute_status := DBMS_SQL.execute (l_cursorid);
79: exception

Line 76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);

72: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
73: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
77: begin
78: l_execute_status := DBMS_SQL.execute (l_cursorid);
79: exception
80: when others then

Line 78: l_execute_status := DBMS_SQL.execute (l_cursorid);

74: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
75: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
76: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
77: begin
78: l_execute_status := DBMS_SQL.execute (l_cursorid);
79: exception
80: when others then
81: EXECUTE IMMEDIATE l_strLogBuffer;
82: end;

Line 83: DBMS_SQL.close_cursor (l_cursorid);

79: exception
80: when others then
81: EXECUTE IMMEDIATE l_strLogBuffer;
82: end;
83: DBMS_SQL.close_cursor (l_cursorid);
84: end if;
85:
86: EXCEPTION
87: WHEN OTHERS THEN

Line 165: l_cursorid := DBMS_SQL.open_cursor;

161: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
162: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
163:
164: if (l_JTM_enable_prof_value = 'Y') then
165: l_cursorid := DBMS_SQL.open_cursor;
166: l_strBuffer :=
167: ' begin ' || 'JTM_RS_GROUP_MEMBER_VUHK' || '.' || 'delete_group_members_pre' ||
168: '(:1,:2,:3); ' ||
169: ' exception ' ||

Line 173: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

169: ' exception ' ||
170: ' when others then ' ||
171: l_strLogBuffer ||
172: ' end; ';
173: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
177: begin

Line 174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);

170: ' when others then ' ||
171: l_strLogBuffer ||
172: ' end; ';
173: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
177: begin
178: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);

171: l_strLogBuffer ||
172: ' end; ';
173: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
177: begin
178: l_execute_status := DBMS_SQL.execute (l_cursorid);
179: exception

Line 176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);

172: ' end; ';
173: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
177: begin
178: l_execute_status := DBMS_SQL.execute (l_cursorid);
179: exception
180: when others then

Line 178: l_execute_status := DBMS_SQL.execute (l_cursorid);

174: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
175: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
176: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
177: begin
178: l_execute_status := DBMS_SQL.execute (l_cursorid);
179: exception
180: when others then
181: EXECUTE IMMEDIATE l_strLogBuffer;
182: end;

Line 183: DBMS_SQL.close_cursor (l_cursorid);

179: exception
180: when others then
181: EXECUTE IMMEDIATE l_strLogBuffer;
182: end;
183: DBMS_SQL.close_cursor (l_cursorid);
184: end if;
185:
186: EXCEPTION
187: WHEN OTHERS THEN