eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_BUDGET_VALUES_PKG dependencies on DBMS_SQL

Line 137: l_dyn_curs := dbms_sql.open_cursor;

133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: -- if OTA is installed,
136: -- check if training measurement type record exists with multiple values
137: l_dyn_curs := dbms_sql.open_cursor;
138: --
139: -- Determine if the OTA_TP_MEASUREMENT_TYPES table exists
140: --
141: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);

Line 141: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);

137: l_dyn_curs := dbms_sql.open_cursor;
138: --
139: -- Determine if the OTA_TP_MEASUREMENT_TYPES table exists
140: --
141: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
142: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
143: --
144: if dbms_sql.last_row_count > 0 then
145: -- Check that the training measurement type record exists with multiple values

Line 142: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);

138: --
139: -- Determine if the OTA_TP_MEASUREMENT_TYPES table exists
140: --
141: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
142: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
143: --
144: if dbms_sql.last_row_count > 0 then
145: -- Check that the training measurement type record exists with multiple values
146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);

Line 144: if dbms_sql.last_row_count > 0 then

140: --
141: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
142: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
143: --
144: if dbms_sql.last_row_count > 0 then
145: -- Check that the training measurement type record exists with multiple values
146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --

Line 146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);

142: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
143: --
144: if dbms_sql.last_row_count > 0 then
145: -- Check that the training measurement type record exists with multiple values
146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --
149: if dbms_sql.last_row_count > 0 then
150: if dbms_sql.is_open(l_dyn_curs) then

Line 147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);

143: --
144: if dbms_sql.last_row_count > 0 then
145: -- Check that the training measurement type record exists with multiple values
146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --
149: if dbms_sql.last_row_count > 0 then
150: if dbms_sql.is_open(l_dyn_curs) then
151: dbms_sql.close_cursor(l_dyn_curs);

Line 149: if dbms_sql.last_row_count > 0 then

145: -- Check that the training measurement type record exists with multiple values
146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --
149: if dbms_sql.last_row_count > 0 then
150: if dbms_sql.is_open(l_dyn_curs) then
151: dbms_sql.close_cursor(l_dyn_curs);
152: end if;
153: RETURN TRUE;

Line 150: if dbms_sql.is_open(l_dyn_curs) then

146: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --
149: if dbms_sql.last_row_count > 0 then
150: if dbms_sql.is_open(l_dyn_curs) then
151: dbms_sql.close_cursor(l_dyn_curs);
152: end if;
153: RETURN TRUE;
154: end if;

Line 151: dbms_sql.close_cursor(l_dyn_curs);

147: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
148: --
149: if dbms_sql.last_row_count > 0 then
150: if dbms_sql.is_open(l_dyn_curs) then
151: dbms_sql.close_cursor(l_dyn_curs);
152: end if;
153: RETURN TRUE;
154: end if;
155: end if;

Line 156: if dbms_sql.is_open(l_dyn_curs) then

152: end if;
153: RETURN TRUE;
154: end if;
155: end if;
156: if dbms_sql.is_open(l_dyn_curs) then
157: dbms_sql.close_cursor(l_dyn_curs);
158: end if;
159: --
160: RETURN FALSE;

Line 157: dbms_sql.close_cursor(l_dyn_curs);

153: RETURN TRUE;
154: end if;
155: end if;
156: if dbms_sql.is_open(l_dyn_curs) then
157: dbms_sql.close_cursor(l_dyn_curs);
158: end if;
159: --
160: RETURN FALSE;
161: