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

Line 45: cur_hdl := dbms_sql.open_cursor;

41: perform an implicit commit => need to use autonomous transaction to perform such operation. However, we would
42: like to make sure the calling program does not see the rows that gets deleted, therefore truncate is not used.
43: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
44: which could result in that we think the rows got deleted but they still exist.
45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);

Line 46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);

42: like to make sure the calling program does not see the rows that gets deleted, therefore truncate is not used.
43: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
44: which could result in that we think the rows got deleted but they still exist.
45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);

Line 47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);

43: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
44: which could result in that we think the rows got deleted but they still exist.
45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);

Line 48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);

44: which could result in that we think the rows got deleted but they still exist.
45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

Line 49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);

45: cur_hdl := dbms_sql.open_cursor;
46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);

Line 50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);

46: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);

Line 51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);

47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);

Line 52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);

Line 53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);

49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);

Line 54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);

50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);

Line 55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);

51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor

Line 56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);

52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor
60: */

Line 57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);

53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor
60: */
61: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);

54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor
60: */
61: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');

Line 59: dbms_sql.close_cursor(cur_hdl); -- close cursor

55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
56: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
57: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor
60: */
61: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');
63: END IF;

Line 87: cur_hdl := dbms_sql.open_cursor;

83: OPEN bal_seg_val_cur;
84: LOOP
85: FETCH bal_seg_val_cur INTO l_bal_seg_column_name;
86: EXIT WHEN bal_seg_val_cur%NOTFOUND;
87: cur_hdl := dbms_sql.open_cursor;
88: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
89: ' SET rec_bsv = ' ||
90: ' (SELECT ' || l_bal_seg_column_name ||
91: ' FROM gl_code_combinations ' ||

Line 95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);

91: ' FROM gl_code_combinations ' ||
92: ' WHERE code_combination_id = inter_int.rec_acct ' ||
93: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
94: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
96: rows_processed := dbms_sql.execute(cur_hdl);
97: dbms_sql.close_cursor(cur_hdl); -- close cursor
98:
99: cur_hdl := dbms_sql.open_cursor;

Line 96: rows_processed := dbms_sql.execute(cur_hdl);

92: ' WHERE code_combination_id = inter_int.rec_acct ' ||
93: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
94: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
96: rows_processed := dbms_sql.execute(cur_hdl);
97: dbms_sql.close_cursor(cur_hdl); -- close cursor
98:
99: cur_hdl := dbms_sql.open_cursor;
100: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||

Line 97: dbms_sql.close_cursor(cur_hdl); -- close cursor

93: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
94: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
96: rows_processed := dbms_sql.execute(cur_hdl);
97: dbms_sql.close_cursor(cur_hdl); -- close cursor
98:
99: cur_hdl := dbms_sql.open_cursor;
100: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
101: ' SET pay_bsv = ' ||

Line 99: cur_hdl := dbms_sql.open_cursor;

95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
96: rows_processed := dbms_sql.execute(cur_hdl);
97: dbms_sql.close_cursor(cur_hdl); -- close cursor
98:
99: cur_hdl := dbms_sql.open_cursor;
100: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
101: ' SET pay_bsv = ' ||
102: ' (SELECT ' || l_bal_seg_column_name ||
103: ' FROM gl_code_combinations ' ||

Line 107: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);

103: ' FROM gl_code_combinations ' ||
104: ' WHERE code_combination_id = inter_int.pay_acct ' ||
105: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
106: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
107: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
108: rows_processed := dbms_sql.execute(cur_hdl);
109: dbms_sql.close_cursor(cur_hdl); -- close cursor
110: END LOOP;
111: CLOSE bal_seg_val_cur;

Line 108: rows_processed := dbms_sql.execute(cur_hdl);

104: ' WHERE code_combination_id = inter_int.pay_acct ' ||
105: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
106: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
107: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
108: rows_processed := dbms_sql.execute(cur_hdl);
109: dbms_sql.close_cursor(cur_hdl); -- close cursor
110: END LOOP;
111: CLOSE bal_seg_val_cur;
112: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 109: dbms_sql.close_cursor(cur_hdl); -- close cursor

105: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
106: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
107: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
108: rows_processed := dbms_sql.execute(cur_hdl);
109: dbms_sql.close_cursor(cur_hdl); -- close cursor
110: END LOOP;
111: CLOSE bal_seg_val_cur;
112: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.update_inter_seg_val.end', 'end');

Line 308: cur_hdl := dbms_sql.open_cursor;

304: PROCEDURE ins_headers_t(headers_tab IN headers_tab_type, headers_count IN NUMBER) IS
305: cur_hdl int;
306: BEGIN
307:
308: cur_hdl := dbms_sql.open_cursor;
309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
310: dbms_sql.close_cursor(cur_hdl); -- close cursor
311: IF headers_count > 0 THEN
312: FORALL i IN headers_tab.first..headers_tab.last

Line 309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);

305: cur_hdl int;
306: BEGIN
307:
308: cur_hdl := dbms_sql.open_cursor;
309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
310: dbms_sql.close_cursor(cur_hdl); -- close cursor
311: IF headers_count > 0 THEN
312: FORALL i IN headers_tab.first..headers_tab.last
313: INSERT INTO fun_bal_headers_t

