APPS.CSI_ITEM_INSTANCE_VUHK dependencies on DBMS_SQL

Line 82: l_cursorid := DBMS_SQL.open_cursor;

78: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
79: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
80:
81: if (l_JTM_enable_prof_value = 'Y') then
82: l_cursorid := DBMS_SQL.open_cursor;
83: l_strBuffer :=
84: ' begin ' || 'JTM_ITEM_INSTANCE_VUHK' || '.' || 'CREATE_ITEM_INSTANCE_POST' ||
85: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
86: ' exception ' ||

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

86: ' exception ' ||
87: ' when others then ' ||
88: l_strLogBuffer ||
89: ' end; ';
90: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

87: ' when others then ' ||
88: l_strLogBuffer ||
89: ' end; ';
90: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);

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

88: l_strLogBuffer ||
89: ' end; ';
90: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

89: ' end; ';
90: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

90: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);

91: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
99:

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

92: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
99:
100: begin

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

93: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
99:
100: begin
101: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

94: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
95: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.instance_id);
96: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
99:
100: begin
101: l_execute_status := DBMS_SQL.execute (l_cursorid);
102: exception

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

97: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
98: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
99:
100: begin
101: l_execute_status := DBMS_SQL.execute (l_cursorid);
102: exception
103: when others then
104: EXECUTE IMMEDIATE l_strLogBuffer;
105: end;

Line 106: DBMS_SQL.close_cursor (l_cursorid);

102: exception
103: when others then
104: EXECUTE IMMEDIATE l_strLogBuffer;
105: end;
106: DBMS_SQL.close_cursor (l_cursorid);
107: end if;
108:
109: EXCEPTION
110: WHEN OTHERS THEN

Line 177: l_cursorid := DBMS_SQL.open_cursor;

173: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
174: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
175:
176: if (l_JTM_enable_prof_value = 'Y') then
177: l_cursorid := DBMS_SQL.open_cursor;
178: l_strBuffer :=
179: ' begin ' || 'JTM_ITEM_INSTANCE_VUHK' || '.' || 'UPDATE_ITEM_INSTANCE_PRE' ||
180: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
181: ' exception ' ||

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

181: ' exception ' ||
182: ' when others then ' ||
183: l_strLogBuffer ||
184: ' end; ';
185: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

182: ' when others then ' ||
183: l_strLogBuffer ||
184: ' end; ';
185: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);

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

183: l_strLogBuffer ||
184: ' end; ';
185: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

184: ' end; ';
185: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

185: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);

186: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
194:

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

187: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
194:
195: begin

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

188: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
194:
195: begin
196: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

189: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
190: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
191: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
194:
195: begin
196: l_execute_status := DBMS_SQL.execute (l_cursorid);
197: exception

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

192: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
193: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
194:
195: begin
196: l_execute_status := DBMS_SQL.execute (l_cursorid);
197: exception
198: when others then
199: EXECUTE IMMEDIATE l_strLogBuffer;
200: end;

Line 201: DBMS_SQL.close_cursor (l_cursorid);

197: exception
198: when others then
199: EXECUTE IMMEDIATE l_strLogBuffer;
200: end;
201: DBMS_SQL.close_cursor (l_cursorid);
202: end if;
203:
204: EXCEPTION
205: WHEN OTHERS THEN

Line 271: l_cursorid := DBMS_SQL.open_cursor;

267: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
268: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
269:
270: if (l_JTM_enable_prof_value = 'Y') then
271: l_cursorid := DBMS_SQL.open_cursor;
272: l_strBuffer :=
273: ' begin ' || 'JTM_ITEM_INSTANCE_VUHK' || '.' || 'UPDATE_ITEM_INSTANCE_POST' ||
274: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
275: ' exception ' ||

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

275: ' exception ' ||
276: ' when others then ' ||
277: l_strLogBuffer ||
278: ' end; ';
279: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

276: ' when others then ' ||
277: l_strLogBuffer ||
278: ' end; ';
279: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);

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

277: l_strLogBuffer ||
278: ' end; ';
279: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

278: ' end; ';
279: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

279: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);

280: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
288:

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

281: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
288:
289: begin

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

282: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
288:
289: begin
290: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

283: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
284: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_rec.INSTANCE_ID);
285: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
288:
289: begin
290: l_execute_status := DBMS_SQL.execute (l_cursorid);
291: exception

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

286: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
287: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
288:
289: begin
290: l_execute_status := DBMS_SQL.execute (l_cursorid);
291: exception
292: when others then
293: EXECUTE IMMEDIATE l_strLogBuffer;
294: end;

Line 295: DBMS_SQL.close_cursor (l_cursorid);

291: exception
292: when others then
293: EXECUTE IMMEDIATE l_strLogBuffer;
294: end;
295: DBMS_SQL.close_cursor (l_cursorid);
296: end if;
297:
298: EXCEPTION
299: WHEN OTHERS THEN