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

Line 2373: l_cursor_id := dbms_sql.open_cursor;

2369: ' = :c_'||
2370: flex_rec.application_column_name;
2371: END LOOP;
2372:
2373: l_cursor_id := dbms_sql.open_cursor;
2374: dbms_sql.parse(l_cursor_id, l_ccid_select, dbms_sql.v7);
2375: dbms_sql.define_column(l_cursor_id, 1, vl_ccid);
2376: dbms_sql.bind_variable(l_cursor_id, ':coa_id', vg_coa_id);
2377:

Line 2374: dbms_sql.parse(l_cursor_id, l_ccid_select, dbms_sql.v7);

2370: flex_rec.application_column_name;
2371: END LOOP;
2372:
2373: l_cursor_id := dbms_sql.open_cursor;
2374: dbms_sql.parse(l_cursor_id, l_ccid_select, dbms_sql.v7);
2375: dbms_sql.define_column(l_cursor_id, 1, vl_ccid);
2376: dbms_sql.bind_variable(l_cursor_id, ':coa_id', vg_coa_id);
2377:
2378: l_counter := 0;

Line 2375: dbms_sql.define_column(l_cursor_id, 1, vl_ccid);

2371: END LOOP;
2372:
2373: l_cursor_id := dbms_sql.open_cursor;
2374: dbms_sql.parse(l_cursor_id, l_ccid_select, dbms_sql.v7);
2375: dbms_sql.define_column(l_cursor_id, 1, vl_ccid);
2376: dbms_sql.bind_variable(l_cursor_id, ':coa_id', vg_coa_id);
2377:
2378: l_counter := 0;
2379: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP

Line 2376: dbms_sql.bind_variable(l_cursor_id, ':coa_id', vg_coa_id);

2372:
2373: l_cursor_id := dbms_sql.open_cursor;
2374: dbms_sql.parse(l_cursor_id, l_ccid_select, dbms_sql.v7);
2375: dbms_sql.define_column(l_cursor_id, 1, vl_ccid);
2376: dbms_sql.bind_variable(l_cursor_id, ':coa_id', vg_coa_id);
2377:
2378: l_counter := 0;
2379: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP
2380: l_counter := l_counter + 1;

Line 2381: dbms_sql.bind_variable(l_cursor_id, 'c_'||flex_rec.application_column_name, vt_segments(l_counter));

2377:
2378: l_counter := 0;
2379: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP
2380: l_counter := l_counter + 1;
2381: dbms_sql.bind_variable(l_cursor_id, 'c_'||flex_rec.application_column_name, vt_segments(l_counter));
2382: END LOOP;
2383:
2384: l_ignore := dbms_sql.execute_and_fetch(l_cursor_id);
2385: dbms_sql.column_value(l_cursor_id, 1, vl_ccid);

Line 2384: l_ignore := dbms_sql.execute_and_fetch(l_cursor_id);

2380: l_counter := l_counter + 1;
2381: dbms_sql.bind_variable(l_cursor_id, 'c_'||flex_rec.application_column_name, vt_segments(l_counter));
2382: END LOOP;
2383:
2384: l_ignore := dbms_sql.execute_and_fetch(l_cursor_id);
2385: dbms_sql.column_value(l_cursor_id, 1, vl_ccid);
2386: dbms_sql.close_cursor (l_cursor_id);
2387: IF (vl_ccid IS NULL) THEN
2388: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'No CCID Exists for the following Combination');

Line 2385: dbms_sql.column_value(l_cursor_id, 1, vl_ccid);

2381: dbms_sql.bind_variable(l_cursor_id, 'c_'||flex_rec.application_column_name, vt_segments(l_counter));
2382: END LOOP;
2383:
2384: l_ignore := dbms_sql.execute_and_fetch(l_cursor_id);
2385: dbms_sql.column_value(l_cursor_id, 1, vl_ccid);
2386: dbms_sql.close_cursor (l_cursor_id);
2387: IF (vl_ccid IS NULL) THEN
2388: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'No CCID Exists for the following Combination');
2389: l_counter := 0;

Line 2386: dbms_sql.close_cursor (l_cursor_id);

