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

Line 897: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;

893: g_error_code := 0 ;
894: g_error_buf := NULL ;
895:
896: BEGIN
897: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;
898: EXCEPTION
899: WHEN OTHERS THEN
900: g_error_code := SQLCODE;
901: g_error_buf := SQLERRM ||

Line 1213: DBMS_SQL.PARSE(l_jrnl_cursor, l_jrnl_select, DBMS_SQL.V7);

1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);
1210:
1211: BEGIN
1212: l_jrnl_select := l_jrnl_select_gl||' UNION ALL '||l_jrnl_select_xla;
1213: DBMS_SQL.PARSE(l_jrnl_cursor, l_jrnl_select, DBMS_SQL.V7);
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: g_error_code := SQLCODE;
1217: g_error_buf := SQLERRM ||

Line 1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

1225: -- FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_JRNL_SELECT);
1226: -- END IF;
1227:
1228: -- Bind the variables
1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);

Line 1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);

1226: -- END IF;
1227:
1228: -- Bind the variables
1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);

Line 1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);

1227:
1228: -- Bind the variables
1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');

Line 1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');

1228: -- Bind the variables
1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

Line 1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);

1229: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);

Line 1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);

1230: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);

Line 1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');

1231: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);

Line 1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

1232: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);

Line 1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);

1233: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

Line 1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);

1234: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

Line 1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);

1235: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

Line 1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);

1236: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1244:

Line 1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

1237: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1244:
1245: counter := 1;

Line 1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

1238: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1244:
1245: counter := 1;
1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);

Line 1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

1239: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1240: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1241: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1244:
1245: counter := 1;
1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1247: counter := counter+1;

Line 1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);

1242: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1243: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1244:
1245: counter := 1;
1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1247: counter := counter+1;
1248: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1249: counter := counter+1;
1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);

Line 1248: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);

1244:
1245: counter := 1;
1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1247: counter := counter+1;
1248: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1249: counter := counter+1;
1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1251: counter := counter+1;
1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);

Line 1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);

1246: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1247: counter := counter+1;
1248: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1249: counter := counter+1;
1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1251: counter := counter+1;
1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1253: counter := counter+1;
1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);

Line 1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);

1248: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1249: counter := counter+1;
1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1251: counter := counter+1;
1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1253: counter := counter+1;
1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1255: counter := counter+1;
1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);

Line 1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);

1250: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1251: counter := counter+1;
1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1253: counter := counter+1;
1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1255: counter := counter+1;
1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1257: counter := counter+1;
1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);

Line 1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);

1252: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1253: counter := counter+1;
1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1255: counter := counter+1;
1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1257: counter := counter+1;
1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1259: counter := counter+1;
1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);

Line 1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);

1254: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1255: counter := counter+1;
1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1257: counter := counter+1;
1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1259: counter := counter+1;
1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1261: counter := counter+1;
1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);

Line 1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);

1256: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1257: counter := counter+1;
1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1259: counter := counter+1;
1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1261: counter := counter+1;
1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1263: counter := counter+1;
1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);

Line 1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);

1258: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1259: counter := counter+1;
1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1261: counter := counter+1;
1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1263: counter := counter+1;
1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1265: counter := counter+1;
1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);

Line 1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);

1260: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1261: counter := counter+1;
1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1263: counter := counter+1;
1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1265: counter := counter+1;
1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1267: counter := counter+1;
1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);

Line 1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);

1262: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1263: counter := counter+1;
1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1265: counter := counter+1;
1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1267: counter := counter+1;
1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1269: counter := counter+1;
1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);

Line 1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);

1264: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1265: counter := counter+1;
1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1267: counter := counter+1;
1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1269: counter := counter+1;
1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1271: counter := counter+1;
1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);

Line 1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);

1266: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1267: counter := counter+1;
1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1269: counter := counter+1;
1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1271: counter := counter+1;
1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1273: counter := counter+1;
1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

Line 1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);

1268: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1269: counter := counter+1;
1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1271: counter := counter+1;
1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1273: counter := counter+1;
1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1275: counter := counter+1;
1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);

