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 932: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;

928: g_error_code := 0 ;
929: g_error_buf := NULL ;
930:
931: BEGIN
932: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;
933: EXCEPTION
934: WHEN OTHERS THEN
935: g_error_code := SQLCODE;
936: g_error_buf := SQLERRM ||

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

1247:
1248:
1249: BEGIN
1250: l_jrnl_select := l_jrnl_select_gl||' UNION ALL '||l_jrnl_select_xla;
1251: DBMS_SQL.PARSE(l_jrnl_cursor, l_jrnl_select, DBMS_SQL.V7);
1252:
1253: EXCEPTION
1254: WHEN OTHERS THEN
1255: g_error_code := SQLCODE;

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

1264: -- FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_JRNL_SELECT);
1265: -- END IF;
1266:
1267: -- Bind the variables
1268: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);

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

1265: -- END IF;
1266:
1267: -- Bind the variables
1268: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);

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

1266:
1267: -- Bind the variables
1268: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');

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

1267: -- Bind the variables
1268: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1268: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);

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

1269: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);

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

1270: dbms_sql.bind_variable(l_jrnl_cursor, ':currency_code', g_currency_code);
1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);

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

1271: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);

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

1272: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1273: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1274: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1275: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1283:

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

1276: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1283:
1284: counter := 1;

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

1277: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1283:
1284: counter := 1;
1285: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);

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

1278: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1279: dbms_sql.bind_variable(l_jrnl_cursor, ':treasury_symbol_id', g_treasury_symbol_id);
1280: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1283:
1284: counter := 1;
1285: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1286: counter := counter+1;

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

1281: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1282: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1283:
1284: counter := 1;
1285: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1286: counter := counter+1;
1287: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1288: counter := counter+1;
1289: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);

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

1283:
1284: counter := 1;
1285: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1286: counter := counter+1;
1287: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1288: counter := counter+1;
1289: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1290: counter := counter+1;
1291: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);

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

1285: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1286: counter := counter+1;
1287: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1288: counter := counter+1;
1289: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1290: counter := counter+1;
1291: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1292: counter := counter+1;
1293: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);

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

1287: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1288: counter := counter+1;
1289: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1290: counter := counter+1;
1291: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1292: counter := counter+1;
1293: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1294: counter := counter+1;
1295: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);

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

1289: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1290: counter := counter+1;
1291: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1292: counter := counter+1;
1293: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1294: counter := counter+1;
1295: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1296: counter := counter+1;
1297: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);

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

1291: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1292: counter := counter+1;
1293: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1294: counter := counter+1;
1295: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1296: counter := counter+1;
1297: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1298: counter := counter+1;
1299: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);

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

1293: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1294: counter := counter+1;
1295: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1296: counter := counter+1;
1297: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1298: counter := counter+1;
1299: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1300: counter := counter+1;
1301: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);

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

1295: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1296: counter := counter+1;
1297: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1298: counter := counter+1;
1299: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1300: counter := counter+1;
1301: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1302: counter := counter+1;
1303: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);

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

1297: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1298: counter := counter+1;
1299: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1300: counter := counter+1;
1301: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1302: counter := counter+1;
1303: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1304: counter := counter+1;
1305: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);

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

1299: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1300: counter := counter+1;
1301: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1302: counter := counter+1;
1303: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1304: counter := counter+1;
1305: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1306: counter := counter+1;
1307: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);

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

1301: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1302: counter := counter+1;
1303: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1304: counter := counter+1;
1305: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1306: counter := counter+1;
1307: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1308: counter := counter+1;
1309: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);

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

1303: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1304: counter := counter+1;
1305: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1306: counter := counter+1;
1307: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1308: counter := counter+1;
1309: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1310: counter := counter+1;
1311: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);

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

1305: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1306: counter := counter+1;
1307: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1308: counter := counter+1;
1309: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1310: counter := counter+1;
1311: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1312: counter := counter+1;
1313: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

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

1307: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1308: counter := counter+1;
1309: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1310: counter := counter+1;
1311: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1312: counter := counter+1;
1313: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1314: counter := counter+1;
1315: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);

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

