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 77: cur_hdl := dbms_sql.open_cursor;

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

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

74: like to make sure the calling program does not see the rows that gets deleted, therefore truncate is not used.
75: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
76: which could result in that we think the rows got deleted but they still exist.
77: cur_hdl := dbms_sql.open_cursor;
78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);

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

75: In addition, the truncate operation might not be able to delete the rows that the calling program has not commited yet,
76: which could result in that we think the rows got deleted but they still exist.
77: cur_hdl := dbms_sql.open_cursor;
78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);

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

76: which could result in that we think the rows got deleted but they still exist.
77: cur_hdl := dbms_sql.open_cursor;
78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

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

77: cur_hdl := dbms_sql.open_cursor;
78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);

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

78: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_GT', dbms_sql.native);
79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);

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

79: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);

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

80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);

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

81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);

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

82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);

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

83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor

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

84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */

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

85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */
93: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

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

86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */
93: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');

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

87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */
93: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');
95: END IF;

Line 119: cur_hdl := dbms_sql.open_cursor;

115: OPEN bal_seg_val_cur;
116: LOOP
117: FETCH bal_seg_val_cur INTO l_bal_seg_column_name;
118: EXIT WHEN bal_seg_val_cur%NOTFOUND;
119: cur_hdl := dbms_sql.open_cursor;
120: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
121: ' SET rec_bsv = ' ||
122: ' (SELECT ' || l_bal_seg_column_name ||
123: ' FROM gl_code_combinations ' ||

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

123: ' FROM gl_code_combinations ' ||
124: ' WHERE code_combination_id = inter_int.rec_acct ' ||
125: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
126: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
127: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
128: rows_processed := dbms_sql.execute(cur_hdl);
129: dbms_sql.close_cursor(cur_hdl); -- close cursor
130:
131: cur_hdl := dbms_sql.open_cursor;

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

124: ' WHERE code_combination_id = inter_int.rec_acct ' ||
125: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
126: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
127: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
128: rows_processed := dbms_sql.execute(cur_hdl);
129: dbms_sql.close_cursor(cur_hdl); -- close cursor
130:
131: cur_hdl := dbms_sql.open_cursor;
132: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||

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

125: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
126: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
127: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
128: rows_processed := dbms_sql.execute(cur_hdl);
129: dbms_sql.close_cursor(cur_hdl); -- close cursor
130:
131: cur_hdl := dbms_sql.open_cursor;
132: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
133: ' SET pay_bsv = ' ||

Line 131: cur_hdl := dbms_sql.open_cursor;

127: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
128: rows_processed := dbms_sql.execute(cur_hdl);
129: dbms_sql.close_cursor(cur_hdl); -- close cursor
130:
131: cur_hdl := dbms_sql.open_cursor;
132: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
133: ' SET pay_bsv = ' ||
134: ' (SELECT ' || l_bal_seg_column_name ||
135: ' FROM gl_code_combinations ' ||

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

135: ' FROM gl_code_combinations ' ||
136: ' WHERE code_combination_id = inter_int.pay_acct ' ||
137: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
138: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
139: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
140: rows_processed := dbms_sql.execute(cur_hdl);
141: dbms_sql.close_cursor(cur_hdl); -- close cursor
142: END LOOP;
143: CLOSE bal_seg_val_cur;

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

136: ' WHERE code_combination_id = inter_int.pay_acct ' ||
137: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
138: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
139: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
140: rows_processed := dbms_sql.execute(cur_hdl);
141: dbms_sql.close_cursor(cur_hdl); -- close cursor
142: END LOOP;
143: CLOSE bal_seg_val_cur;
144: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

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

137: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
138: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
139: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
140: rows_processed := dbms_sql.execute(cur_hdl);
141: dbms_sql.close_cursor(cur_hdl); -- close cursor
142: END LOOP;
143: CLOSE bal_seg_val_cur;
144: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.update_inter_seg_val.end', 'end');

Line 359: cur_hdl := dbms_sql.open_cursor;

355: PROCEDURE ins_headers_t(headers_tab IN headers_tab_type, headers_count IN NUMBER) IS
356: cur_hdl int;
357: BEGIN
358:
359: cur_hdl := dbms_sql.open_cursor;
360: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
361: dbms_sql.close_cursor(cur_hdl); -- close cursor
362: IF headers_count > 0 THEN
363: FORALL i IN headers_tab.first..headers_tab.last

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

