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

Line 1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;

1393:
1394: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||'
1395: from gl_code_combinations
1396: where code_combination_id=' || g_ccid;
1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1400: I := Dbms_Sql.Execute(vl_cursor);
1401:

Line 1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);

1394: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||'
1395: from gl_code_combinations
1396: where code_combination_id=' || g_ccid;
1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1400: I := Dbms_Sql.Execute(vl_cursor);
1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;

Line 1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);

1395: from gl_code_combinations
1396: where code_combination_id=' || g_ccid;
1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1400: I := Dbms_Sql.Execute(vl_cursor);
1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1403:

Line 1400: I := Dbms_Sql.Execute(vl_cursor);

1396: where code_combination_id=' || g_ccid;
1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1400: I := Dbms_Sql.Execute(vl_cursor);
1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1403:
1404: Dbms_Sql.Column_Value(Vl_Cursor, 1, g_CREDIT_COHORT_YR);

Line 1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;

1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1400: I := Dbms_Sql.Execute(vl_cursor);
1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1403:
1404: Dbms_Sql.Column_Value(Vl_Cursor, 1, g_CREDIT_COHORT_YR);
1405: dbms_sql.close_cursor(Vl_Cursor);
1406: end if;

Line 1404: Dbms_Sql.Column_Value(Vl_Cursor, 1, g_CREDIT_COHORT_YR);

1400: I := Dbms_Sql.Execute(vl_cursor);
1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1403:
1404: Dbms_Sql.Column_Value(Vl_Cursor, 1, g_CREDIT_COHORT_YR);
1405: dbms_sql.close_cursor(Vl_Cursor);
1406: end if;
1407: Exception
1408: When Others Then

Line 1405: dbms_sql.close_cursor(Vl_Cursor);

1401:
1402: I := Dbms_Sql.Fetch_Rows(vl_cursor) ;
1403:
1404: Dbms_Sql.Column_Value(Vl_Cursor, 1, g_CREDIT_COHORT_YR);
1405: dbms_sql.close_cursor(Vl_Cursor);
1406: end if;
1407: Exception
1408: When Others Then
1409: Null;

Line 1609: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;

1605: g_error_code := 0 ;
1606: g_error_buf := NULL ;
1607:
1608: BEGIN
1609: l_jrnl_cursor := DBMS_SQL.OPEN_CURSOR;
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: g_error_code := SQLCODE;
1613: g_error_buf := SQLERRM ||

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

1906: ' ORDER BY fund_value , ' || g_acct_segment_name ;
1907:
1908: BEGIN
1909: l_jrnl_select := l_jrnl_select_gl||' UNION ALL '||l_jrnl_select_xla;
1910: DBMS_SQL.PARSE(l_jrnl_cursor, l_jrnl_select, DBMS_SQL.V7);
1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: g_error_code := SQLCODE;

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

1920: RETURN;
1921: END;
1922:
1923: -- Bind the variables
1924: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);

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

1921: END;
1922:
1923: -- Bind the variables
1924: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);

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

1922:
1923: -- Bind the variables
1924: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');

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

1923: -- Bind the variables
1924: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);

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

1924: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);

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

1925: dbms_sql.bind_variable(l_jrnl_cursor, ':status', 'P');
1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);

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

1926: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1927: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_low', g_period_num_low);
1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);

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

1928: dbms_sql.bind_variable(l_jrnl_cursor, ':period_num_high', g_period_num_high);
1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1936:

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

1929: dbms_sql.bind_variable(l_jrnl_cursor, ':period_year', l_period_year);
1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1936:
1937: counter := 1;

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

1930: dbms_sql.bind_variable(l_jrnl_cursor, ':actual_flag', 'A');
1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1936:
1937: counter := 1;
1938: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);

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