Line 1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

1270: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1271: counter := counter+1;
1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1273: counter := counter+1;
1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1275: counter := counter+1;
1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1277: counter := counter+1;
1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

Line 1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);

1272: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1273: counter := counter+1;
1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1275: counter := counter+1;
1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1277: counter := counter+1;
1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1279: counter := counter+1;
1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

Line 1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

1274: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1275: counter := counter+1;
1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1277: counter := counter+1;
1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1279: counter := counter+1;
1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1281: counter := counter+1;
1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);

Line 1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

1276: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1277: counter := counter+1;
1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1279: counter := counter+1;
1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1281: counter := counter+1;
1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1283: counter := counter+1;
1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);

Line 1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);

1278: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1279: counter := counter+1;
1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1281: counter := counter+1;
1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1283: counter := counter+1;
1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1285: counter := counter+1;
1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);

Line 1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);

1280: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1281: counter := counter+1;
1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1283: counter := counter+1;
1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1285: counter := counter+1;
1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1287: counter := counter+1;
1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);

Line 1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);

1282: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1283: counter := counter+1;
1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1285: counter := counter+1;
1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1287: counter := counter+1;
1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1289: counter := counter+1;
1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);

Line 1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);

1284: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1285: counter := counter+1;
1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1287: counter := counter+1;
1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1289: counter := counter+1;
1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1291: counter := counter+1;
1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);

Line 1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);

1286: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1287: counter := counter+1;
1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1289: counter := counter+1;
1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1291: counter := counter+1;
1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1293: counter := counter+1;
1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);

Line 1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);

1288: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1289: counter := counter+1;
1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1291: counter := counter+1;
1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1293: counter := counter+1;
1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1295: counter := counter+1;
1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);

Line 1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);

1290: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1291: counter := counter+1;
1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1293: counter := counter+1;
1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1295: counter := counter+1;
1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1297: counter := counter+1;
1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);

Line 1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);

1292: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1293: counter := counter+1;
1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1295: counter := counter+1;
1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1297: counter := counter+1;
1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1299: counter := counter+1;
1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);

Line 1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);

1294: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1295: counter := counter+1;
1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1297: counter := counter+1;
1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1299: counter := counter+1;
1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1301: counter := counter+1;
1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);

Line 1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);

1296: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1297: counter := counter+1;
1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1299: counter := counter+1;
1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1301: counter := counter+1;
1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1303: counter := counter+1;
1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);

Line 1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);

1298: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1299: counter := counter+1;
1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1301: counter := counter+1;
1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1303: counter := counter+1;
1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1305: counter := counter+1;
1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);

Line 1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);

1300: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1301: counter := counter+1;
1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1303: counter := counter+1;
1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1305: counter := counter+1;
1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1307: counter := counter+1;
1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);

Line 1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);

1302: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1303: counter := counter+1;
1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1305: counter := counter+1;
1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1307: counter := counter+1;
1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1309: counter := counter+1;
1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);

Line 1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);

1304: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1305: counter := counter+1;
1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1307: counter := counter+1;
1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1309: counter := counter+1;
1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1311: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1312:

Line 1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);

1306: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1307: counter := counter+1;
1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1309: counter := counter+1;
1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1311: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1312:
1313: counter := counter+1;
1314: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);

Line 1311: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);

1307: counter := counter+1;
1308: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1309: counter := counter+1;
1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1311: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1312:
1313: counter := counter+1;
1314: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1315: counter := counter+1;

Line 1314: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);

1310: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1311: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1312:
1313: counter := counter+1;
1314: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1315: counter := counter+1;
1316: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1317: counter := counter+1;
1318:

Line 1316: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);

1312:
1313: counter := counter+1;
1314: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1315: counter := counter+1;
1316: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1317: counter := counter+1;
1318:
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1320: counter := counter+1;

Line 1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);

1315: counter := counter+1;
1316: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1317: counter := counter+1;
1318:
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);

Line 1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);

