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

Line 1921: l_cur:= dbms_sql.open_cursor;

1917: ---ELSE
1918: --l_string := l_string1 || l_string2;
1919: --END IF;
1920:
1921: l_cur:= dbms_sql.open_cursor;
1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1918: --l_string := l_string1 || l_string2;
1919: --END IF;
1920:
1921: l_cur:= dbms_sql.open_cursor;
1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

1919: --END IF;
1920:
1921: l_cur:= dbms_sql.open_cursor;
1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

1920:
1921: l_cur:= dbms_sql.open_cursor;
1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

1921: l_cur:= dbms_sql.open_cursor;
1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

1922: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

1923: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);

Line 1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

1924: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);
1932: dbms_sql.close_cursor(l_cur);

Line 1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

1925: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);
1932: dbms_sql.close_cursor(l_cur);
1933: /* END for non-sla, upgraded 11i data */

Line 1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

1926: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);
1932: dbms_sql.close_cursor(l_cur);
1933: /* END for non-sla, upgraded 11i data */
1934: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');

Line 1931: l_row := dbms_sql.EXECUTE(l_cur);

1927: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);
1932: dbms_sql.close_cursor(l_cur);
1933: /* END for non-sla, upgraded 11i data */
1934: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');
1935: /* Start for je_source is payables and je_category is non treasury */

Line 1932: dbms_sql.close_cursor(l_cur);

1928: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1929: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1930: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1931: l_row := dbms_sql.EXECUTE(l_cur);
1932: dbms_sql.close_cursor(l_cur);
1933: /* END for non-sla, upgraded 11i data */
1934: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');
1935: /* Start for je_source is payables and je_category is non treasury */
1936:

Line 2035: l_cur:= dbms_sql.open_cursor;

2031: --ELSE
2032: --l_string := l_string1 || l_string2;
2033: --END IF;
2034:
2035: l_cur:= dbms_sql.open_cursor;
2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2032: --l_string := l_string1 || l_string2;
2033: --END IF;
2034:
2035: l_cur:= dbms_sql.open_cursor;
2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2033: --END IF;
2034:
2035: l_cur:= dbms_sql.open_cursor;
2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2034:
2035: l_cur:= dbms_sql.open_cursor;
2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2035: l_cur:= dbms_sql.open_cursor;
2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2036: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2037: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);

Line 2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2038: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);
2046: dbms_sql.close_cursor(l_cur);

Line 2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2039: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);
2046: dbms_sql.close_cursor(l_cur);
2047: /* END for je_source is payables and je_category is non treasury*/

Line 2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2040: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);
2046: dbms_sql.close_cursor(l_cur);
2047: /* END for je_source is payables and je_category is non treasury*/
2048:

Line 2045: l_row := dbms_sql.EXECUTE(l_cur);

2041: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);
2046: dbms_sql.close_cursor(l_cur);
2047: /* END for je_source is payables and je_category is non treasury*/
2048:
2049: /* Start for je_source is payables and je_category is non treasury */

Line 2046: dbms_sql.close_cursor(l_cur);

2042: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2043: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2044: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2045: l_row := dbms_sql.EXECUTE(l_cur);
2046: dbms_sql.close_cursor(l_cur);
2047: /* END for je_source is payables and je_category is non treasury*/
2048:
2049: /* Start for je_source is payables and je_category is non treasury */
2050: -- Modified for bug 14239842

Line 2241: l_cur:= dbms_sql.open_cursor;

2237: --ELSE
2238: --l_string := l_string1 || l_string2;
2239: --END IF;
2240:
2241: l_cur:= dbms_sql.open_cursor;
2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2238: --l_string := l_string1 || l_string2;
2239: --END IF;
2240:
2241: l_cur:= dbms_sql.open_cursor;
2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2239: --END IF;
2240:
2241: l_cur:= dbms_sql.open_cursor;
2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2240:
2241: l_cur:= dbms_sql.open_cursor;
2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2241: l_cur:= dbms_sql.open_cursor;
2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2242: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2243: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);

Line 2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2244: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);
2252: dbms_sql.close_cursor(l_cur);

Line 2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2245: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);
2252: dbms_sql.close_cursor(l_cur);
2253: /* END for je_source is payables and je_category is non treasury*/

Line 2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2246: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);
2252: dbms_sql.close_cursor(l_cur);
2253: /* END for je_source is payables and je_category is non treasury*/
2254: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is non treasury');

Line 2251: l_row := dbms_sql.EXECUTE(l_cur);

2247: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);
2252: dbms_sql.close_cursor(l_cur);
2253: /* END for je_source is payables and je_category is non treasury*/
2254: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is non treasury');
2255: /* Start for je_source is payables and je_category is treasury confirmation */

Line 2252: dbms_sql.close_cursor(l_cur);