1931: dbms_sql.bind_variable(l_jrnl_cursor, ':from_posted_date', g_from_gl_posted_date);
1932: dbms_sql.bind_variable(l_jrnl_cursor, ':to_posted_date', g_to_gl_posted_date);
1933: dbms_sql.bind_variable(l_jrnl_cursor, ':coa_id', l_coa);
1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1936:
1937: counter := 1;
1938: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1939: counter := counter+1;

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

1934: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1935: dbms_sql.bind_variable(l_jrnl_cursor, ':sob_id', l_sob);
1936:
1937: counter := 1;
1938: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1939: counter := counter+1;
1940: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1941: counter := counter+1;
1942: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);

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

1936:
1937: counter := 1;
1938: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1939: counter := counter+1;
1940: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1941: counter := counter+1;
1942: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1943: counter := counter+1;
1944: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);

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

1938: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_dr);
1939: counter := counter+1;
1940: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1941: counter := counter+1;
1942: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1943: counter := counter+1;
1944: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1945: counter := counter+1;
1946: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);

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

1940: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_entered_cr);
1941: counter := counter+1;
1942: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1943: counter := counter+1;
1944: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1945: counter := counter+1;
1946: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1947: counter := counter+1;
1948: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);

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

1942: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_1, 80);
1943: counter := counter+1;
1944: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1945: counter := counter+1;
1946: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1947: counter := counter+1;
1948: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1949: counter := counter+1;
1950: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);

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

1944: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_2, 80);
1945: counter := counter+1;
1946: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1947: counter := counter+1;
1948: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1949: counter := counter+1;
1950: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1951: counter := counter+1;
1952: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);

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

1946: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_3, 80);
1947: counter := counter+1;
1948: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1949: counter := counter+1;
1950: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1951: counter := counter+1;
1952: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1953: counter := counter+1;
1954: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);

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

1948: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_4, 80);
1949: counter := counter+1;
1950: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1951: counter := counter+1;
1952: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1953: counter := counter+1;
1954: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1955: counter := counter+1;
1956: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);

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

1950: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_5, 80);
1951: counter := counter+1;
1952: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1953: counter := counter+1;
1954: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1955: counter := counter+1;
1956: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1957: counter := counter+1;
1958: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);

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

1952: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_6, 80);
1953: counter := counter+1;
1954: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1955: counter := counter+1;
1956: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1957: counter := counter+1;
1958: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1959: counter := counter+1;
1960: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);

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

1954: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter, l_reference_7, 80);
1955: counter := counter+1;
1956: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1957: counter := counter+1;
1958: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1959: counter := counter+1;
1960: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1961: counter := counter+1;
1962: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);

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

1956: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_8, 80);
1957: counter := counter+1;
1958: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1959: counter := counter+1;
1960: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1961: counter := counter+1;
1962: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1963: counter := counter+1;
1964: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);

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

1958: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_9, 80);
1959: counter := counter+1;
1960: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1961: counter := counter+1;
1962: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1963: counter := counter+1;
1964: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1965: counter := counter+1;
1966: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

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

1960: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_reference_10,80);
1961: counter := counter+1;
1962: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1963: counter := counter+1;
1964: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1965: counter := counter+1;
1966: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1967: counter := counter+1;
1968: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);

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

1962: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_sl_link_id);
1963: counter := counter+1;
1964: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1965: counter := counter+1;
1966: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1967: counter := counter+1;
1968: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1969: counter := counter+1;
1970: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

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

1964: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_from_sla_flag, 1);
1965: counter := counter+1;
1966: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1967: counter := counter+1;
1968: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1969: counter := counter+1;
1970: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1971: counter := counter+1;
1972: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

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

1966: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
1967: counter := counter+1;
1968: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1969: counter := counter+1;
1970: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1971: counter := counter+1;
1972: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1973: counter := counter+1;
1974: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);

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

1968: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source_distribution_type, 30);
1969: counter := counter+1;
1970: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1971: counter := counter+1;
1972: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1973: counter := counter+1;
1974: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1975: counter := counter+1;
1976: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);

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

