APPS.CS_COUNTERS_VUHK dependencies on DBMS_SQL

Line 104: l_cursorid := DBMS_SQL.open_cursor;

100: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
101: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
102:
103: if (l_JTM_enable_prof_value = 'Y') then
104: l_cursorid := DBMS_SQL.open_cursor;
105: l_strBuffer :=
106: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'CREATE_CTR_GRP_INSTANCE_POST' ||
107: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
108: ' exception ' ||

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

108: ' exception ' ||
109: ' when others then ' ||
110: l_strLogBuffer ||
111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

109: ' when others then ' ||
110: l_strLogBuffer ||
111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

110: l_strLogBuffer ||
111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);

Line 116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);

Line 117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

113: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );

Line 118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);

115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
123:

Line 120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);

116: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
123:
124: begin

Line 121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );

117: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

118: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
119: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
120: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);
126: exception

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

121: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);
126: exception
127: when others then
128: EXECUTE IMMEDIATE l_strLogBuffer;
129: end;

Line 130: DBMS_SQL.close_cursor (l_cursorid);

126: exception
127: when others then
128: EXECUTE IMMEDIATE l_strLogBuffer;
129: end;
130: DBMS_SQL.close_cursor (l_cursorid);
131:
132: end if;
133: EXCEPTION
134: WHEN OTHERS THEN

Line 208: l_cursorid := DBMS_SQL.open_cursor;

204: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
205: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
206:
207: if (l_JTM_enable_prof_value = 'Y') then
208: l_cursorid := DBMS_SQL.open_cursor;
209: l_strBuffer :=
210: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'CREATE_COUNTER_POST' ||
211: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
212: ' exception ' ||

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

212: ' exception ' ||
213: ' when others then ' ||
214: l_strLogBuffer ||
215: ' end; ';
216: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

213: ' when others then ' ||
214: l_strLogBuffer ||
215: ' end; ';
216: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

214: l_strLogBuffer ||
215: ' end; ';
216: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

215: ' end; ';
216: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );

Line 220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

216: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

Line 221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

217: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
225:

Line 222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

218: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
225:
226: begin

Line 223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );

219: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
225:
226: begin
227: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

220: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
221: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
222: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
225:
226: begin
227: l_execute_status := DBMS_SQL.execute (l_cursorid);
228: exception

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

223: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
224: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
225:
226: begin
227: l_execute_status := DBMS_SQL.execute (l_cursorid);
228: exception
229: when others then
230: EXECUTE IMMEDIATE l_strLogBuffer;
231: end;

Line 232: DBMS_SQL.close_cursor (l_cursorid);

228: exception
229: when others then
230: EXECUTE IMMEDIATE l_strLogBuffer;
231: end;
232: DBMS_SQL.close_cursor (l_cursorid);
233:
234: end if;
235: EXCEPTION
236: WHEN OTHERS THEN

Line 309: l_cursorid := DBMS_SQL.open_cursor;

305: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
306: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
307:
308: if (l_JTM_enable_prof_value = 'Y') then
309: l_cursorid := DBMS_SQL.open_cursor;
310: l_strBuffer :=
311: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'CREATE_CTR_PROP_POST' ||
312: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
313: ' exception ' ||

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

313: ' exception ' ||
314: ' when others then ' ||
315: l_strLogBuffer ||
316: ' end; ';
317: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

314: ' when others then ' ||
315: l_strLogBuffer ||
316: ' end; ';
317: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

315: l_strLogBuffer ||
316: ' end; ';
317: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

316: ' end; ';
317: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );

Line 321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

317: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

Line 322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

318: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
326:

Line 323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

319: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
326:
327: begin

Line 324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );

320: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
326:
327: begin
328: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

321: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
322: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
323: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
326:
327: begin
328: l_execute_status := DBMS_SQL.execute (l_cursorid);
329: exception

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

324: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
325: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
326:
327: begin
328: l_execute_status := DBMS_SQL.execute (l_cursorid);
329: exception
330: when others then
331: EXECUTE IMMEDIATE l_strLogBuffer;
332: end;

Line 333: DBMS_SQL.close_cursor (l_cursorid);