2248: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2249: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2250: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2251: l_row := dbms_sql.EXECUTE(l_cur);
2252: dbms_sql.close_cursor(l_cur);
2253: /* END for je_source is payables and je_category is non treasury*/
2254: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is non treasury');
2255: /* Start for je_source is payables and je_category is treasury confirmation */
2256:

Line 2352: l_cur:= dbms_sql.open_cursor;

2348: --ELSE
2349: --l_string := l_string1 || l_string2;
2350: --END IF;
2351:
2352: l_cur:= dbms_sql.open_cursor;
2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2349: --l_string := l_string1 || l_string2;
2350: --END IF;
2351:
2352: l_cur:= dbms_sql.open_cursor;
2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2350: --END IF;
2351:
2352: l_cur:= dbms_sql.open_cursor;
2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2351:
2352: l_cur:= dbms_sql.open_cursor;
2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2352: l_cur:= dbms_sql.open_cursor;
2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2353: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2354: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);

Line 2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2355: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);
2363: dbms_sql.close_cursor(l_cur);

Line 2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2356: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);
2363: dbms_sql.close_cursor(l_cur);
2364: /* END for je_source is payables and je_category is treasury confirmation */

Line 2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2357: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);
2363: dbms_sql.close_cursor(l_cur);
2364: /* END for je_source is payables and je_category is treasury confirmation */
2365: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is treasury confirmation');

Line 2362: l_row := dbms_sql.EXECUTE(l_cur);

2358: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);
2363: dbms_sql.close_cursor(l_cur);
2364: /* END for je_source is payables and je_category is treasury confirmation */
2365: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is treasury confirmation');
2366:

Line 2363: dbms_sql.close_cursor(l_cur);

2359: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2360: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2361: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2362: l_row := dbms_sql.EXECUTE(l_cur);
2363: dbms_sql.close_cursor(l_cur);
2364: /* END for je_source is payables and je_category is treasury confirmation */
2365: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is payables and je_category is treasury confirmation');
2366:
2367: /* Start for je_source is project and je_category is labour_cost */

Line 2462: l_cur:= dbms_sql.open_cursor;

2458: --ELSE
2459: --l_string := l_string1 || l_string2;
2460: --END IF;
2461:
2462: l_cur:= dbms_sql.open_cursor;
2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2459: --l_string := l_string1 || l_string2;
2460: --END IF;
2461:
2462: l_cur:= dbms_sql.open_cursor;
2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2460: --END IF;
2461:
2462: l_cur:= dbms_sql.open_cursor;
2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2461:
2462: l_cur:= dbms_sql.open_cursor;
2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2462: l_cur:= dbms_sql.open_cursor;
2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2463: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2464: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);

Line 2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2465: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);

Line 2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2466: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);
2474: /* END for je_source is project and je_category is labour_cost */

Line 2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2467: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);
2474: /* END for je_source is project and je_category is labour_cost */
2475: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is project and je_category is labour_cost');

Line 2472: l_row := dbms_sql.EXECUTE(l_cur);

2468: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);
2474: /* END for je_source is project and je_category is labour_cost */
2475: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is project and je_category is labour_cost');
2476: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */

Line 2473: dbms_sql.close_cursor(l_cur);

2469: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2470: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2471: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);
2474: /* END for je_source is project and je_category is labour_cost */
2475: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is project and je_category is labour_cost');
2476: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
2477:

Line 2575: l_cur:= dbms_sql.open_cursor;

2571: --l_string := l_string1 || l_string2;
2572: --END IF;
2573:
2574:
2575: l_cur:= dbms_sql.open_cursor;
2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2572: --END IF;
2573:
2574:
2575: l_cur:= dbms_sql.open_cursor;
2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2573:
2574:
2575: l_cur:= dbms_sql.open_cursor;
2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2574:
2575: l_cur:= dbms_sql.open_cursor;
2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2575: l_cur:= dbms_sql.open_cursor;
2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2576: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2577: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);

Line 2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2578: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);

Line 2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2579: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/

Line 2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2580: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');

Line 2585: l_row := dbms_sql.EXECUTE(l_cur);

2581: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');
2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

Line 2586: dbms_sql.close_cursor(l_cur);

2582: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');
2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2590:

Line 2688: l_cur:= dbms_sql.open_cursor;

2684: --ELSE
2685: --l_string := l_string1 || l_string2;
2686: --END IF;
2687:
2688: l_cur:= dbms_sql.open_cursor;
2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2685: --l_string := l_string1 || l_string2;
2686: --END IF;
2687:
2688: l_cur:= dbms_sql.open_cursor;
2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2686: --END IF;
2687:
2688: l_cur:= dbms_sql.open_cursor;
2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2687:
2688: l_cur:= dbms_sql.open_cursor;
2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2688: l_cur:= dbms_sql.open_cursor;
2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2689: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2690: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);