1317: counter := counter+1;
1318:
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
1324: counter := counter+1;
1325:

Line 1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);

1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
1324: counter := counter+1;
1325:
1326:
1327: IF (l_jrnl_att IS NOT NULL) THEN

Line 1328: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,

1324: counter := counter+1;
1325:
1326:
1327: IF (l_jrnl_att IS NOT NULL) THEN
1328: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,
1329: l_jrnl_att_value, 240);
1330: counter := counter+1;
1331: END IF;
1332:

Line 1334: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1330: counter := counter+1;
1331: END IF;
1332:
1333: IF g_cohort_seg_name IS NOT NULL Then
1334: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1335: counter,l_cohort_year, 25);
1336: counter := counter+1;
1337: END IF;
1338:

Line 1340: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1336: counter := counter+1;
1337: END IF;
1338:
1339: IF l_pl_code_col IS NOT NULL Then
1340: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1341: counter,l_pl_code, 150);
1342: counter := counter+1;
1343: END IF;
1344:

Line 1346: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1342: counter := counter+1;
1343: END IF;
1344:
1345: IF l_advance_type_col IS NOT NULL Then
1346: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1347: counter,l_advance_type, 150);
1348: counter := counter+1;
1349: END IF;
1350:

Line 1352: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1348: counter := counter+1;
1349: END IF;
1350:
1351: IF l_tr_dept_id_col IS NOT NULL Then
1352: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1353: counter,l_tr_dept_id, 150);
1354: counter := counter+1;
1355: END IF;
1356:

Line 1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1354: counter := counter+1;
1355: END IF;
1356:
1357: IF l_tr_main_acct_col IS NOT NULL Then
1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1359: counter,l_tr_main_acct, 150);
1360: counter := counter+1;
1361: END IF;
1362:

Line 1376: l_exec_ret := dbms_sql.execute(l_jrnl_cursor);

1372: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY_SYMBOL_ID: '|| G_TREASURY_SYMBOL_ID);
1373: END IF;
1374:
1375: BEGIN
1376: l_exec_ret := dbms_sql.execute(l_jrnl_cursor);
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: g_error_code := SQLCODE;
1380: g_error_buf := SQLERRM ||

Line 1448: l_jrnl_fetch := DBMS_SQL.FETCH_ROWS(l_jrnl_cursor);

1444: l_sla_hdr_creation_date := NULL;
1445: l_sla_entity_id := NULL;
1446: l_account_class := NULL;
1447:
1448: l_jrnl_fetch := DBMS_SQL.FETCH_ROWS(l_jrnl_cursor);
1449:
1450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1451: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_JRNL_FETCH '||L_JRNL_FETCH);
1452: END IF;

Line 1471: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);

1467: END IF;
1468:
1469: -- Fetch the records into variables
1470: counter := 1;
1471: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1472: counter := counter+1;
1473: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1474: counter := counter+1;
1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);

Line 1473: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);

1469: -- Fetch the records into variables
1470: counter := 1;
1471: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1472: counter := counter+1;
1473: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1474: counter := counter+1;
1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1476: counter := counter+1;
1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);

Line 1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);

1471: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1472: counter := counter+1;
1473: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1474: counter := counter+1;
1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1476: counter := counter+1;
1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1478: counter := counter+1;
1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);

Line 1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);

1473: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1474: counter := counter+1;
1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1476: counter := counter+1;
1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1478: counter := counter+1;
1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1480: counter := counter+1;
1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);

Line 1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);

1475: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1476: counter := counter+1;
1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1478: counter := counter+1;
1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1480: counter := counter+1;
1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1482: counter := counter+1;
1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);

Line 1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);

1477: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1478: counter := counter+1;
1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1480: counter := counter+1;
1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1482: counter := counter+1;
1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1484: counter := counter+1;
1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);

Line 1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);

1479: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1480: counter := counter+1;
1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1482: counter := counter+1;
1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1484: counter := counter+1;
1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1486: counter := counter+1;
1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);

Line 1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);