1970: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
1971: counter := counter+1;
1972: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1973: counter := counter+1;
1974: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1975: counter := counter+1;
1976: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1977: counter := counter+1;
1978: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);

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

1972: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
1973: counter := counter+1;
1974: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1975: counter := counter+1;
1976: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1977: counter := counter+1;
1978: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1979: counter := counter+1;
1980: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);

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

1974: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_event_type_code, 30);
1975: counter := counter+1;
1976: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1977: counter := counter+1;
1978: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1979: counter := counter+1;
1980: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1981: counter := counter+1;
1982: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);

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

1976: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_name, 150);
1977: counter := counter+1;
1978: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1979: counter := counter+1;
1980: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1981: counter := counter+1;
1982: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1983: counter := counter+1;
1984: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);

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

1978: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_account_number, 25);
1979: counter := counter+1;
1980: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1981: counter := counter+1;
1982: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1983: counter := counter+1;
1984: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1985: counter := counter+1;
1986: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);

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

1980: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_seg_fiscal_yr,4);
1981: counter := counter+1;
1982: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1983: counter := counter+1;
1984: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1985: counter := counter+1;
1986: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1987: counter := counter+1;
1988: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);

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

1982: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_category, 80);
1983: counter := counter+1;
1984: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1985: counter := counter+1;
1986: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1987: counter := counter+1;
1988: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1989: counter := counter+1;
1990: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_num);

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

1984: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_source, 80);
1985: counter := counter+1;
1986: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1987: counter := counter+1;
1988: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1989: counter := counter+1;
1990: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_num);
1991: counter := counter+1;
1992:

Line 1990: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_num);

1986: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_ccid);
1987: counter := counter+1;
1988: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_header_id);
1989: counter := counter+1;
1990: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_num);
1991: counter := counter+1;
1992:
1993: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1994: counter := counter+1;

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

1989: counter := counter+1;
1990: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_num);
1991: counter := counter+1;
1992:
1993: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1994: counter := counter+1;
1995: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1996: counter := counter+1;
1997: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);

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

1991: counter := counter+1;
1992:
1993: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1994: counter := counter+1;
1995: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1996: counter := counter+1;
1997: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1998: counter := counter+1;
1999: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);

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

1993: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_creation_date);
1994: counter := counter+1;
1995: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1996: counter := counter+1;
1997: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1998: counter := counter+1;
1999: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
2000: counter := counter+1;
2001: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);

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

1995: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_modified_date);
1996: counter := counter+1;
1997: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1998: counter := counter+1;
1999: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
2000: counter := counter+1;
2001: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
2002: counter := counter+1;
2003: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);

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

1997: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_line_period_name, 15);
1998: counter := counter+1;
1999: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
2000: counter := counter+1;
2001: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
2002: counter := counter+1;
2003: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
2004: counter := counter+1;
2005: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);

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

1999: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_date_created);
2000: counter := counter+1;
2001: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
2002: counter := counter+1;
2003: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
2004: counter := counter+1;
2005: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
2006: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
2007:

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

2001: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_creation_date);
2002: counter := counter+1;
2003: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
2004: counter := counter+1;
2005: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
2006: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
2007:
2008: counter := counter+1;
2009: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);

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

2002: counter := counter+1;
2003: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_created_by);
2004: counter := counter+1;
2005: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
2006: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
2007:
2008: counter := counter+1;
2009: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
2010: counter := counter+1;

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

2005: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_fund_value,25);
2006: -- DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, 27,l_proj,90);
2007:
2008: counter := counter+1;
2009: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
2010: counter := counter+1;
2011: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
2012: counter := counter+1;
2013: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_batch_id);

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

2007:
2008: counter := counter+1;
2009: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
2010: counter := counter+1;
2011: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
2012: counter := counter+1;
2013: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_batch_id);
2014: counter := counter+1;
2015:

