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_FACTS2_DERIVE_BALANCES dependencies on DBMS_SQL

Line 1133: l_gl_cursor_id := dbms_sql.open_cursor;

1129: END IF;
1130:
1131: IF (p_error_code = g_SUCCESS) THEN
1132: BEGIN
1133: l_gl_cursor_id := dbms_sql.open_cursor;
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: p_error_code := g_FAILURE;
1137: p_error_desc := SQLERRM;

Line 1146: dbms_sql.parse(l_gl_cursor_id, l_gl_cursor_str, dbms_sql.v7);

1142: END IF;
1143:
1144: IF (p_error_code = g_SUCCESS) THEN
1145: BEGIN
1146: dbms_sql.parse(l_gl_cursor_id, l_gl_cursor_str, dbms_sql.v7);
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: p_error_code := g_FAILURE;
1150: p_error_desc := SQLERRM;

Line 1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);

1155: END IF;
1156:
1157: IF (p_error_code = g_SUCCESS) THEN
1158: BEGIN
1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);
1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);

Line 1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);

1156:
1157: IF (p_error_code = g_SUCCESS) THEN
1158: BEGIN
1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);
1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);

Line 1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);

1157: IF (p_error_code = g_SUCCESS) THEN
1158: BEGIN
1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);
1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);

Line 1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);

1158: BEGIN
1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);
1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);

Line 1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);

1159: dbms_sql.bind_variable(l_gl_cursor_id,':b_period_year', p_fiscal_year);
1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);

Line 1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);

1160: dbms_sql.bind_variable(l_gl_cursor_id,':b_code_combination_id', l_code_combination_id);
1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);

Line 1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);

1161: dbms_sql.bind_variable(l_gl_cursor_id,':b_account', l_account);
1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);

Line 1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);

1162: dbms_sql.bind_variable(l_gl_cursor_id,':b_ussgl_account', l_ussgl_account);
1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);

Line 1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);

1163: dbms_sql.bind_variable(l_gl_cursor_id,':b_fund', l_fund);
1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);

Line 1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);

1164: dbms_sql.bind_variable(l_gl_cursor_id,':b_fyr', l_fyr);
1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);

Line 1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);

1165: dbms_sql.bind_variable(l_gl_cursor_id,':b_cohort', l_cohort);
1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);
1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);

Line 1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);

1166: dbms_sql.bind_variable(l_gl_cursor_id,':b_public_law_code', l_public_law_code);
1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);
1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);
1174: EXCEPTION

Line 1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);

1167: dbms_sql.bind_variable(l_gl_cursor_id,':b_advance_flag', l_advance_flag);
1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);
1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);
1174: EXCEPTION
1175: WHEN OTHERS THEN

Line 1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);

1168: dbms_sql.bind_variable(l_gl_cursor_id,':b_transfer_flag', l_transfer_flag);
1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);
1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: p_error_code := g_FAILURE;

Line 1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);

1169: dbms_sql.bind_variable(l_gl_cursor_id,':b_curr_date', l_system_date);
1170: dbms_sql.bind_variable(l_gl_cursor_id,':b_user_id', g_user_id);
1171: dbms_sql.bind_variable(l_gl_cursor_id,':b_request_id', g_request_id);
1172: dbms_sql.bind_variable(l_gl_cursor_id,':b_treasury_symbol_id', l_treasury_symbol_id);
1173: dbms_sql.bind_variable(l_gl_cursor_id,':b_set_of_books_id', p_ledger_id);
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: p_error_code := g_FAILURE;
1177: p_error_desc := SQLERRM;

Line 1186: l_gl_cursor_ret := dbms_sql.execute(l_gl_cursor_id);

1182: END IF;
1183:
1184: IF (p_error_code = g_SUCCESS) THEN
1185: BEGIN
1186: l_gl_cursor_ret := dbms_sql.execute(l_gl_cursor_id);
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: p_error_code := g_FAILURE;
1190: p_error_desc := SQLERRM;

Line 1199: dbms_sql.close_cursor(l_gl_cursor_id);

1195: END IF;
1196:
1197: IF (p_error_code = g_SUCCESS) THEN
1198: BEGIN
1199: dbms_sql.close_cursor(l_gl_cursor_id);
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: p_error_code := g_FAILURE;
1203: p_error_desc := SQLERRM;