329: exception
330: when others then
331: EXECUTE IMMEDIATE l_strLogBuffer;
332: end;
333: DBMS_SQL.close_cursor (l_cursorid);
334:
335: end if;
336: EXCEPTION
337: WHEN OTHERS THEN

Line 567: l_cursorid := DBMS_SQL.open_cursor;

563: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
564: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
565:
566: if (l_JTM_enable_prof_value = 'Y') then
567: l_cursorid := DBMS_SQL.open_cursor;
568: l_strBuffer :=
569: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'INSTANTIATE_COUNTERS_POST' ||
570: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11); ' ||
571: ' exception ' ||

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

571: ' exception ' ||
572: ' when others then ' ||
573: l_strLogBuffer ||
574: ' end; ';
575: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

572: ' when others then ' ||
573: l_strLogBuffer ||
574: ' end; ';
575: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

573: l_strLogBuffer ||
574: ' end; ';
575: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

574: ' end; ';
575: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );

Line 579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

575: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);

Line 580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

576: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);

Line 581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

577: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);

Line 582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );

578: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);

Line 583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);

579: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
587:

Line 584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);

580: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
587:
588: begin

Line 585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);

581: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
587:
588: begin
589: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);

582: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
583: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
584: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
587:
588: begin
589: l_execute_status := DBMS_SQL.execute (l_cursorid);
590: exception

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

585: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
586: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
587:
588: begin
589: l_execute_status := DBMS_SQL.execute (l_cursorid);
590: exception
591: when others then
592: EXECUTE IMMEDIATE l_strLogBuffer;
593: end;

Line 594: DBMS_SQL.close_cursor (l_cursorid);

590: exception
591: when others then
592: EXECUTE IMMEDIATE l_strLogBuffer;
593: end;
594: DBMS_SQL.close_cursor (l_cursorid);
595:
596: end if;
597: EXCEPTION
598: WHEN OTHERS THEN

Line 657: l_cursorid := DBMS_SQL.open_cursor;

653: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
654: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
655:
656: if (l_JTM_enable_prof_value = 'Y') then
657: l_cursorid := DBMS_SQL.open_cursor;
658: l_strBuffer :=
659: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_GRP_PRE' ||
660: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
661: ' exception ' ||

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

661: ' exception ' ||
662: ' when others then ' ||
663: l_strLogBuffer ||
664: ' end; ';
665: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

662: ' when others then ' ||
663: l_strLogBuffer ||
664: ' end; ';
665: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

663: l_strLogBuffer ||
664: ' end; ';
665: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

664: ' end; ';
665: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

Line 669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

665: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

666: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

667: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

668: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
676:

Line 673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

669: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
676:
677: begin

Line 674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

670: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
676:
677: begin
678: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

671: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
672: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
673: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
676:
677: begin
678: l_execute_status := DBMS_SQL.execute (l_cursorid);
679: exception

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

674: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
675: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
676:
677: begin
678: l_execute_status := DBMS_SQL.execute (l_cursorid);
679: exception
680: when others then
681: EXECUTE IMMEDIATE l_strLogBuffer;
682: end;

Line 683: DBMS_SQL.close_cursor (l_cursorid);

679: exception
680: when others then
681: EXECUTE IMMEDIATE l_strLogBuffer;
682: end;
683: DBMS_SQL.close_cursor (l_cursorid);
684:
685: end if;
686: EXCEPTION
687: WHEN OTHERS THEN

Line 746: l_cursorid := DBMS_SQL.open_cursor;

742: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
743: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
744:
745: if (l_JTM_enable_prof_value = 'Y') then
746: l_cursorid := DBMS_SQL.open_cursor;
747: l_strBuffer :=
748: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_GRP_POST' ||
749: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
750: ' exception ' ||

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

750: ' exception ' ||
751: ' when others then ' ||
752: l_strLogBuffer ||
753: ' end; ';
754: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

751: ' when others then ' ||
752: l_strLogBuffer ||
753: ' end; ';
754: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

752: l_strLogBuffer ||
753: ' end; ';
754: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

753: ' end; ';
754: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