2382: END LOOP;
2383:
2384: l_ignore := dbms_sql.execute_and_fetch(l_cursor_id);
2385: dbms_sql.column_value(l_cursor_id, 1, vl_ccid);
2386: dbms_sql.close_cursor (l_cursor_id);
2387: IF (vl_ccid IS NULL) THEN
2388: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'No CCID Exists for the following Combination');
2389: l_counter := 0;
2390: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP

Line 3498: c_gl_line_cur := DBMS_SQL.OPEN_CURSOR ;

3494: vl_group_by_clause := ' GROUP BY ' || SUBSTR(vl_attribute_cols, 2);
3495: END IF;
3496: ---------------------------------------------------------------------------------------
3497: BEGIN
3498: c_gl_line_cur := DBMS_SQL.OPEN_CURSOR ;
3499: EXCEPTION
3500: WHEN OTHERS THEN
3501: vp_retcode := 2;
3502: vp_errbuf := SQLERRM||

Line 3561: dbms_sql.parse(c_gl_line_cur, vl_stmt, DBMS_SQL.V7) ;

3557:
3558:
3559:
3560: BEGIN
3561: dbms_sql.parse(c_gl_line_cur, vl_stmt, DBMS_SQL.V7) ;
3562: EXCEPTION
3563: WHEN OTHERS THEN
3564: vp_retcode := 2;
3565: vp_errbuf := SQLERRM||

Line 3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);

3568: RETURN;
3569: END ;
3570:
3571: -- Bind the variables
3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);
3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);

Line 3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);

3569: END ;
3570:
3571: -- Bind the variables
3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);
3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:

Line 3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);

3570:
3571: -- Bind the variables
3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);
3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:
3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);

Line 3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');

3571: -- Bind the variables
3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);
3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:
3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);
3579: dbms_sql.define_column(c_gl_line_cur, 2, vl_line_amount);

Line 3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);

3572: dbms_sql.bind_variable(c_gl_line_cur,':ccid', vl_ccid);
3573: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:
3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);
3579: dbms_sql.define_column(c_gl_line_cur, 2, vl_line_amount);
3580:

Line 3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);

3574: dbms_sql.bind_variable(c_gl_line_cur,':closing_fyr', vp_closing_fyr);
3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:
3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);
3579: dbms_sql.define_column(c_gl_line_cur, 2, vl_line_amount);
3580:
3581: vl_column_num := 3;
3582:

Line 3579: dbms_sql.define_column(c_gl_line_cur, 2, vl_line_amount);

3575: dbms_sql.bind_variable(c_gl_line_cur,':je_status', 'P');
3576: dbms_sql.bind_variable(c_gl_line_cur,':sob_id', vg_sob_id);
3577:
3578: dbms_sql.define_column(c_gl_line_cur, 1, vl_reference_1, 280);
3579: dbms_sql.define_column(c_gl_line_cur, 2, vl_line_amount);
3580:
3581: vl_column_num := 3;
3582:
3583: IF vg_public_law_attribute IS NOT NULL THEN

Line 3584: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_public_law_code, 150);

3580:
3581: vl_column_num := 3;
3582:
3583: IF vg_public_law_attribute IS NOT NULL THEN
3584: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_public_law_code, 150);
3585: vl_column_num := vl_column_num + 1;
3586: END IF;
3587:
3588: IF vg_advance_type_attribute IS NOT NULL THEN

Line 3589: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_advance_type, 150);

3585: vl_column_num := vl_column_num + 1;
3586: END IF;
3587:
3588: IF vg_advance_type_attribute IS NOT NULL THEN
3589: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_advance_type, 150);
3590: vl_column_num := vl_column_num + 1;
3591: END IF;
3592:
3593: IF vg_trf_dept_id_attribute IS NOT NULL THEN

Line 3594: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_dept_id, 150);

3590: vl_column_num := vl_column_num + 1;
3591: END IF;
3592:
3593: IF vg_trf_dept_id_attribute IS NOT NULL THEN
3594: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_dept_id, 150);
3595: vl_column_num := vl_column_num + 1;
3596: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_main_acct, 150);
3597: END IF;
3598:

Line 3596: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_main_acct, 150);