1309: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1310: counter := counter+1;
1311: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1312: counter := counter+1;
1313: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1314: counter := counter+1;
1315: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1316: counter := counter+1;
1317: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

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

1311: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1312: counter := counter+1;
1313: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1314: counter := counter+1;
1315: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1316: counter := counter+1;
1317: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1318: counter := counter+1;
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

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

1313: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1314: counter := counter+1;
1315: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1316: counter := counter+1;
1317: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1318: counter := counter+1;
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);

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

1315: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1316: counter := counter+1;
1317: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1318: counter := counter+1;
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);

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

1317: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1318: counter := counter+1;
1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1324: counter := counter+1;
1325: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);

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

1319: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1320: counter := counter+1;
1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1324: counter := counter+1;
1325: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1326: counter := counter+1;
1327: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);

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

1321: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1322: counter := counter+1;
1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1324: counter := counter+1;
1325: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1326: counter := counter+1;
1327: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1328: counter := counter+1;
1329: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);

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

1323: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1324: counter := counter+1;
1325: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1326: counter := counter+1;
1327: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1328: counter := counter+1;
1329: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1330: counter := counter+1;
1331: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);

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

1325: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1326: counter := counter+1;
1327: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1328: counter := counter+1;
1329: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1330: counter := counter+1;
1331: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1332: counter := counter+1;
1333: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);

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

1327: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1328: counter := counter+1;
1329: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1330: counter := counter+1;
1331: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1332: counter := counter+1;
1333: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1334: counter := counter+1;
1335: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);

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

1329: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1330: counter := counter+1;
1331: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1332: counter := counter+1;
1333: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1334: counter := counter+1;
1335: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1336: counter := counter+1;
1337: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);

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

1331: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1332: counter := counter+1;
1333: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1334: counter := counter+1;
1335: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1336: counter := counter+1;
1337: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1338: counter := counter+1;
1339: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);

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

1333: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1334: counter := counter+1;
1335: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1336: counter := counter+1;
1337: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1338: counter := counter+1;
1339: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1340: counter := counter+1;
1341: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);

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

1335: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1336: counter := counter+1;
1337: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1338: counter := counter+1;
1339: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1340: counter := counter+1;
1341: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1342: counter := counter+1;
1343: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);

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

1337: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1338: counter := counter+1;
1339: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1340: counter := counter+1;
1341: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1342: counter := counter+1;
1343: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1344: counter := counter+1;
1345: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);

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

1339: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1340: counter := counter+1;
1341: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1342: counter := counter+1;
1343: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1344: counter := counter+1;
1345: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1346: counter := counter+1;
1347: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);

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

1341: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1342: counter := counter+1;
1343: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1344: counter := counter+1;
1345: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1346: counter := counter+1;
1347: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1348: counter := counter+1;
1349: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);

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

1343: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
1344: counter := counter+1;
1345: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1346: counter := counter+1;
1347: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1348: counter := counter+1;
1349: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1350: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1351:

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

1345: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
1346: counter := counter+1;
1347: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1348: counter := counter+1;
1349: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1350: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1351:
1352: counter := counter+1;
1353: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);

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

1346: counter := counter+1;
1347: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
1348: counter := counter+1;
1349: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1350: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1351:
1352: counter := counter+1;
1353: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1354: counter := counter+1;

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

1349: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
1350: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
1351:
1352: counter := counter+1;
1353: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1354: counter := counter+1;
1355: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1356: counter := counter+1;
1357:

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

1351:
1352: counter := counter+1;
1353: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
1354: counter := counter+1;
1355: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1356: counter := counter+1;
1357:
1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1359: counter := counter+1;

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

1354: counter := counter+1;
1355: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
1356: counter := counter+1;
1357:
1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1359: counter := counter+1;
1360: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1361: counter := counter+1;
1362: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);

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

1356: counter := counter+1;
1357:
1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1359: counter := counter+1;
1360: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1361: counter := counter+1;
1362: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
1363: counter := counter+1;
1364:

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

1358: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1359: counter := counter+1;
1360: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1361: counter := counter+1;
1362: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
1363: counter := counter+1;
1364:
1365:
1366: IF (l_jrnl_att IS NOT NULL) THEN

