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

Line 3964: cursornum := dbms_sql.open_cursor;

3960: sqlstr := sqlstr || ' else :r := ''N''; end if; END;';
3961: IF (fnd_flex_server1.g_debug_level > 0) THEN
3962: FND_FLEX_SERVER1.add_debug(sqlstr);
3963: END IF;
3964: cursornum := dbms_sql.open_cursor;
3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);

Line 3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);

3961: IF (fnd_flex_server1.g_debug_level > 0) THEN
3962: FND_FLEX_SERVER1.add_debug(sqlstr);
3963: END IF;
3964: cursornum := dbms_sql.open_cursor;
3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);
3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);

Line 3966: dbms_sql.bind_variable(cursornum, ':n', ccid);

3962: FND_FLEX_SERVER1.add_debug(sqlstr);
3963: END IF;
3964: cursornum := dbms_sql.open_cursor;
3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);
3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);
3970: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);

3963: END IF;
3964: cursornum := dbms_sql.open_cursor;
3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);
3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);
3970: IF (fnd_flex_server1.g_debug_level > 0) THEN
3971: FND_FLEX_SERVER1.add_debug('Dynamic SQL called FDFGLI and returned '||

Line 3968: nprocessed := dbms_sql.execute(cursornum);

3964: cursornum := dbms_sql.open_cursor;
3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);
3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);
3970: IF (fnd_flex_server1.g_debug_level > 0) THEN
3971: FND_FLEX_SERVER1.add_debug('Dynamic SQL called FDFGLI and returned '||
3972: yes_or_no || '. ');

Line 3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);

3965: dbms_sql.parse(cursornum, sqlstr, dbms_sql.v7);
3966: dbms_sql.bind_variable(cursornum, ':n', ccid);
3967: dbms_sql.bind_variable(cursornum, ':r', yes_or_no, 1);
3968: nprocessed := dbms_sql.execute(cursornum);
3969: dbms_sql.variable_value(cursornum, ':r', yes_or_no);
3970: IF (fnd_flex_server1.g_debug_level > 0) THEN
3971: FND_FLEX_SERVER1.add_debug('Dynamic SQL called FDFGLI and returned '||
3972: yes_or_no || '. ');
3973: END IF;

Line 3974: dbms_sql.close_cursor(cursornum);

3970: IF (fnd_flex_server1.g_debug_level > 0) THEN
3971: FND_FLEX_SERVER1.add_debug('Dynamic SQL called FDFGLI and returned '||
3972: yes_or_no || '. ');
3973: END IF;
3974: dbms_sql.close_cursor(cursornum);
3975: return(yes_or_no = 'Y');
3976: end if;
3977:
3978: return(TRUE);

Line 3983: if dbms_sql.is_open(cursornum) then

3979:
3980: EXCEPTION
3981: WHEN OTHERS then
3982: -- bug#4072642 -- maximum open cursors exceeded
3983: if dbms_sql.is_open(cursornum) then
3984: dbms_sql.close_cursor(cursornum);
3985: end if;
3986: if((SQLCODE = -6550) and (INSTR(SQLERRM, 'PLS-00201') > 0)) then
3987: FND_MESSAGE.set_name('FND', 'FLEX-FDFGLI MISSING');

Line 3984: dbms_sql.close_cursor(cursornum);

3980: EXCEPTION
3981: WHEN OTHERS then
3982: -- bug#4072642 -- maximum open cursors exceeded
3983: if dbms_sql.is_open(cursornum) then
3984: dbms_sql.close_cursor(cursornum);
3985: end if;
3986: if((SQLCODE = -6550) and (INSTR(SQLERRM, 'PLS-00201') > 0)) then
3987: FND_MESSAGE.set_name('FND', 'FLEX-FDFGLI MISSING');
3988: FND_MESSAGE.set_token('MSG', SQLERRM);

Line 4277: l_cursor := dbms_sql.open_cursor;