Line 310: dbms_sql.close_cursor(cur_hdl); -- close cursor

306: BEGIN
307:
308: cur_hdl := dbms_sql.open_cursor;
309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
310: dbms_sql.close_cursor(cur_hdl); -- close cursor
311: IF headers_count > 0 THEN
312: FORALL i IN headers_tab.first..headers_tab.last
313: INSERT INTO fun_bal_headers_t
314: VALUES headers_tab(i);

Line 322: cur_hdl := dbms_sql.open_cursor;

318:
319: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
320: cur_hdl int;
321: BEGIN
322: cur_hdl := dbms_sql.open_cursor;
323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
324: dbms_sql.close_cursor(cur_hdl); -- close cursor
325: IF lines_count > 0 THEN
326: FORALL i IN lines_tab.first..lines_tab.last

Line 323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);

319: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
320: cur_hdl int;
321: BEGIN
322: cur_hdl := dbms_sql.open_cursor;
323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
324: dbms_sql.close_cursor(cur_hdl); -- close cursor
325: IF lines_count > 0 THEN
326: FORALL i IN lines_tab.first..lines_tab.last
327: INSERT INTO fun_bal_lines_t

Line 324: dbms_sql.close_cursor(cur_hdl); -- close cursor

320: cur_hdl int;
321: BEGIN
322: cur_hdl := dbms_sql.open_cursor;
323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
324: dbms_sql.close_cursor(cur_hdl); -- close cursor
325: IF lines_count > 0 THEN
326: FORALL i IN lines_tab.first..lines_tab.last
327: INSERT INTO fun_bal_lines_t
328: VALUES lines_tab(i);

Line 335: cur_hdl := dbms_sql.open_cursor;

331:
332: PROCEDURE ins_results_t(results_tab IN results_tab_type, results_count IN NUMBER) IS
333: cur_hdl int;
334: BEGIN
335: cur_hdl := dbms_sql.open_cursor;
336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
337: dbms_sql.close_cursor(cur_hdl); -- close cursor
338: IF results_count > 0 THEN
339: FORALL i IN results_tab.first..results_tab.last

Line 336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);

332: PROCEDURE ins_results_t(results_tab IN results_tab_type, results_count IN NUMBER) IS
333: cur_hdl int;
334: BEGIN
335: cur_hdl := dbms_sql.open_cursor;
336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
337: dbms_sql.close_cursor(cur_hdl); -- close cursor
338: IF results_count > 0 THEN
339: FORALL i IN results_tab.first..results_tab.last
340: INSERT INTO fun_bal_results_t

Line 337: dbms_sql.close_cursor(cur_hdl); -- close cursor

333: cur_hdl int;
334: BEGIN
335: cur_hdl := dbms_sql.open_cursor;
336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
337: dbms_sql.close_cursor(cur_hdl); -- close cursor
338: IF results_count > 0 THEN
339: FORALL i IN results_tab.first..results_tab.last
340: INSERT INTO fun_bal_results_t
341: VALUES results_tab(i);

Line 348: cur_hdl := dbms_sql.open_cursor;

344:
345: PROCEDURE ins_errors_t(errors_tab IN errors_tab_type, errors_count IN NUMBER) IS
346: cur_hdl int;
347: BEGIN
348: cur_hdl := dbms_sql.open_cursor;
349: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
350: dbms_sql.close_cursor(cur_hdl); -- close cursor
351: IF errors_count > 0 THEN
352: FORALL i IN errors_tab.first..errors_tab.last

Line 349: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

345: PROCEDURE ins_errors_t(errors_tab IN errors_tab_type, errors_count IN NUMBER) IS
346: cur_hdl int;
347: BEGIN
348: cur_hdl := dbms_sql.open_cursor;
349: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
350: dbms_sql.close_cursor(cur_hdl); -- close cursor
351: IF errors_count > 0 THEN
352: FORALL i IN errors_tab.first..errors_tab.last
353: INSERT INTO fun_bal_errors_t

Line 350: dbms_sql.close_cursor(cur_hdl); -- close cursor

346: cur_hdl int;
347: BEGIN
348: cur_hdl := dbms_sql.open_cursor;
349: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
350: dbms_sql.close_cursor(cur_hdl); -- close cursor
351: IF errors_count > 0 THEN
352: FORALL i IN errors_tab.first..errors_tab.last
353: INSERT INTO fun_bal_errors_t
354: VALUES errors_tab(i);

Line 364: cur_hdl := dbms_sql.open_cursor;

360: BEGIN
361: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.ins_t_tables_inter_1_auto', 'ins_inter_le_bsv_map_t.begin');
363: END IF;
364: cur_hdl := dbms_sql.open_cursor;
365: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
366: dbms_sql.close_cursor(cur_hdl); -- close cursor
367: IF inter_le_bsv_map_count > 0 THEN
368: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 365: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);