1481: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1482: counter := counter+1;
1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1484: counter := counter+1;
1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1486: counter := counter+1;
1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1488: counter := counter+1;
1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);

Line 1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);

1483: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1484: counter := counter+1;
1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1486: counter := counter+1;
1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1488: counter := counter+1;
1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1490: counter := counter+1;
1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);

Line 1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);

1485: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1486: counter := counter+1;
1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1488: counter := counter+1;
1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1490: counter := counter+1;
1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1492: counter := counter+1;
1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);

Line 1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);

1487: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1488: counter := counter+1;
1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1490: counter := counter+1;
1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1492: counter := counter+1;
1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1494: counter := counter+1;
1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);

Line 1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);

1489: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1490: counter := counter+1;
1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1492: counter := counter+1;
1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1494: counter := counter+1;
1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1496: counter := counter+1;
1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);

Line 1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);

1491: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1492: counter := counter+1;
1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1494: counter := counter+1;
1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1496: counter := counter+1;
1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1498: counter := counter+1;
1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

Line 1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);

1493: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1494: counter := counter+1;
1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1496: counter := counter+1;
1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1498: counter := counter+1;
1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1500: counter := counter+1;
1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);

Line 1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

1495: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1496: counter := counter+1;
1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1498: counter := counter+1;
1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1500: counter := counter+1;
1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1502: counter := counter+1;
1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

Line 1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);

1497: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1498: counter := counter+1;
1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1500: counter := counter+1;
1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1502: counter := counter+1;
1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1504: counter := counter+1;
1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

Line 1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

1499: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1500: counter := counter+1;
1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1502: counter := counter+1;
1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1504: counter := counter+1;
1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1506: counter := counter+1;
1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);

Line 1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

1501: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1502: counter := counter+1;
1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1504: counter := counter+1;
1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1506: counter := counter+1;
1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1508: counter := counter+1;
1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);

Line 1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);

1503: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1504: counter := counter+1;
1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1506: counter := counter+1;
1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1508: counter := counter+1;
1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1510: counter := counter+1;
1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);

Line 1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);

1505: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1506: counter := counter+1;
1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1508: counter := counter+1;
1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1510: counter := counter+1;
1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1512: counter := counter+1;
1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);

Line 1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);

1507: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1508: counter := counter+1;
1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1510: counter := counter+1;
1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1512: counter := counter+1;
1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1514: counter := counter+1;
1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);

Line 1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);

1509: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1510: counter := counter+1;
1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1512: counter := counter+1;
1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1514: counter := counter+1;
1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1516: counter := counter+1;
1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);

Line 1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);

1511: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1512: counter := counter+1;
1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1514: counter := counter+1;
1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1516: counter := counter+1;
1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1518: counter := counter+1;
1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);

Line 1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);

1513: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1514: counter := counter+1;
1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1516: counter := counter+1;
1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1518: counter := counter+1;
1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1520: counter := counter+1;
1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);

Line 1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);

1515: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1516: counter := counter+1;
1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1518: counter := counter+1;
1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1520: counter := counter+1;
1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1522: counter := counter+1;
1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);

Line 1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);

1517: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1518: counter := counter+1;
1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1520: counter := counter+1;
1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1522: counter := counter+1;
1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1524: counter := counter+1;
1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);

Line 1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);

1519: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1520: counter := counter+1;
1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1522: counter := counter+1;
1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1524: counter := counter+1;
1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1526: counter := counter+1;
1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);

Line 1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);

1521: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1522: counter := counter+1;
1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1524: counter := counter+1;
1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1526: counter := counter+1;
1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1528: counter := counter+1;
1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);

Line 1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);

1523: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1524: counter := counter+1;
1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1526: counter := counter+1;
1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1528: counter := counter+1;
1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1530: counter := counter+1;
1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);

Line 1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);

1525: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1526: counter := counter+1;
1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1528: counter := counter+1;
1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1530: counter := counter+1;
1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1532: counter := counter+1;
1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);

Line 1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);