4273: --
4274: -- Check if the combination is already in the table.
4275: --
4276: BEGIN
4277: l_cursor := dbms_sql.open_cursor;
4278: dbms_sql.parse(l_cursor, p_select_sql, dbms_sql.native);
4279: FOR i IN 1..l_bind_count LOOP
4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));
4281: END LOOP;

Line 4278: dbms_sql.parse(l_cursor, p_select_sql, dbms_sql.native);

4274: -- Check if the combination is already in the table.
4275: --
4276: BEGIN
4277: l_cursor := dbms_sql.open_cursor;
4278: dbms_sql.parse(l_cursor, p_select_sql, dbms_sql.native);
4279: FOR i IN 1..l_bind_count LOOP
4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));
4281: END LOOP;
4282: dbms_sql.define_column(l_cursor, 1, l_ccid);

Line 4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));

4276: BEGIN
4277: l_cursor := dbms_sql.open_cursor;
4278: dbms_sql.parse(l_cursor, p_select_sql, dbms_sql.native);
4279: FOR i IN 1..l_bind_count LOOP
4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));
4281: END LOOP;
4282: dbms_sql.define_column(l_cursor, 1, l_ccid);
4283: l_num := dbms_sql.execute_and_fetch(l_cursor, TRUE);
4284:

Line 4282: dbms_sql.define_column(l_cursor, 1, l_ccid);

4278: dbms_sql.parse(l_cursor, p_select_sql, dbms_sql.native);
4279: FOR i IN 1..l_bind_count LOOP
4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));
4281: END LOOP;
4282: dbms_sql.define_column(l_cursor, 1, l_ccid);
4283: l_num := dbms_sql.execute_and_fetch(l_cursor, TRUE);
4284:
4285: --
4286: -- Combination already exists.

Line 4283: l_num := dbms_sql.execute_and_fetch(l_cursor, TRUE);

4279: FOR i IN 1..l_bind_count LOOP
4280: dbms_sql.bind_variable(l_cursor, 'S' || i , l_binds(i));
4281: END LOOP;
4282: dbms_sql.define_column(l_cursor, 1, l_ccid);
4283: l_num := dbms_sql.execute_and_fetch(l_cursor, TRUE);
4284:
4285: --
4286: -- Combination already exists.
4287: --

Line 4288: dbms_sql.column_value(l_cursor, 1, l_ccid);

4284:
4285: --
4286: -- Combination already exists.
4287: --
4288: dbms_sql.column_value(l_cursor, 1, l_ccid);
4289: dbms_sql.close_cursor(l_cursor);
4290: x_is_new := 'N';
4291: GOTO return_success;
4292: EXCEPTION

Line 4289: dbms_sql.close_cursor(l_cursor);

4285: --
4286: -- Combination already exists.
4287: --
4288: dbms_sql.column_value(l_cursor, 1, l_ccid);
4289: dbms_sql.close_cursor(l_cursor);
4290: x_is_new := 'N';
4291: GOTO return_success;
4292: EXCEPTION
4293: WHEN no_data_found THEN

Line 4297: dbms_sql.close_cursor(l_cursor);