361: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.ins_t_tables_inter_1_auto', 'ins_inter_le_bsv_map_t.begin');
363: END IF;
364: cur_hdl := dbms_sql.open_cursor;
365: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
366: dbms_sql.close_cursor(cur_hdl); -- close cursor
367: IF inter_le_bsv_map_count > 0 THEN
368: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.ins_t_tables_inter_1_auto', 'ins_inter_le_bsv_map_t.insert_begin');

Line 366: dbms_sql.close_cursor(cur_hdl); -- close cursor

362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.ins_t_tables_inter_1_auto', 'ins_inter_le_bsv_map_t.begin');
363: END IF;
364: cur_hdl := dbms_sql.open_cursor;
365: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
366: dbms_sql.close_cursor(cur_hdl); -- close cursor
367: IF inter_le_bsv_map_count > 0 THEN
368: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.ins_t_tables_inter_1_auto', 'ins_inter_le_bsv_map_t.insert_begin');
370: END IF;

Line 388: cur_hdl := dbms_sql.open_cursor;

384:
385: PROCEDURE ins_inter_int_t(inter_int_tab IN inter_int_tab_type, inter_int_count IN NUMBER) IS
386: cur_hdl int;
387: BEGIN
388: cur_hdl := dbms_sql.open_cursor;
389: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
390: dbms_sql.close_cursor(cur_hdl); -- close cursor
391: IF inter_int_count > 0 THEN
392: FORALL i IN inter_int_tab.first..inter_int_tab.last

Line 389: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);

385: PROCEDURE ins_inter_int_t(inter_int_tab IN inter_int_tab_type, inter_int_count IN NUMBER) IS
386: cur_hdl int;
387: BEGIN
388: cur_hdl := dbms_sql.open_cursor;
389: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
390: dbms_sql.close_cursor(cur_hdl); -- close cursor
391: IF inter_int_count > 0 THEN
392: FORALL i IN inter_int_tab.first..inter_int_tab.last
393: INSERT INTO fun_bal_inter_int_t

Line 390: dbms_sql.close_cursor(cur_hdl); -- close cursor

386: cur_hdl int;
387: BEGIN
388: cur_hdl := dbms_sql.open_cursor;
389: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
390: dbms_sql.close_cursor(cur_hdl); -- close cursor
391: IF inter_int_count > 0 THEN
392: FORALL i IN inter_int_tab.first..inter_int_tab.last
393: INSERT INTO fun_bal_inter_int_t
394: VALUES inter_int_tab(i);

Line 402: cur_hdl := dbms_sql.open_cursor;

398:
399: PROCEDURE ins_intra_le_bsv_map_t(le_bsv_map_tab IN intra_le_bsv_map_tab_type, intra_le_bsv_map_count IN NUMBER) IS
400: cur_hdl int;
401: BEGIN
402: cur_hdl := dbms_sql.open_cursor;
403: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
404: dbms_sql.close_cursor(cur_hdl); -- close cursor
405: IF intra_le_bsv_map_count > 0 THEN
406: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last

Line 403: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);

399: PROCEDURE ins_intra_le_bsv_map_t(le_bsv_map_tab IN intra_le_bsv_map_tab_type, intra_le_bsv_map_count IN NUMBER) IS
400: cur_hdl int;
401: BEGIN
402: cur_hdl := dbms_sql.open_cursor;
403: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
404: dbms_sql.close_cursor(cur_hdl); -- close cursor
405: IF intra_le_bsv_map_count > 0 THEN
406: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
407: INSERT INTO fun_bal_intra_bsv_map_t

Line 404: dbms_sql.close_cursor(cur_hdl); -- close cursor

400: cur_hdl int;
401: BEGIN
402: cur_hdl := dbms_sql.open_cursor;
403: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
404: dbms_sql.close_cursor(cur_hdl); -- close cursor
405: IF intra_le_bsv_map_count > 0 THEN
406: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
407: INSERT INTO fun_bal_intra_bsv_map_t
408: VALUES le_bsv_map_tab(i);

Line 416: cur_hdl := dbms_sql.open_cursor;

412:
413: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
414: cur_hdl int;
415: BEGIN
416: cur_hdl := dbms_sql.open_cursor;
417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
418: dbms_sql.close_cursor(cur_hdl); -- close cursor
419: IF intra_int_count > 0 THEN
420: FORALL i IN intra_int_tab.first..intra_int_tab.last

Line 417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);

413: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
414: cur_hdl int;
415: BEGIN
416: cur_hdl := dbms_sql.open_cursor;
417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
418: dbms_sql.close_cursor(cur_hdl); -- close cursor
419: IF intra_int_count > 0 THEN
420: FORALL i IN intra_int_tab.first..intra_int_tab.last
421: INSERT INTO fun_bal_intra_int_t

Line 418: dbms_sql.close_cursor(cur_hdl); -- close cursor

414: cur_hdl int;
415: BEGIN
416: cur_hdl := dbms_sql.open_cursor;
417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
418: dbms_sql.close_cursor(cur_hdl); -- close cursor
419: IF intra_int_count > 0 THEN
420: FORALL i IN intra_int_tab.first..intra_int_tab.last
421: INSERT INTO fun_bal_intra_int_t
422: VALUES intra_int_tab(i);