3592:
3593: IF vg_trf_dept_id_attribute IS NOT NULL THEN
3594: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_dept_id, 150);
3595: vl_column_num := vl_column_num + 1;
3596: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_main_acct, 150);
3597: END IF;
3598:
3599: BEGIN
3600: vl_exec_cur := dbms_sql.EXECUTE(c_gl_line_cur);

Line 3600: vl_exec_cur := dbms_sql.EXECUTE(c_gl_line_cur);

3596: dbms_sql.define_column(c_gl_line_cur, vl_column_num, vl_trf_main_acct, 150);
3597: END IF;
3598:
3599: BEGIN
3600: vl_exec_cur := dbms_sql.EXECUTE(c_gl_line_cur);
3601: EXCEPTION
3602: WHEN OTHERS THEN
3603: vp_retcode := 2 ;
3604: vp_errbuf := SQLERRM||

Line 3616: IF dbms_sql.fetch_rows(c_gl_line_cur) = 0 THEN

3612: vl_advance_type := NULL;
3613: vl_trf_dept_id := NULL;
3614: vl_trf_main_acct := NULL;
3615:
3616: IF dbms_sql.fetch_rows(c_gl_line_cur) = 0 THEN
3617: EXIT;
3618: ELSE
3619:
3620: dbms_sql.column_value(c_gl_line_cur, 1, vl_reference_1);

Line 3620: dbms_sql.column_value(c_gl_line_cur, 1, vl_reference_1);

3616: IF dbms_sql.fetch_rows(c_gl_line_cur) = 0 THEN
3617: EXIT;
3618: ELSE
3619:
3620: dbms_sql.column_value(c_gl_line_cur, 1, vl_reference_1);
3621: dbms_sql.column_value(c_gl_line_cur, 2, vl_line_amount);
3622:
3623: vl_column_num := 3;
3624:

Line 3621: dbms_sql.column_value(c_gl_line_cur, 2, vl_line_amount);

3617: EXIT;
3618: ELSE
3619:
3620: dbms_sql.column_value(c_gl_line_cur, 1, vl_reference_1);
3621: dbms_sql.column_value(c_gl_line_cur, 2, vl_line_amount);
3622:
3623: vl_column_num := 3;
3624:
3625: IF vg_public_law_attribute IS NOT NULL THEN

Line 3626: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_public_law_code);

3622:
3623: vl_column_num := 3;
3624:
3625: IF vg_public_law_attribute IS NOT NULL THEN
3626: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_public_law_code);
3627: vl_column_num := vl_column_num + 1;
3628: END IF;
3629:
3630: IF vg_advance_type_attribute IS NOT NULL THEN

Line 3631: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_advance_type);

3627: vl_column_num := vl_column_num + 1;
3628: END IF;
3629:
3630: IF vg_advance_type_attribute IS NOT NULL THEN
3631: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_advance_type);
3632: vl_column_num := vl_column_num + 1;
3633: END IF;
3634:
3635: IF vg_trf_dept_id_attribute IS NOT NULL THEN

Line 3636: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_dept_id);

3632: vl_column_num := vl_column_num + 1;
3633: END IF;
3634:
3635: IF vg_trf_dept_id_attribute IS NOT NULL THEN
3636: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_dept_id);
3637: vl_column_num := vl_column_num + 1;
3638: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_main_acct);
3639: END IF;
3640:

Line 3638: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_main_acct);

3634:
3635: IF vg_trf_dept_id_attribute IS NOT NULL THEN
3636: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_dept_id);
3637: vl_column_num := vl_column_num + 1;
3638: dbms_sql.column_value(c_gl_line_cur, vl_column_num, vl_trf_main_acct);
3639: END IF;
3640:
3641: -- vl_reference_1 := gl_record.reference_1;
3642: IF vl_line_amount <> 0 THEN -- consider only non zero balance lines

Line 3665: dbms_sql.close_cursor(c_gl_line_cur);

3661: END IF;
3662: END LOOP;
3663:
3664: BEGIN
3665: dbms_sql.close_cursor(c_gl_line_cur);
3666: EXCEPTION
3667: WHEN OTHERS THEN
3668: vp_retcode := SQLCODE ;
3669: VP_ERRBUF := SQLERRM ;