356: cur_hdl int;
357: BEGIN
358:
359: cur_hdl := dbms_sql.open_cursor;
360: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
361: dbms_sql.close_cursor(cur_hdl); -- close cursor
362: IF headers_count > 0 THEN
363: FORALL i IN headers_tab.first..headers_tab.last
364: INSERT INTO fun_bal_headers_t

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

357: BEGIN
358:
359: cur_hdl := dbms_sql.open_cursor;
360: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
361: dbms_sql.close_cursor(cur_hdl); -- close cursor
362: IF headers_count > 0 THEN
363: FORALL i IN headers_tab.first..headers_tab.last
364: INSERT INTO fun_bal_headers_t
365: VALUES headers_tab(i);

Line 373: cur_hdl := dbms_sql.open_cursor;

369:
370: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
371: cur_hdl int;
372: BEGIN
373: cur_hdl := dbms_sql.open_cursor;
374: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
375: dbms_sql.close_cursor(cur_hdl); -- close cursor
376: IF lines_count > 0 THEN
377: FORALL i IN lines_tab.first..lines_tab.last

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

370: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
371: cur_hdl int;
372: BEGIN
373: cur_hdl := dbms_sql.open_cursor;
374: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
375: dbms_sql.close_cursor(cur_hdl); -- close cursor
376: IF lines_count > 0 THEN
377: FORALL i IN lines_tab.first..lines_tab.last
378: INSERT INTO fun_bal_lines_t

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

371: cur_hdl int;
372: BEGIN
373: cur_hdl := dbms_sql.open_cursor;
374: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
375: dbms_sql.close_cursor(cur_hdl); -- close cursor
376: IF lines_count > 0 THEN
377: FORALL i IN lines_tab.first..lines_tab.last
378: INSERT INTO fun_bal_lines_t
379: VALUES lines_tab(i);

Line 386: cur_hdl := dbms_sql.open_cursor;

382:
383: PROCEDURE ins_results_t(results_tab IN results_tab_type, results_count IN NUMBER) IS
384: cur_hdl int;
385: BEGIN
386: cur_hdl := dbms_sql.open_cursor;
387: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
388: dbms_sql.close_cursor(cur_hdl); -- close cursor
389: IF results_count > 0 THEN
390: FORALL i IN results_tab.first..results_tab.last

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

383: PROCEDURE ins_results_t(results_tab IN results_tab_type, results_count IN NUMBER) IS
384: cur_hdl int;
385: BEGIN
386: cur_hdl := dbms_sql.open_cursor;
387: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
388: dbms_sql.close_cursor(cur_hdl); -- close cursor
389: IF results_count > 0 THEN
390: FORALL i IN results_tab.first..results_tab.last
391: INSERT INTO fun_bal_results_t

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

384: cur_hdl int;
385: BEGIN
386: cur_hdl := dbms_sql.open_cursor;
387: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
388: dbms_sql.close_cursor(cur_hdl); -- close cursor
389: IF results_count > 0 THEN
390: FORALL i IN results_tab.first..results_tab.last
391: INSERT INTO fun_bal_results_t
392: VALUES results_tab(i);

Line 399: cur_hdl := dbms_sql.open_cursor;

395:
396: PROCEDURE ins_errors_t(errors_tab IN errors_tab_type, errors_count IN NUMBER) IS
397: cur_hdl int;
398: BEGIN
399: cur_hdl := dbms_sql.open_cursor;
400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
401: dbms_sql.close_cursor(cur_hdl); -- close cursor
402: IF errors_count > 0 THEN
403: FORALL i IN errors_tab.first..errors_tab.last

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

396: PROCEDURE ins_errors_t(errors_tab IN errors_tab_type, errors_count IN NUMBER) IS
397: cur_hdl int;
398: BEGIN
399: cur_hdl := dbms_sql.open_cursor;
400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
401: dbms_sql.close_cursor(cur_hdl); -- close cursor
402: IF errors_count > 0 THEN
403: FORALL i IN errors_tab.first..errors_tab.last
404: INSERT INTO fun_bal_errors_t

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

397: cur_hdl int;
398: BEGIN
399: cur_hdl := dbms_sql.open_cursor;
400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
401: dbms_sql.close_cursor(cur_hdl); -- close cursor
402: IF errors_count > 0 THEN
403: FORALL i IN errors_tab.first..errors_tab.last
404: INSERT INTO fun_bal_errors_t
405: VALUES errors_tab(i);

Line 415: cur_hdl := dbms_sql.open_cursor;