Line 1367: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,

1363: counter := counter+1;
1364:
1365:
1366: IF (l_jrnl_att IS NOT NULL) THEN
1367: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,
1368: l_jrnl_att_value, 240);
1369: counter := counter+1;
1370: END IF;
1371:

Line 1373: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1369: counter := counter+1;
1370: END IF;
1371:
1372: IF g_cohort_seg_name IS NOT NULL Then
1373: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1374: counter,l_cohort_year, 25);
1375: counter := counter+1;
1376: END IF;
1377:

Line 1379: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1375: counter := counter+1;
1376: END IF;
1377:
1378: IF g_reimb_agree_seg_name IS NOT NULL Then
1379: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1380: counter,l_reimb_agree_seg_val, 25);
1381: counter := counter+1;
1382: END IF;
1383:

Line 1386: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1382: END IF;
1383:
1384:
1385: IF l_pl_code_col IS NOT NULL Then
1386: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1387: counter,l_pl_code, 150);
1388: counter := counter+1;
1389: END IF;
1390:

Line 1392: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1388: counter := counter+1;
1389: END IF;
1390:
1391: IF l_advance_type_col IS NOT NULL Then
1392: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1393: counter,l_advance_type, 150);
1394: counter := counter+1;
1395: END IF;
1396:

Line 1398: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1394: counter := counter+1;
1395: END IF;
1396:
1397: IF l_tr_dept_id_col IS NOT NULL Then
1398: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1399: counter,l_tr_dept_id, 150);
1400: counter := counter+1;
1401: END IF;
1402:

Line 1404: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

1400: counter := counter+1;
1401: END IF;
1402:
1403: IF l_tr_main_acct_col IS NOT NULL Then
1404: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
1405: counter,l_tr_main_acct, 150);
1406: counter := counter+1;
1407: END IF;
1408:

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

1429:
1430:
1431:
1432: BEGIN
1433: l_exec_ret := dbms_sql.execute(l_jrnl_cursor);
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: g_error_code := SQLCODE;
1437: g_error_buf := SQLERRM ||

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

1503: l_account_class := NULL;
1504: l_reimb_agree_seg_val := NULL;
1505: l_get_trx_part_from_reimb := FALSE;
1506:
1507: l_jrnl_fetch := DBMS_SQL.FETCH_ROWS(l_jrnl_cursor);
1508:
1509: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_JRNL_FETCH '||L_JRNL_FETCH);
1511: END IF;

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

1526: END IF;
1527:
1528: -- Fetch the records into variables
1529: counter := 1;
1530: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1531: counter := counter+1;
1532: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1533: counter := counter+1;
1534: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);

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

1528: -- Fetch the records into variables
1529: counter := 1;
1530: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1531: counter := counter+1;
1532: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1533: counter := counter+1;
1534: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1535: counter := counter+1;
1536: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);

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

1530: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
1531: counter := counter+1;
1532: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1533: counter := counter+1;
1534: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1535: counter := counter+1;
1536: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1537: counter := counter+1;
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);

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

1532: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
1533: counter := counter+1;
1534: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1535: counter := counter+1;
1536: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1537: counter := counter+1;
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);

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

1534: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
1535: counter := counter+1;
1536: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1537: counter := counter+1;
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1541: counter := counter+1;
1542: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);

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

1536: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
1537: counter := counter+1;
1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1541: counter := counter+1;
1542: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1543: counter := counter+1;
1544: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);

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

1538: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
1539: counter := counter+1;
1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1541: counter := counter+1;
1542: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1543: counter := counter+1;
1544: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1545: counter := counter+1;
1546: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);

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

1540: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
1541: counter := counter+1;
1542: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1543: counter := counter+1;
1544: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1545: counter := counter+1;
1546: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1547: counter := counter+1;
1548: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);

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

1542: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
1543: counter := counter+1;
1544: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1545: counter := counter+1;
1546: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1547: counter := counter+1;
1548: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1549: counter := counter+1;
1550: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);

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

1544: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
1545: counter := counter+1;
1546: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1547: counter := counter+1;
1548: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1549: counter := counter+1;
1550: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1551: counter := counter+1;
1552: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);

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