Line 758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

754: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

755: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

756: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

757: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
765:

Line 762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

758: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
765:
766: begin

Line 763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

759: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
765:
766: begin
767: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

760: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
761: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
762: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
765:
766: begin
767: l_execute_status := DBMS_SQL.execute (l_cursorid);
768: exception

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

763: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
764: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
765:
766: begin
767: l_execute_status := DBMS_SQL.execute (l_cursorid);
768: exception
769: when others then
770: EXECUTE IMMEDIATE l_strLogBuffer;
771: end;

Line 772: DBMS_SQL.close_cursor (l_cursorid);

768: exception
769: when others then
770: EXECUTE IMMEDIATE l_strLogBuffer;
771: end;
772: DBMS_SQL.close_cursor (l_cursorid);
773:
774: end if;
775: EXCEPTION
776: WHEN OTHERS THEN

Line 835: l_cursorid := DBMS_SQL.open_cursor;

831: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
832: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
833:
834: if (l_JTM_enable_prof_value = 'Y') then
835: l_cursorid := DBMS_SQL.open_cursor;
836: l_strBuffer :=
837: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_COUNTER_PRE' ||
838: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
839: ' exception ' ||

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

839: ' exception ' ||
840: ' when others then ' ||
841: l_strLogBuffer ||
842: ' end; ';
843: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

840: ' when others then ' ||
841: l_strLogBuffer ||
842: ' end; ';
843: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

841: l_strLogBuffer ||
842: ' end; ';
843: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

842: ' end; ';
843: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

843: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

844: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

845: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

846: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
854:

Line 851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

847: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
854:
855: begin

Line 852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

848: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
854:
855: begin
856: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

849: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
850: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
851: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
854:
855: begin
856: l_execute_status := DBMS_SQL.execute (l_cursorid);
857: exception

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

852: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
853: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
854:
855: begin
856: l_execute_status := DBMS_SQL.execute (l_cursorid);
857: exception
858: when others then
859: EXECUTE IMMEDIATE l_strLogBuffer;
860: end;

Line 861: DBMS_SQL.close_cursor (l_cursorid);

857: exception
858: when others then
859: EXECUTE IMMEDIATE l_strLogBuffer;
860: end;
861: DBMS_SQL.close_cursor (l_cursorid);
862:
863: end if;
864: EXCEPTION
865: WHEN OTHERS THEN

Line 924: l_cursorid := DBMS_SQL.open_cursor;

920: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
921: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
922:
923: if (l_JTM_enable_prof_value = 'Y') then
924: l_cursorid := DBMS_SQL.open_cursor;
925: l_strBuffer :=
926: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_COUNTER_POST' ||
927: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
928: ' exception ' ||

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

928: ' exception ' ||
929: ' when others then ' ||
930: l_strLogBuffer ||
931: ' end; ';
932: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

929: ' when others then ' ||
930: l_strLogBuffer ||
931: ' end; ';
932: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

930: l_strLogBuffer ||
931: ' end; ';
932: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

931: ' end; ';
932: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

932: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

933: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

934: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

935: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
943:

Line 940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

936: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
943:
944: begin

Line 941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

937: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
943:
944: begin
945: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

938: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
939: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
940: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
943:
944: begin
945: l_execute_status := DBMS_SQL.execute (l_cursorid);
946: exception

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

941: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
942: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
943:
944: begin
945: l_execute_status := DBMS_SQL.execute (l_cursorid);
946: exception
947: when others then
948: EXECUTE IMMEDIATE l_strLogBuffer;
949: end;

Line 950: DBMS_SQL.close_cursor (l_cursorid);

946: exception
947: when others then
948: EXECUTE IMMEDIATE l_strLogBuffer;
949: end;
950: DBMS_SQL.close_cursor (l_cursorid);
951:
952: end if;
953: EXCEPTION
954: WHEN OTHERS THEN

Line 1014: l_cursorid := DBMS_SQL.open_cursor;

1010: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
1011: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
1012:
1013: if (l_JTM_enable_prof_value = 'Y') then
1014: l_cursorid := DBMS_SQL.open_cursor;
1015: l_strBuffer :=
1016: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_PROP_PRE' ||
1017: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
1018: ' exception ' ||

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

