5152: x_return_status := fnd_api.g_ret_sts_success;
5153:
5154: FOR i IN c1
5155: LOOP
5156: v_cursorid := DBMS_SQL.open_cursor;
5157: v_blockstr :=
5158: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
5159:
5160: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5168: l_module_name,
5169: 'i.hook_api = ' || i.hook_api);
5170: end if;
5171:
5172: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
5173: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5169: 'i.hook_api = ' || i.hook_api);
5170: end if;
5171:
5172: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
5173: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5170: end if;
5171:
5172: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
5173: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5171:
5172: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
5173: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5172: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
5173: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
5174: v_dummy := DBMS_SQL.execute (v_cursorid);
5175: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
5176: DBMS_SQL.close_cursor (v_cursorid);
5177:
5178: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5180: l_module_name,