4293: WHEN no_data_found THEN
4294: --
4295: -- Combination doesn't exist, continue to INSERT.
4296: --
4297: dbms_sql.close_cursor(l_cursor);
4298: WHEN OTHERS THEN
4299: dbms_sql.close_cursor(l_cursor);
4300: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4301: fnd_message.set_token('MSG', l_func_name ||

Line 4299: dbms_sql.close_cursor(l_cursor);

4295: -- Combination doesn't exist, continue to INSERT.
4296: --
4297: dbms_sql.close_cursor(l_cursor);
4298: WHEN OTHERS THEN
4299: dbms_sql.close_cursor(l_cursor);
4300: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4301: fnd_message.set_token('MSG', l_func_name ||
4302: ' is unable to select from table ' ||
4303: p_application_table_name || '. ' || l_newline ||

Line 4368: l_cursor := dbms_sql.open_cursor;

4364: --
4365: -- INSERT the combination.
4366: --
4367: BEGIN
4368: l_cursor := dbms_sql.open_cursor;
4369: dbms_sql.parse(l_cursor, p_insert_sql, dbms_sql.native);
4370:
4371: --
4372: -- First bind is the CCID.

Line 4369: dbms_sql.parse(l_cursor, p_insert_sql, dbms_sql.native);

4365: -- INSERT the combination.
4366: --
4367: BEGIN
4368: l_cursor := dbms_sql.open_cursor;
4369: dbms_sql.parse(l_cursor, p_insert_sql, dbms_sql.native);
4370:
4371: --
4372: -- First bind is the CCID.
4373: --

Line 4374: dbms_sql.bind_variable(l_cursor, 'CCID', l_ccid);

4370:
4371: --
4372: -- First bind is the CCID.
4373: --
4374: dbms_sql.bind_variable(l_cursor, 'CCID', l_ccid);
4375:
4376: --
4377: -- Bind Start and End Dates.
4378: --

Line 4379: dbms_sql.bind_variable(l_cursor, 'START_DATE_ACTIVE', p_start_date_active);

4375:
4376: --
4377: -- Bind Start and End Dates.
4378: --
4379: dbms_sql.bind_variable(l_cursor, 'START_DATE_ACTIVE', p_start_date_active);
4380: dbms_sql.bind_variable(l_cursor, 'END_DATE_ACTIVE', p_end_date_active);
4381:
4382: --
4383: -- Bind the rest.

Line 4380: dbms_sql.bind_variable(l_cursor, 'END_DATE_ACTIVE', p_end_date_active);

4376: --
4377: -- Bind Start and End Dates.
4378: --
4379: dbms_sql.bind_variable(l_cursor, 'START_DATE_ACTIVE', p_start_date_active);
4380: dbms_sql.bind_variable(l_cursor, 'END_DATE_ACTIVE', p_end_date_active);
4381:
4382: --
4383: -- Bind the rest.
4384: --

Line 4386: dbms_sql.bind_variable(l_cursor, 'I' || i, l_binds(i));

4382: --
4383: -- Bind the rest.
4384: --
4385: FOR i IN 1..l_bind_count LOOP
4386: dbms_sql.bind_variable(l_cursor, 'I' || i, l_binds(i));
4387: END LOOP;
4388: l_num := dbms_sql.execute(l_cursor);
4389: dbms_sql.close_cursor(l_cursor);
4390: IF (l_num <> 1) THEN

Line 4388: l_num := dbms_sql.execute(l_cursor);

4384: --
4385: FOR i IN 1..l_bind_count LOOP
4386: dbms_sql.bind_variable(l_cursor, 'I' || i, l_binds(i));
4387: END LOOP;
4388: l_num := dbms_sql.execute(l_cursor);
4389: dbms_sql.close_cursor(l_cursor);
4390: IF (l_num <> 1) THEN
4391: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4392: fnd_message.set_token('MSG', l_func_name ||

Line 4389: dbms_sql.close_cursor(l_cursor);

4385: FOR i IN 1..l_bind_count LOOP
4386: dbms_sql.bind_variable(l_cursor, 'I' || i, l_binds(i));
4387: END LOOP;
4388: l_num := dbms_sql.execute(l_cursor);
4389: dbms_sql.close_cursor(l_cursor);
4390: IF (l_num <> 1) THEN
4391: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4392: fnd_message.set_token('MSG', l_func_name ||
4393: ' is unable to insert new combination. ' ||

Line 4401: dbms_sql.close_cursor(l_cursor);

4397: END IF;
4398: x_is_new := 'Y';
4399: EXCEPTION
4400: WHEN OTHERS THEN
4401: dbms_sql.close_cursor(l_cursor);
4402: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4403: fnd_message.set_token('MSG', l_func_name ||
4404: ' is unable to insert new combination. ' ||
4405: ' into table ' || p_application_table_name ||