1018: ' exception ' ||
1019: ' when others then ' ||
1020: l_strLogBuffer ||
1021: ' end; ';
1022: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

1019: ' when others then ' ||
1020: l_strLogBuffer ||
1021: ' end; ';
1022: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

1020: l_strLogBuffer ||
1021: ' end; ';
1022: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

1021: ' end; ';
1022: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

1022: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

1023: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

1024: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

1025: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1033:

Line 1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

1026: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1033:
1034: begin

Line 1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

1027: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1033:
1034: begin
1035: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

1028: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1029: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1030: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1033:
1034: begin
1035: l_execute_status := DBMS_SQL.execute (l_cursorid);
1036: exception

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

1031: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1032: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1033:
1034: begin
1035: l_execute_status := DBMS_SQL.execute (l_cursorid);
1036: exception
1037: when others then
1038: EXECUTE IMMEDIATE l_strLogBuffer;
1039: end;

Line 1040: DBMS_SQL.close_cursor (l_cursorid);

1036: exception
1037: when others then
1038: EXECUTE IMMEDIATE l_strLogBuffer;
1039: end;
1040: DBMS_SQL.close_cursor (l_cursorid);
1041:
1042: end if;
1043: EXCEPTION
1044: WHEN OTHERS THEN

Line 1103: l_cursorid := DBMS_SQL.open_cursor;

1099: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
1100: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
1101:
1102: if (l_JTM_enable_prof_value = 'Y') then
1103: l_cursorid := DBMS_SQL.open_cursor;
1104: l_strBuffer :=
1105: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_PROP_POST' ||
1106: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
1107: ' exception ' ||

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

1107: ' exception ' ||
1108: ' when others then ' ||
1109: l_strLogBuffer ||
1110: ' end; ';
1111: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

1108: ' when others then ' ||
1109: l_strLogBuffer ||
1110: ' end; ';
1111: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

1109: l_strLogBuffer ||
1110: ' end; ';
1111: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

1110: ' end; ';
1111: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

1111: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

1112: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

1113: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

1114: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1122:

Line 1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

1115: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1122:
1123: begin

Line 1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

1116: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1122:
1123: begin
1124: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

1117: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1118: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1119: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1122:
1123: begin
1124: l_execute_status := DBMS_SQL.execute (l_cursorid);
1125: exception

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

1120: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
1121: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
1122:
1123: begin
1124: l_execute_status := DBMS_SQL.execute (l_cursorid);
1125: exception
1126: when others then
1127: EXECUTE IMMEDIATE l_strLogBuffer;
1128: end;

Line 1129: DBMS_SQL.close_cursor (l_cursorid);

1125: exception
1126: when others then
1127: EXECUTE IMMEDIATE l_strLogBuffer;
1128: end;
1129: DBMS_SQL.close_cursor (l_cursorid);
1130:
1131: end if;
1132: EXCEPTION
1133: WHEN OTHERS THEN

Line 1318: l_cursorid := DBMS_SQL.open_cursor;

1314: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
1315: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
1316:
1317: if (l_JTM_enable_prof_value = 'Y') then
1318: l_cursorid := DBMS_SQL.open_cursor;
1319: l_strBuffer :=
1320: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'DELETE_COUNTER_PRE' ||
1321: '(:1,:2,:3,:4,:5,:6,:7); ' ||
1322: ' exception ' ||

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

1322: ' exception ' ||
1323: ' when others then ' ||
1324: l_strLogBuffer ||
1325: ' end; ';
1326: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

1323: ' when others then ' ||
1324: l_strLogBuffer ||
1325: ' end; ';
1326: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

1324: l_strLogBuffer ||
1325: ' end; ';
1326: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

1325: ' end; ';
1326: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

1326: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
1334:

Line 1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

1327: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
1334:
1335: begin

Line 1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

1328: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
1334:
1335: begin
1336: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

1329: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1330: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1331: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
1334:
1335: begin
1336: l_execute_status := DBMS_SQL.execute (l_cursorid);
1337: exception

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