Line 2013: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_batch_id);

2009: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_date);
2010: counter := counter+1;
2011: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_gl_posted_date);
2012: counter := counter+1;
2013: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_batch_id);
2014: counter := counter+1;
2015:
2016: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2017: counter := counter+1;

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

2012: counter := counter+1;
2013: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_je_batch_id);
2014: counter := counter+1;
2015:
2016: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2017: counter := counter+1;
2018: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2019: counter := counter+1;
2020: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);

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

2014: counter := counter+1;
2015:
2016: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2017: counter := counter+1;
2018: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2019: counter := counter+1;
2020: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
2021: counter := counter+1;
2022:

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

2016: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2017: counter := counter+1;
2018: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2019: counter := counter+1;
2020: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,l_sla_entity_id);
2021: counter := counter+1;
2022:
2023:
2024: IF (l_jrnl_att IS NOT NULL) THEN

Line 2025: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,

2021: counter := counter+1;
2022:
2023:
2024: IF (l_jrnl_att IS NOT NULL) THEN
2025: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor, counter,
2026: l_jrnl_att_value, 240);
2027: counter := counter+1;
2028: END IF;
2029:

Line 2031: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2027: counter := counter+1;
2028: END IF;
2029:
2030: IF g_cohort_seg_name IS NOT NULL Then
2031: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2032: counter,l_cohort_year, 25);
2033: counter := counter+1;
2034: END IF;
2035:

Line 2037: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2033: counter := counter+1;
2034: END IF;
2035:
2036: IF g_reimb_agree_seg_name IS NOT NULL Then
2037: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2038: counter,l_reimb_agree_seg_val, 25);
2039: counter := counter+1;
2040: END IF;
2041:

Line 2044: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2040: END IF;
2041:
2042:
2043: IF l_pl_code_col IS NOT NULL Then
2044: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2045: counter,l_pl_code, 150);
2046: counter := counter+1;
2047: END IF;
2048:

Line 2050: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2046: counter := counter+1;
2047: END IF;
2048:
2049: IF l_advance_type_col IS NOT NULL Then
2050: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2051: counter,l_advance_type, 150);
2052: counter := counter+1;
2053: END IF;
2054:

Line 2056: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2052: counter := counter+1;
2053: END IF;
2054:
2055: IF l_tr_dept_id_col IS NOT NULL Then
2056: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2057: counter,l_tr_dept_id, 150);
2058: counter := counter+1;
2059: END IF;
2060:

Line 2062: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,

2058: counter := counter+1;
2059: END IF;
2060:
2061: IF l_tr_main_acct_col IS NOT NULL Then
2062: DBMS_SQL.DEFINE_COLUMN(l_jrnl_cursor,
2063: counter,l_tr_main_acct, 150);
2064: counter := counter+1;
2065: END IF;
2066:

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

2068: log(l_module,'Period Num High: '|| G_PERIOD_NUM_HIGH);
2069: --log(l_module, substr(l_jrnl_select,1,250));
2070:
2071: BEGIN
2072: l_exec_ret := dbms_sql.execute(l_jrnl_cursor);
2073: log(l_module, 'l_exec_ret: '||l_exec_ret);
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: g_error_code := SQLCODE;

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

2152: l_party_fed_nonfed := NULL;
2153: l_ussgl_enabled := 'N';
2154: l_main_acct := NULL;
2155:
2156: l_jrnl_fetch := DBMS_SQL.FETCH_ROWS(l_jrnl_cursor);
2157:
2158: log(l_module,'L_JRNL_FETCH '||L_JRNL_FETCH);
2159:
2160: IF (l_jrnl_fetch = 0) THEN

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

2168: END IF;
2169:
2170: -- Fetch the records into variables
2171: counter := 1;
2172: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
2173: counter := counter+1;
2174: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
2175: counter := counter+1;
2176: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);

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