1546: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
1547: counter := counter+1;
1548: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1549: counter := counter+1;
1550: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1551: counter := counter+1;
1552: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1553: counter := counter+1;
1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);

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

1548: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
1549: counter := counter+1;
1550: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1551: counter := counter+1;
1552: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1553: counter := counter+1;
1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1555: counter := counter+1;
1556: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);

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

1550: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
1551: counter := counter+1;
1552: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1553: counter := counter+1;
1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1555: counter := counter+1;
1556: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1557: counter := counter+1;
1558: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

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

1552: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
1553: counter := counter+1;
1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1555: counter := counter+1;
1556: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1557: counter := counter+1;
1558: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1559: counter := counter+1;
1560: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);

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

1554: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
1555: counter := counter+1;
1556: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1557: counter := counter+1;
1558: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1559: counter := counter+1;
1560: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1561: counter := counter+1;
1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

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

1556: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
1557: counter := counter+1;
1558: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1559: counter := counter+1;
1560: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1561: counter := counter+1;
1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1563: counter := counter+1;
1564: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

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

1558: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1559: counter := counter+1;
1560: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1561: counter := counter+1;
1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1563: counter := counter+1;
1564: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1565: counter := counter+1;
1566: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);

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

1560: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
1561: counter := counter+1;
1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1563: counter := counter+1;
1564: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1565: counter := counter+1;
1566: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1567: counter := counter+1;
1568: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);

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

1562: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1563: counter := counter+1;
1564: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1565: counter := counter+1;
1566: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1567: counter := counter+1;
1568: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1569: counter := counter+1;
1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);

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

1564: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1565: counter := counter+1;
1566: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1567: counter := counter+1;
1568: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1569: counter := counter+1;
1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1571: counter := counter+1;
1572: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);

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

1566: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
1567: counter := counter+1;
1568: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1569: counter := counter+1;
1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1571: counter := counter+1;
1572: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1573: counter := counter+1;
1574: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);

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

1568: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
1569: counter := counter+1;
1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1571: counter := counter+1;
1572: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1573: counter := counter+1;
1574: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1575: counter := counter+1;
1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);

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

1570: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
1571: counter := counter+1;
1572: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1573: counter := counter+1;
1574: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1575: counter := counter+1;
1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1577: counter := counter+1;
1578: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);

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

1572: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
1573: counter := counter+1;
1574: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1575: counter := counter+1;
1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1577: counter := counter+1;
1578: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1579: counter := counter+1;
1580: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);

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

1574: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
1575: counter := counter+1;
1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1577: counter := counter+1;
1578: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1579: counter := counter+1;
1580: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1581: counter := counter+1;
1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);

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

1576: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
1577: counter := counter+1;
1578: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1579: counter := counter+1;
1580: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1581: counter := counter+1;
1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1583: counter := counter+1;
1584: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);

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

1578: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
1579: counter := counter+1;
1580: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1581: counter := counter+1;
1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1583: counter := counter+1;
1584: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1585: counter := counter+1;
1586: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);

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

1580: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
1581: counter := counter+1;
1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1583: counter := counter+1;
1584: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1585: counter := counter+1;
1586: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1587: counter := counter+1;
1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);

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

1582: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
1583: counter := counter+1;
1584: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1585: counter := counter+1;
1586: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1587: counter := counter+1;
1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1589: counter := counter+1;
1590: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);

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

1584: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
1585: counter := counter+1;
1586: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1587: counter := counter+1;
1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1589: counter := counter+1;
1590: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1591: counter := counter+1;
1592: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);

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

1586: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
1587: counter := counter+1;
1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1589: counter := counter+1;
1590: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1591: counter := counter+1;
1592: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1593: counter := counter+1;
1594: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);

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

1588: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
1589: counter := counter+1;
1590: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1591: counter := counter+1;
1592: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1593: counter := counter+1;
1594: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1595: counter := counter+1;
1596: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);

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

1590: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
1591: counter := counter+1;
1592: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1593: counter := counter+1;
1594: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1595: counter := counter+1;
1596: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1597: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1598: counter := counter+1;

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