Line 2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2691: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);

Line 2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2692: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:

Line 2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2693: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

Line 2698: l_row := dbms_sql.EXECUTE(l_cur);

2694: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');

Line 2699: dbms_sql.close_cursor(l_cur);

2695: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2696: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2697: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2698: l_row := dbms_sql.EXECUTE(l_cur);
2699: dbms_sql.close_cursor(l_cur);
2700:
2701: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2702: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');
2703: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */

Line 2802: l_cur:= dbms_sql.open_cursor;

2798: --l_string := l_string1 || l_string2;
2799: --END IF;
2800:
2801:
2802: l_cur:= dbms_sql.open_cursor;
2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

Line 2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

2799: --END IF;
2800:
2801:
2802: l_cur:= dbms_sql.open_cursor;
2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

Line 2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);

2800:
2801:
2802: l_cur:= dbms_sql.open_cursor;
2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

Line 2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);

2801:
2802: l_cur:= dbms_sql.open_cursor;
2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

Line 2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

2802: l_cur:= dbms_sql.open_cursor;
2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

Line 2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

2803: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

Line 2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

2804: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);

Line 2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

2805: --dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);

Line 2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

2806: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */

Line 2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

2807: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');

Line 2812: l_row := dbms_sql.EXECUTE(l_cur);

2808: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');
2816:

Line 2813: dbms_sql.close_cursor(l_cur);

2809: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2810: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2811: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2812: l_row := dbms_sql.EXECUTE(l_cur);
2813: dbms_sql.close_cursor(l_cur);
2814: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');
2816:
2817: EXCEPTION

Line 2837: --Variables defined for dbms_sql

2833: l_exists VARCHAR2(1);
2834: p_def_p_ia_paygroup VARCHAR2(30);
2835: l_inv_pay_id NUMBER(15):= 0;
2836:
2837: --Variables defined for dbms_sql
2838: l_cursor_id INTEGER;
2839: l_ignore INTEGER;
2840: l_select VARCHAR2(2000);
2841:

Line 3212: l_cursor_id := dbms_sql.open_cursor;

3208: SELECT SUBSTR(name,1,50)
3209: INTO l_document_number
3210: FROM gl_je_headers
3211: WHERE je_header_id = l_je_header_id;
3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

Line 3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);

3209: INTO l_document_number
3210: FROM gl_je_headers
3211: WHERE je_header_id = l_je_header_id;
3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);

Line 3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

3210: FROM gl_je_headers
3211: WHERE je_header_id = l_je_header_id;
3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

Line 3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);

3211: WHERE je_header_id = l_je_header_id;
3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN

Line 3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

3212: l_cursor_id := dbms_sql.open_cursor;
3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN
3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

Line 3217: l_ignore := dbms_sql.execute(l_cursor_id);

3213: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN
3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3221: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

Line 3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

3214: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3215: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN
3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3221: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3222: IF l_accomplish_date IS NULL THEN

Line 3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

3216: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN
3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3221: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3222: IF l_accomplish_date IS NULL THEN
3223: -- create an exception
3224: l_reported_flag :='Y';

Line 3221: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

3217: l_ignore := dbms_sql.execute(l_cursor_id);
3218: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3219: IF (l_ignore > 0) THEN
3220: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3221: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3222: IF l_accomplish_date IS NULL THEN
3223: -- create an exception
3224: l_reported_flag :='Y';
3225: l_exception_exists :='Y' ;

Line 3264: l_cursor_id := dbms_sql.open_cursor;

3260: SELECT SUBSTR(name,1,50)
3261: INTO l_document_number
3262: FROM gl_je_headers
3263: WHERE je_header_id = l_je_header_id;
3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

Line 3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);

3261: INTO l_document_number
3262: FROM gl_je_headers
3263: WHERE je_header_id = l_je_header_id;
3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);

Line 3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

3262: FROM gl_je_headers
3263: WHERE je_header_id = l_je_header_id;
3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

Line 3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);

3263: WHERE je_header_id = l_je_header_id;
3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN

Line 3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

3264: l_cursor_id := dbms_sql.open_cursor;
3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN
3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

Line 3269: l_ignore := dbms_sql.execute(l_cursor_id);

3265: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN
3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3273: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

Line 3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

3266: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3267: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN
3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3273: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3274: IF l_accomplish_date IS NULL THEN

Line 3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

3268: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN
3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3273: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3274: IF l_accomplish_date IS NULL THEN
3275: -- create an exception
3276: l_reported_flag :='Y';

Line 3273: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

3269: l_ignore := dbms_sql.execute(l_cursor_id);
3270: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3271: IF (l_ignore > 0) THEN
3272: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3273: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3274: IF l_accomplish_date IS NULL THEN
3275: -- create an exception
3276: l_reported_flag :='Y';
3277: l_exception_exists :='Y' ;