2170: -- Fetch the records into variables
2171: counter := 1;
2172: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
2173: counter := counter+1;
2174: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
2175: counter := counter+1;
2176: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
2177: counter := counter+1;
2178: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);

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

2172: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_dr);
2173: counter := counter+1;
2174: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
2175: counter := counter+1;
2176: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
2177: counter := counter+1;
2178: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
2179: counter := counter+1;
2180: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);

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

2174: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_entered_cr);
2175: counter := counter+1;
2176: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
2177: counter := counter+1;
2178: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
2179: counter := counter+1;
2180: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
2181: counter := counter+1;
2182: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);

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

2176: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_1);
2177: counter := counter+1;
2178: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
2179: counter := counter+1;
2180: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
2181: counter := counter+1;
2182: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
2183: counter := counter+1;
2184: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);

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

2178: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_2);
2179: counter := counter+1;
2180: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
2181: counter := counter+1;
2182: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
2183: counter := counter+1;
2184: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
2185: counter := counter+1;
2186: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);

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

2180: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_3);
2181: counter := counter+1;
2182: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
2183: counter := counter+1;
2184: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
2185: counter := counter+1;
2186: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
2187: counter := counter+1;
2188: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);

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

2182: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_4);
2183: counter := counter+1;
2184: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
2185: counter := counter+1;
2186: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
2187: counter := counter+1;
2188: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
2189: counter := counter+1;
2190: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);

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

2184: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_5);
2185: counter := counter+1;
2186: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
2187: counter := counter+1;
2188: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
2189: counter := counter+1;
2190: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
2191: counter := counter+1;
2192: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);

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

2186: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_6);
2187: counter := counter+1;
2188: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
2189: counter := counter+1;
2190: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
2191: counter := counter+1;
2192: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
2193: counter := counter+1;
2194: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);

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

2188: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter, l_reference_7);
2189: counter := counter+1;
2190: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
2191: counter := counter+1;
2192: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
2193: counter := counter+1;
2194: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
2195: counter := counter+1;
2196: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);

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

2190: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_8);
2191: counter := counter+1;
2192: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
2193: counter := counter+1;
2194: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
2195: counter := counter+1;
2196: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
2197: counter := counter+1;
2198: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);

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

2192: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_9);
2193: counter := counter+1;
2194: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
2195: counter := counter+1;
2196: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
2197: counter := counter+1;
2198: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
2199: counter := counter+1;
2200: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);

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

2194: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_reference_10);
2195: counter := counter+1;
2196: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
2197: counter := counter+1;
2198: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
2199: counter := counter+1;
2200: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
2201: counter := counter+1;
2202: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);

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

2196: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_sl_link_id);
2197: counter := counter+1;
2198: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
2199: counter := counter+1;
2200: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
2201: counter := counter+1;
2202: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
2203: counter := counter+1;
2204: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);

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

2198: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_from_sla_flag);
2199: counter := counter+1;
2200: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
2201: counter := counter+1;
2202: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
2203: counter := counter+1;
2204: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
2205: counter := counter+1;
2206: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);

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

2200: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_id_num_1);
2201: counter := counter+1;
2202: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
2203: counter := counter+1;
2204: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
2205: counter := counter+1;
2206: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
2207: counter := counter+1;
2208: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);

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

2202: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source_distribution_type);
2203: counter := counter+1;
2204: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
2205: counter := counter+1;
2206: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
2207: counter := counter+1;
2208: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
2209: counter := counter+1;
2210: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);

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

2204: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_source_id_num_1);
2205: counter := counter+1;
2206: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
2207: counter := counter+1;
2208: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
2209: counter := counter+1;
2210: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
2211: counter := counter+1;
2212: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);

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

2206: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_applied_to_dist_id_num_1);
2207: counter := counter+1;
2208: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
2209: counter := counter+1;
2210: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
2211: counter := counter+1;
2212: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
2213: counter := counter+1;
2214: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);

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