1592: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
1593: counter := counter+1;
1594: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1595: counter := counter+1;
1596: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1597: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1598: counter := counter+1;
1599: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1600: counter := counter+1;

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

1593: counter := counter+1;
1594: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
1595: counter := counter+1;
1596: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1597: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1598: counter := counter+1;
1599: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1600: counter := counter+1;
1601:

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

1595: counter := counter+1;
1596: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
1597: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
1598: counter := counter+1;
1599: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1600: counter := counter+1;
1601:
1602: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1603: counter := counter+1;

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

1598: counter := counter+1;
1599: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
1600: counter := counter+1;
1601:
1602: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1603: counter := counter+1;
1604: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1605: counter := counter+1;
1606: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);

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

1600: counter := counter+1;
1601:
1602: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1603: counter := counter+1;
1604: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1605: counter := counter+1;
1606: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
1607: counter := counter+1;
1608:

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

1602: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
1603: counter := counter+1;
1604: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
1605: counter := counter+1;
1606: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
1607: counter := counter+1;
1608:
1609:
1610:

Line 1613: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1609:
1610:
1611: IF (l_jrnl_att IS NOT NULL)
1612: THEN
1613: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1614: counter, l_jrnl_att_value);
1615: counter := counter+1;
1616: ELSE
1617: l_jrnl_att_value := NULL;

Line 1621: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1617: l_jrnl_att_value := NULL;
1618: END IF;
1619:
1620: IF g_cohort_seg_name IS NOT NULL THEN
1621: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1622: counter,l_cohort_year);
1623: counter := counter+1;
1624: ELSE
1625: l_cohort_year := NULL;

Line 1629: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1625: l_cohort_year := NULL;
1626: END IF;
1627:
1628: IF g_reimb_agree_seg_name IS NOT NULL THEN
1629: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1630: counter,l_reimb_agree_seg_val);
1631: counter := counter+1;
1632: ELSE
1633: l_reimb_agree_seg_val := NULL;

Line 1638: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1634: END IF;
1635:
1636:
1637: IF l_pl_code_col IS NOT NULL THEN
1638: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1639: counter,l_pl_code);
1640: counter := counter+1;
1641: END IF;
1642:

Line 1644: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1640: counter := counter+1;
1641: END IF;
1642:
1643: IF l_advance_type_col IS NOT NULL THEN
1644: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1645: counter,l_advance_type);
1646: counter := counter+1;
1647: END IF;
1648:

Line 1650: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1646: counter := counter+1;
1647: END IF;
1648:
1649: IF l_tr_dept_id_col IS NOT NULL THEN
1650: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1651: counter,l_tr_dept_id);
1652: counter := counter+1;
1653: END IF;
1654:

Line 1656: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

1652: counter := counter+1;
1653: END IF;
1654:
1655: IF l_tr_main_acct_col IS NOT NULL THEN
1656: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
1657: counter,l_tr_main_acct);
1658: END IF;
1659:
1660: l_valid_flag := 'Y';

Line 3113: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

3109: THEN
3110: return;
3111: END IF;
3112: END LOOP;
3113: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
3114: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3115: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LEAVING JOURNAL PROCESSES ...');
3116: END IF;
3117: EXCEPTION

Line 3119: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

3115: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LEAVING JOURNAL PROCESSES ...');
3116: END IF;
3117: EXCEPTION
3118: WHEN OTHERS THEN
3119: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
3120: g_error_code := 2 ;
3121: g_error_buf := 'JOURNAL PROCESSES - Exception Main (Others) - ' ||
3122: to_char(sqlcode) || ' - ' || SQLERRM;
3123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

Line 4406: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);

4402: EXCEPTION
4403: WHEN NO_DATA_FOUND THEN
4404: g_error_buf := 'Get Fund Group Info: NO DATA FOUND for ccid : ' || p_ccid;
4405: WHEN OTHERS THEN
4406: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);
4407: g_error_code := 2 ;
4408: g_error_buf := 'GET FUND GROUP INFO - Exception (Others) - ' ||
4409: to_char(sqlcode) || ' - ' || sqlerrm ;
4410: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);