411: BEGIN
412: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
413: 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');
414: END IF;
415: cur_hdl := dbms_sql.open_cursor;
416: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
417: dbms_sql.close_cursor(cur_hdl); -- close cursor
418: IF inter_le_bsv_map_count > 0 THEN
419: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

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

412: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
413: 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');
414: END IF;
415: cur_hdl := dbms_sql.open_cursor;
416: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
417: dbms_sql.close_cursor(cur_hdl); -- close cursor
418: IF inter_le_bsv_map_count > 0 THEN
419: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
420: 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 417: dbms_sql.close_cursor(cur_hdl); -- close cursor

413: 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');
414: END IF;
415: cur_hdl := dbms_sql.open_cursor;
416: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
417: dbms_sql.close_cursor(cur_hdl); -- close cursor
418: IF inter_le_bsv_map_count > 0 THEN
419: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
420: 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');
421: END IF;

Line 439: cur_hdl := dbms_sql.open_cursor;

435:
436: PROCEDURE ins_inter_int_t(inter_int_tab IN inter_int_tab_type, inter_int_count IN NUMBER) IS
437: cur_hdl int;
438: BEGIN
439: cur_hdl := dbms_sql.open_cursor;
440: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
441: dbms_sql.close_cursor(cur_hdl); -- close cursor
442:
443: IF inter_int_count > 0 THEN

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

436: PROCEDURE ins_inter_int_t(inter_int_tab IN inter_int_tab_type, inter_int_count IN NUMBER) IS
437: cur_hdl int;
438: BEGIN
439: cur_hdl := dbms_sql.open_cursor;
440: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
441: dbms_sql.close_cursor(cur_hdl); -- close cursor
442:
443: IF inter_int_count > 0 THEN
444: FORALL i IN inter_int_tab.first..inter_int_tab.last

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

437: cur_hdl int;
438: BEGIN
439: cur_hdl := dbms_sql.open_cursor;
440: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
441: dbms_sql.close_cursor(cur_hdl); -- close cursor
442:
443: IF inter_int_count > 0 THEN
444: FORALL i IN inter_int_tab.first..inter_int_tab.last
445: INSERT INTO fun_bal_inter_int_t

Line 454: cur_hdl := dbms_sql.open_cursor;

450:
451: 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
452: cur_hdl int;
453: BEGIN
454: cur_hdl := dbms_sql.open_cursor;
455: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
456: dbms_sql.close_cursor(cur_hdl); -- close cursor
457: IF intra_le_bsv_map_count > 0 THEN
458: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last

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

451: 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
452: cur_hdl int;
453: BEGIN
454: cur_hdl := dbms_sql.open_cursor;
455: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
456: dbms_sql.close_cursor(cur_hdl); -- close cursor
457: IF intra_le_bsv_map_count > 0 THEN
458: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
459: INSERT INTO fun_bal_intra_bsv_map_t

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

452: cur_hdl int;
453: BEGIN
454: cur_hdl := dbms_sql.open_cursor;
455: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
456: dbms_sql.close_cursor(cur_hdl); -- close cursor
457: IF intra_le_bsv_map_count > 0 THEN
458: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
459: INSERT INTO fun_bal_intra_bsv_map_t
460: VALUES le_bsv_map_tab(i);

Line 468: cur_hdl := dbms_sql.open_cursor;

464:
465: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
466: cur_hdl int;
467: BEGIN
468: cur_hdl := dbms_sql.open_cursor;
469: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
470: dbms_sql.close_cursor(cur_hdl); -- close cursor
471: IF intra_int_count > 0 THEN
472: FORALL i IN intra_int_tab.first..intra_int_tab.last

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

465: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
466: cur_hdl int;
467: BEGIN
468: cur_hdl := dbms_sql.open_cursor;
469: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
470: dbms_sql.close_cursor(cur_hdl); -- close cursor
471: IF intra_int_count > 0 THEN
472: FORALL i IN intra_int_tab.first..intra_int_tab.last
473: INSERT INTO fun_bal_intra_int_t

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

466: cur_hdl int;
467: BEGIN
468: cur_hdl := dbms_sql.open_cursor;
469: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
470: dbms_sql.close_cursor(cur_hdl); -- close cursor
471: IF intra_int_count > 0 THEN
472: FORALL i IN intra_int_tab.first..intra_int_tab.last
473: INSERT INTO fun_bal_intra_int_t
474: VALUES intra_int_tab(i);