2208: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_event_type_code);
2209: counter := counter+1;
2210: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
2211: counter := counter+1;
2212: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
2213: counter := counter+1;
2214: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
2215: counter := counter+1;
2216: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);

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

2210: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_name);
2211: counter := counter+1;
2212: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
2213: counter := counter+1;
2214: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
2215: counter := counter+1;
2216: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
2217: counter := counter+1;
2218: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);

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

2212: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_account_number);
2213: counter := counter+1;
2214: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
2215: counter := counter+1;
2216: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
2217: counter := counter+1;
2218: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
2219: counter := counter+1;
2220: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);

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

2214: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_seg_fiscal_yr);
2215: counter := counter+1;
2216: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
2217: counter := counter+1;
2218: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
2219: counter := counter+1;
2220: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
2221: counter := counter+1;
2222: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);

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

2216: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_category);
2217: counter := counter+1;
2218: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
2219: counter := counter+1;
2220: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
2221: counter := counter+1;
2222: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
2223: counter := counter+1;
2224: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_num);

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

2218: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_source);
2219: counter := counter+1;
2220: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
2221: counter := counter+1;
2222: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
2223: counter := counter+1;
2224: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_num);
2225: counter := counter+1;
2226:

Line 2224: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_num);

2220: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_ccid);
2221: counter := counter+1;
2222: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_header_id);
2223: counter := counter+1;
2224: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_num);
2225: counter := counter+1;
2226:
2227: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
2228: counter := counter+1;

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

2223: counter := counter+1;
2224: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_num);
2225: counter := counter+1;
2226:
2227: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
2228: counter := counter+1;
2229: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
2230: counter := counter+1;
2231: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);

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

2225: counter := counter+1;
2226:
2227: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
2228: counter := counter+1;
2229: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
2230: counter := counter+1;
2231: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
2232: counter := counter+1;
2233: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);

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

2227: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_creation_date);
2228: counter := counter+1;
2229: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
2230: counter := counter+1;
2231: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
2232: counter := counter+1;
2233: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
2234: counter := counter+1;
2235: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);

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

2229: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_modified_date);
2230: counter := counter+1;
2231: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
2232: counter := counter+1;
2233: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
2234: counter := counter+1;
2235: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
2236: counter := counter+1;
2237: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);

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

2231: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_line_period_name);
2232: counter := counter+1;
2233: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
2234: counter := counter+1;
2235: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
2236: counter := counter+1;
2237: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
2238: counter := counter+1;
2239: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);

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

2233: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_date_created);
2234: counter := counter+1;
2235: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
2236: counter := counter+1;
2237: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
2238: counter := counter+1;
2239: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
2240: counter := counter+1;
2241: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);

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

2235: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_creation_date);
2236: counter := counter+1;
2237: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
2238: counter := counter+1;
2239: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
2240: counter := counter+1;
2241: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
2242: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
2243: counter := counter+1;

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

2237: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_created_by);
2238: counter := counter+1;
2239: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
2240: counter := counter+1;
2241: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
2242: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
2243: counter := counter+1;
2244: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
2245: counter := counter+1;

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

2238: counter := counter+1;
2239: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_fund_value);
2240: counter := counter+1;
2241: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
2242: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
2243: counter := counter+1;
2244: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
2245: counter := counter+1;
2246: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_batch_id);

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

2240: counter := counter+1;
2241: -- DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, 27,l_proj);
2242: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
2243: counter := counter+1;
2244: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
2245: counter := counter+1;
2246: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_batch_id);
2247: counter := counter+1;
2248:

Line 2246: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_batch_id);

2242: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_date);
2243: counter := counter+1;
2244: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_gl_posted_date);
2245: counter := counter+1;
2246: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_batch_id);
2247: counter := counter+1;
2248:
2249: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2250: counter := counter+1;

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