1332: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1333: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
1334:
1335: begin
1336: l_execute_status := DBMS_SQL.execute (l_cursorid);
1337: exception
1338: when others then
1339: EXECUTE IMMEDIATE l_strLogBuffer;
1340: end;

Line 1341: DBMS_SQL.close_cursor (l_cursorid);

1337: exception
1338: when others then
1339: EXECUTE IMMEDIATE l_strLogBuffer;
1340: end;
1341: DBMS_SQL.close_cursor (l_cursorid);
1342:
1343: end if;
1344: EXCEPTION
1345: WHEN OTHERS THEN

Line 1415: l_cursorid := DBMS_SQL.open_cursor;

1411: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
1412: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
1413:
1414: if (l_JTM_enable_prof_value = 'Y') then
1415: l_cursorid := DBMS_SQL.open_cursor;
1416: l_strBuffer :=
1417: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'DELETE_CTR_PROP_PRE' ||
1418: '(:1,:2,:3,:4,:5,:6,:7); ' ||
1419: ' exception ' ||

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

1419: ' exception ' ||
1420: ' when others then ' ||
1421: l_strLogBuffer ||
1422: ' end; ';
1423: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

Line 1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

1420: ' when others then ' ||
1421: l_strLogBuffer ||
1422: ' end; ';
1423: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

Line 1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

1421: l_strLogBuffer ||
1422: ' end; ';
1423: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

Line 1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

1422: ' end; ';
1423: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

1423: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1431:

Line 1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

1424: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1431:
1432: begin

Line 1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

1425: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1431:
1432: begin
1433: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

1426: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1427: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
1428: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1431:
1432: begin
1433: l_execute_status := DBMS_SQL.execute (l_cursorid);
1434: exception

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

1429: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
1430: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
1431:
1432: begin
1433: l_execute_status := DBMS_SQL.execute (l_cursorid);
1434: exception
1435: when others then
1436: EXECUTE IMMEDIATE l_strLogBuffer;
1437: end;

Line 1438: DBMS_SQL.close_cursor (l_cursorid);

1434: exception
1435: when others then
1436: EXECUTE IMMEDIATE l_strLogBuffer;
1437: end;
1438: DBMS_SQL.close_cursor (l_cursorid);
1439:
1440: end if;
1441: EXCEPTION
1442: WHEN OTHERS THEN

Line 1596: l_cursorid := DBMS_SQL.open_cursor;

1592: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
1593: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
1594:
1595: if (l_JTM_enable_prof_value = 'Y') then
1596: l_cursorid := DBMS_SQL.open_cursor;
1597: l_strBuffer :=
1598: ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'DELETE_COUNTER_INSTANCE_PREE' ||
1599: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
1600: ' exception ' ||

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

1600: ' exception ' ||
1601: ' when others then ' ||
1602: l_strLogBuffer ||
1603: ' end; ';
1604: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );

Line 1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

1601: ' when others then ' ||
1602: l_strLogBuffer ||
1603: ' end; ';
1604: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );

Line 1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

1602: l_strLogBuffer ||
1603: ' end; ';
1604: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

Line 1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

1603: ' end; ';
1604: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );

1604: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );

1605: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
1613:

Line 1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

1606: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
1613:
1614: begin

Line 1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

1607: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
1613:
1614: begin
1615: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

1608: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
1609: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
1610: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
1613:
1614: begin
1615: l_execute_status := DBMS_SQL.execute (l_cursorid);
1616: exception

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

1611: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
1612: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
1613:
1614: begin
1615: l_execute_status := DBMS_SQL.execute (l_cursorid);
1616: exception
1617: when others then
1618: EXECUTE IMMEDIATE l_strLogBuffer;
1619: end;

Line 1620: DBMS_SQL.close_cursor (l_cursorid);

1616: exception
1617: when others then
1618: EXECUTE IMMEDIATE l_strLogBuffer;
1619: end;
1620: DBMS_SQL.close_cursor (l_cursorid);
1621:
1622: end if;
1623: EXCEPTION
1624: WHEN OTHERS THEN