1527: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1528: counter := counter+1;
1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1530: counter := counter+1;
1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1532: counter := counter+1;
1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1534: counter := counter+1;
1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);

Line 1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);

1529: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1530: counter := counter+1;
1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1532: counter := counter+1;
1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1534: counter := counter+1;
1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1536: counter := counter+1;
1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);

Line 1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);

1531: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1532: counter := counter+1;
1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1534: counter := counter+1;
1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1536: counter := counter+1;
1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1539: counter := counter+1;

Line 1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);

1533: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1534: counter := counter+1;
1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1536: counter := counter+1;
1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1541: counter := counter+1;

Line 1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);

1534: counter := counter+1;
1535: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1536: counter := counter+1;
1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1541: counter := counter+1;
1542:

Line 1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);

1536: counter := counter+1;
1537: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1541: counter := counter+1;
1542:
1543: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1544: counter := counter+1;

Line 1543: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);

1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1541: counter := counter+1;
1542:
1543: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1544: counter := counter+1;
1545: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1546: counter := counter+1;
1547: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);

Line 1545: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);

1541: counter := counter+1;
1542:
1543: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1544: counter := counter+1;
1545: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1546: counter := counter+1;
1547: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
1548: counter := counter+1;
1549:

Line 1547: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);

1543: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1544: counter := counter+1;
1545: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1546: counter := counter+1;
1547: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
1548: counter := counter+1;
1549:
1550:
1551:

Line 1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1550:
1551:
1552: IF (l_jrnl_att IS NOT NULL)
1553: THEN
1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1555: counter, l_jrnl_att_value);
1556: counter := counter+1;
1557: ELSE
1558: l_jrnl_att_value := NULL;

Line 1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1558: l_jrnl_att_value := NULL;
1559: END IF;
1560:
1561: IF g_cohort_seg_name IS NOT NULL THEN
1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1563: counter,l_cohort_year);
1564: counter := counter+1;
1565: ELSE
1566: l_cohort_year := NULL;

Line 1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1566: l_cohort_year := NULL;
1567: END IF;
1568:
1569: IF l_pl_code_col IS NOT NULL THEN
1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1571: counter,l_pl_code);
1572: counter := counter+1;
1573: END IF;
1574:

Line 1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1572: counter := counter+1;
1573: END IF;
1574:
1575: IF l_advance_type_col IS NOT NULL THEN
1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1577: counter,l_advance_type);
1578: counter := counter+1;
1579: END IF;
1580:

Line 1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1578: counter := counter+1;
1579: END IF;
1580:
1581: IF l_tr_dept_id_col IS NOT NULL THEN
1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1583: counter,l_tr_dept_id);
1584: counter := counter+1;
1585: END IF;
1586:

Line 1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1584: counter := counter+1;
1585: END IF;
1586:
1587: IF l_tr_main_acct_col IS NOT NULL THEN
1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1589: counter,l_tr_main_acct);
1590: END IF;
1591:
1592: l_valid_flag := 'Y';

Line 2900: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

2896: THEN
2897: return;
2898: END IF;
2899: END LOOP;
2900: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
2901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2902: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LEAVING JOURNAL PROCESSES ...');
2903: END IF;
2904: EXCEPTION

Line 2906: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

2902: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LEAVING JOURNAL PROCESSES ...');
2903: END IF;
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
2907: g_error_code := 2 ;
2908: g_error_buf := 'JOURNAL PROCESSES - Exception Main (Others) - ' ||
2909: to_char(sqlcode) || ' - ' || SQLERRM;
2910: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

Line 4168: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);

4164: EXCEPTION
4165: WHEN NO_DATA_FOUND THEN
4166: g_error_buf := 'Get Fund Group Info: NO DATA FOUND for ccid : ' || p_ccid;
4167: WHEN OTHERS THEN
4168: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);
4169: g_error_code := 2 ;
4170: g_error_buf := 'GET FUND GROUP INFO - Exception (Others) - ' ||
4171: to_char(sqlcode) || ' - ' || sqlerrm ;
4172: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);