2245: counter := counter+1;
2246: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_je_batch_id);
2247: counter := counter+1;
2248:
2249: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2250: counter := counter+1;
2251: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2252: counter := counter+1;
2253: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);

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

2247: counter := counter+1;
2248:
2249: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2250: counter := counter+1;
2251: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2252: counter := counter+1;
2253: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
2254: counter := counter+1;
2255:

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

2249: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_event_id);
2250: counter := counter+1;
2251: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_hdr_creation_date);
2252: counter := counter+1;
2253: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
2254: counter := counter+1;
2255:
2256: IF (l_jrnl_att IS NOT NULL) THEN
2257: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

Line 2257: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2253: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor, counter,l_sla_entity_id);
2254: counter := counter+1;
2255:
2256: IF (l_jrnl_att IS NOT NULL) THEN
2257: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2258: counter, l_jrnl_att_value);
2259: counter := counter+1;
2260: ELSE
2261: l_jrnl_att_value := NULL;

Line 2265: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2261: l_jrnl_att_value := NULL;
2262: END IF;
2263:
2264: IF g_cohort_seg_name IS NOT NULL THEN
2265: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2266: counter,l_cohort_year);
2267: counter := counter+1;
2268: ELSE
2269: l_cohort_year := NULL;

Line 2273: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2269: l_cohort_year := NULL;
2270: END IF;
2271:
2272: IF g_reimb_agree_seg_name IS NOT NULL THEN
2273: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2274: counter,l_reimb_agree_seg_val);
2275: counter := counter+1;
2276: ELSE
2277: l_reimb_agree_seg_val := NULL;

Line 2281: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2277: l_reimb_agree_seg_val := NULL;
2278: END IF;
2279:
2280: IF l_pl_code_col IS NOT NULL THEN
2281: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2282: counter,l_pl_code);
2283: counter := counter+1;
2284: END IF;
2285:

Line 2287: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2283: counter := counter+1;
2284: END IF;
2285:
2286: IF l_advance_type_col IS NOT NULL THEN
2287: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2288: counter,l_advance_type);
2289: counter := counter+1;
2290: END IF;
2291:

Line 2293: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2289: counter := counter+1;
2290: END IF;
2291:
2292: IF l_tr_dept_id_col IS NOT NULL THEN
2293: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2294: counter,l_tr_dept_id);
2295: counter := counter+1;
2296: END IF;
2297:

Line 2299: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,

2295: counter := counter+1;
2296: END IF;
2297:
2298: IF l_tr_main_acct_col IS NOT NULL THEN
2299: DBMS_SQL.COLUMN_VALUE(l_jrnl_cursor,
2300: counter,l_tr_main_acct);
2301: END IF;
2302:
2303: l_valid_flag := 'Y';

Line 3283: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

3279: RETURN;
3280: END IF;
3281:
3282: END LOOP;
3283: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
3284: log(l_module,'End');
3285: EXCEPTION
3286: WHEN OTHERS THEN
3287: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

Line 3287: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);

3283: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
3284: log(l_module,'End');
3285: EXCEPTION
3286: WHEN OTHERS THEN
3287: DBMS_SQL.CLOSE_CURSOR(l_jrnl_cursor);
3288: g_error_code := 2 ;
3289: g_error_buf := 'JOURNAL PROCESSES - Exception Main (Others) - ' ||
3290: to_char(sqlcode) || ' - ' || SQLERRM;
3291: log(l_module, l_module||'.final_exception'||' '||g_error_buf);

Line 4504: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);

4500: WHEN NO_DATA_FOUND THEN
4501: g_error_buf := 'Get Fund Group Info:NO DATA FOUND for ccid: '||
4502: p_ccid;
4503: WHEN OTHERS THEN
4504: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);
4505: g_error_code := 2 ;
4506: g_error_buf := 'GET FUND GROUP INFO - Exception (Others) - ' ||
4507: to_char(sqlcode) || ' - ' || sqlerrm ;
4508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,