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 1895: l_cur:= dbms_sql.open_cursor;

1891: ---ELSE
1892: --l_string := l_string1 || l_string2;
1893: --END IF;
1894:
1895: l_cur:= dbms_sql.open_cursor;
1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

1892: --l_string := l_string1 || l_string2;
1893: --END IF;
1894:
1895: l_cur:= dbms_sql.open_cursor;
1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

1893: --END IF;
1894:
1895: l_cur:= dbms_sql.open_cursor;
1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

1894:
1895: l_cur:= dbms_sql.open_cursor;
1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

1895: l_cur:= dbms_sql.open_cursor;
1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

1896: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

1897: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);

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

1898: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);
1906: dbms_sql.close_cursor(l_cur);

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

1899: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);
1906: dbms_sql.close_cursor(l_cur);
1907: /* END for non-sla, upgraded 11i data */

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

1900: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);
1906: dbms_sql.close_cursor(l_cur);
1907: /* END for non-sla, upgraded 11i data */
1908: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');

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

1901: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);
1906: dbms_sql.close_cursor(l_cur);
1907: /* END for non-sla, upgraded 11i data */
1908: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');
1909: /* Start for je_source is payables and je_category is non treasury */

Line 1906: dbms_sql.close_cursor(l_cur);

1902: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
1903: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
1904: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
1905: l_row := dbms_sql.EXECUTE(l_cur);
1906: dbms_sql.close_cursor(l_cur);
1907: /* END for non-sla, upgraded 11i data */
1908: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for upgraded 11i data ');
1909: /* Start for je_source is payables and je_category is non treasury */
1910:

Line 2008: l_cur:= dbms_sql.open_cursor;

2004: --ELSE
2005: --l_string := l_string1 || l_string2;
2006: --END IF;
2007:
2008: l_cur:= dbms_sql.open_cursor;
2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2005: --l_string := l_string1 || l_string2;
2006: --END IF;
2007:
2008: l_cur:= dbms_sql.open_cursor;
2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2006: --END IF;
2007:
2008: l_cur:= dbms_sql.open_cursor;
2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2007:
2008: l_cur:= dbms_sql.open_cursor;
2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2008: l_cur:= dbms_sql.open_cursor;
2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2009: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2010: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);

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

2011: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);
2019: dbms_sql.close_cursor(l_cur);

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

2012: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);
2019: dbms_sql.close_cursor(l_cur);
2020: /* END for je_source is payables and je_category is non treasury*/

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

2013: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);
2019: dbms_sql.close_cursor(l_cur);
2020: /* END for je_source is payables and je_category is non treasury*/
2021:

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

2014: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);
2019: dbms_sql.close_cursor(l_cur);
2020: /* END for je_source is payables and je_category is non treasury*/
2021:
2022: /* Start for je_source is payables and je_category is non treasury */

Line 2019: dbms_sql.close_cursor(l_cur);

2015: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2016: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2017: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2018: l_row := dbms_sql.EXECUTE(l_cur);
2019: dbms_sql.close_cursor(l_cur);
2020: /* END for je_source is payables and je_category is non treasury*/
2021:
2022: /* Start for je_source is payables and je_category is non treasury */
2023:

Line 2118: l_cur:= dbms_sql.open_cursor;

2114: --ELSE
2115: --l_string := l_string1 || l_string2;
2116: --END IF;
2117:
2118: l_cur:= dbms_sql.open_cursor;
2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2115: --l_string := l_string1 || l_string2;
2116: --END IF;
2117:
2118: l_cur:= dbms_sql.open_cursor;
2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2116: --END IF;
2117:
2118: l_cur:= dbms_sql.open_cursor;
2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2117:
2118: l_cur:= dbms_sql.open_cursor;
2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2118: l_cur:= dbms_sql.open_cursor;
2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2119: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2120: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);

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

2121: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);
2129: dbms_sql.close_cursor(l_cur);

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

2122: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);
2129: dbms_sql.close_cursor(l_cur);
2130: /* END for je_source is payables and je_category is non treasury*/

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

2123: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);
2129: dbms_sql.close_cursor(l_cur);
2130: /* END for je_source is payables and je_category is non treasury*/
2131: 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 2128: l_row := dbms_sql.EXECUTE(l_cur);

2124: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);
2129: dbms_sql.close_cursor(l_cur);
2130: /* END for je_source is payables and je_category is non treasury*/
2131: 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');
2132: /* Start for je_source is payables and je_category is treasury confirmation */

Line 2129: dbms_sql.close_cursor(l_cur);

2125: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2126: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2127: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2128: l_row := dbms_sql.EXECUTE(l_cur);
2129: dbms_sql.close_cursor(l_cur);
2130: /* END for je_source is payables and je_category is non treasury*/
2131: 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');
2132: /* Start for je_source is payables and je_category is treasury confirmation */
2133:

Line 2228: l_cur:= dbms_sql.open_cursor;

2224: --ELSE
2225: --l_string := l_string1 || l_string2;
2226: --END IF;
2227:
2228: l_cur:= dbms_sql.open_cursor;
2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2225: --l_string := l_string1 || l_string2;
2226: --END IF;
2227:
2228: l_cur:= dbms_sql.open_cursor;
2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2226: --END IF;
2227:
2228: l_cur:= dbms_sql.open_cursor;
2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2227:
2228: l_cur:= dbms_sql.open_cursor;
2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2228: l_cur:= dbms_sql.open_cursor;
2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2229: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2230: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);

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

2231: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);
2239: dbms_sql.close_cursor(l_cur);

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

2232: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);
2239: dbms_sql.close_cursor(l_cur);
2240: /* END for je_source is payables and je_category is treasury confirmation */

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

2233: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);
2239: dbms_sql.close_cursor(l_cur);
2240: /* END for je_source is payables and je_category is treasury confirmation */
2241: 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 2238: l_row := dbms_sql.EXECUTE(l_cur);

2234: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);
2239: dbms_sql.close_cursor(l_cur);
2240: /* END for je_source is payables and je_category is treasury confirmation */
2241: 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');
2242:

Line 2239: dbms_sql.close_cursor(l_cur);

2235: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2236: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2237: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2238: l_row := dbms_sql.EXECUTE(l_cur);
2239: dbms_sql.close_cursor(l_cur);
2240: /* END for je_source is payables and je_category is treasury confirmation */
2241: 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');
2242:
2243: /* Start for je_source is project and je_category is labour_cost */

Line 2337: l_cur:= dbms_sql.open_cursor;

2333: --ELSE
2334: --l_string := l_string1 || l_string2;
2335: --END IF;
2336:
2337: l_cur:= dbms_sql.open_cursor;
2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2334: --l_string := l_string1 || l_string2;
2335: --END IF;
2336:
2337: l_cur:= dbms_sql.open_cursor;
2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2335: --END IF;
2336:
2337: l_cur:= dbms_sql.open_cursor;
2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2336:
2337: l_cur:= dbms_sql.open_cursor;
2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2337: l_cur:= dbms_sql.open_cursor;
2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2338: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2339: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);

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

2340: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);

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

2341: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);
2349: /* END for je_source is project and je_category is labour_cost */

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

2342: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);
2349: /* END for je_source is project and je_category is labour_cost */
2350: 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 2347: l_row := dbms_sql.EXECUTE(l_cur);

2343: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);
2349: /* END for je_source is project and je_category is labour_cost */
2350: 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');
2351: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */

Line 2348: dbms_sql.close_cursor(l_cur);

2344: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2345: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2346: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);
2349: /* END for je_source is project and je_category is labour_cost */
2350: 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');
2351: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
2352:

Line 2449: l_cur:= dbms_sql.open_cursor;

2445: --l_string := l_string1 || l_string2;
2446: --END IF;
2447:
2448:
2449: l_cur:= dbms_sql.open_cursor;
2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2446: --END IF;
2447:
2448:
2449: l_cur:= dbms_sql.open_cursor;
2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2447:
2448:
2449: l_cur:= dbms_sql.open_cursor;
2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2448:
2449: l_cur:= dbms_sql.open_cursor;
2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2449: l_cur:= dbms_sql.open_cursor;
2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2450: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2451: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);

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

2452: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);

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

2453: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/

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

2454: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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 2459: l_row := dbms_sql.EXECUTE(l_cur);

2455: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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');
2463: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

Line 2460: dbms_sql.close_cursor(l_cur);

2456: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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');
2463: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2464:

Line 2561: l_cur:= dbms_sql.open_cursor;

2557: --ELSE
2558: --l_string := l_string1 || l_string2;
2559: --END IF;
2560:
2561: l_cur:= dbms_sql.open_cursor;
2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2558: --l_string := l_string1 || l_string2;
2559: --END IF;
2560:
2561: l_cur:= dbms_sql.open_cursor;
2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2559: --END IF;
2560:
2561: l_cur:= dbms_sql.open_cursor;
2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2560:
2561: l_cur:= dbms_sql.open_cursor;
2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2561: l_cur:= dbms_sql.open_cursor;
2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2562: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2563: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);

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

2564: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);

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

2565: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:

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

2566: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:
2574: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */

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

2567: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:
2574: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2575: 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 2572: dbms_sql.close_cursor(l_cur);

2568: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2569: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2570: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2571: l_row := dbms_sql.EXECUTE(l_cur);
2572: dbms_sql.close_cursor(l_cur);
2573:
2574: /* END for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2575: 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 ');
2576: /* Start for for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */

Line 2674: l_cur:= dbms_sql.open_cursor;

2670: --l_string := l_string1 || l_string2;
2671: --END IF;
2672:
2673:
2674: l_cur:= dbms_sql.open_cursor;
2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);

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

2671: --END IF;
2672:
2673:
2674: l_cur:= dbms_sql.open_cursor;
2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);

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

2672:
2673:
2674: l_cur:= dbms_sql.open_cursor;
2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);

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

2673:
2674: l_cur:= dbms_sql.open_cursor;
2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);

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

2674: l_cur:= dbms_sql.open_cursor;
2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);

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

2675: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);

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

2676: dbms_sql.bind_variable(l_cur,':b_sob',p_set_of_books_id);
2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);

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

2677: dbms_sql.bind_variable(l_cur,':b_g_currency_code',p_currency_code);
2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);
2685: dbms_sql.close_cursor(l_cur);

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

2678: dbms_sql.bind_variable(l_cur,':posted_from_date',p_previous_run_date);
2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);
2685: dbms_sql.close_cursor(l_cur);
2686: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */

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

2679: dbms_sql.bind_variable(l_cur,':posted_to_date',p_current_run_date);
2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);
2685: dbms_sql.close_cursor(l_cur);
2686: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2687: 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 2684: l_row := dbms_sql.EXECUTE(l_cur);

2680: dbms_sql.bind_variable(l_cur,':b_user_id',g_user_id);
2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);
2685: dbms_sql.close_cursor(l_cur);
2686: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2687: 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 ');
2688:

Line 2685: dbms_sql.close_cursor(l_cur);

2681: dbms_sql.bind_variable(l_cur,':b_sysdate',g_sysdate);
2682: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2683: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2684: l_row := dbms_sql.EXECUTE(l_cur);
2685: dbms_sql.close_cursor(l_cur);
2686: /* END for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
2687: 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 ');
2688:
2689: EXCEPTION

Line 2709: --Variables defined for dbms_sql

2705: l_exists VARCHAR2(1);
2706: p_def_p_ia_paygroup VARCHAR2(30);
2707: l_inv_pay_id NUMBER(15):= 0;
2708:
2709: --Variables defined for dbms_sql
2710: l_cursor_id INTEGER;
2711: l_ignore INTEGER;
2712: l_select VARCHAR2(2000);
2713:

Line 3077: l_cursor_id := dbms_sql.open_cursor;

3073: SELECT SUBSTR(name,1,50)
3074: INTO l_document_number
3075: FROM gl_je_headers
3076: WHERE je_header_id = l_je_header_id;
3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

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

3074: INTO l_document_number
3075: FROM gl_je_headers
3076: WHERE je_header_id = l_je_header_id;
3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);

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

3075: FROM gl_je_headers
3076: WHERE je_header_id = l_je_header_id;
3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

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

3076: WHERE je_header_id = l_je_header_id;
3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN

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

3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN
3085: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

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

3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN
3085: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3086: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

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

3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3080: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN
3085: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3086: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3087: IF l_accomplish_date IS NULL THEN

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

3081: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN
3085: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3086: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3087: IF l_accomplish_date IS NULL THEN
3088: -- create an exception
3089: l_reported_flag :='Y';

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

3082: l_ignore := dbms_sql.execute(l_cursor_id);
3083: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3084: IF (l_ignore > 0) THEN
3085: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3086: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3087: IF l_accomplish_date IS NULL THEN
3088: -- create an exception
3089: l_reported_flag :='Y';
3090: l_exception_exists :='Y' ;

Line 3129: l_cursor_id := dbms_sql.open_cursor;

3125: SELECT SUBSTR(name,1,50)
3126: INTO l_document_number
3127: FROM gl_je_headers
3128: WHERE je_header_id = l_je_header_id;
3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);

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

3126: INTO l_document_number
3127: FROM gl_je_headers
3128: WHERE je_header_id = l_je_header_id;
3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);

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

3127: FROM gl_je_headers
3128: WHERE je_header_id = l_je_header_id;
3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);

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

3128: WHERE je_header_id = l_je_header_id;
3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN

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

3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN
3137: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);

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

3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN
3137: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3138: dbms_sql.column_value(l_cursor_id, 2, l_org_id);

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

3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);
3132: dbms_sql.define_column(l_cursor_id, 1, l_accomplish_date);
3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN
3137: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3138: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3139: IF l_accomplish_date IS NULL THEN

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

3133: dbms_sql.define_column(l_cursor_id, 2, l_org_id);
3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN
3137: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3138: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3139: IF l_accomplish_date IS NULL THEN
3140: -- create an exception
3141: l_reported_flag :='Y';

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

3134: l_ignore := dbms_sql.execute(l_cursor_id);
3135: l_ignore := dbms_sql.fetch_rows(l_cursor_id);
3136: IF (l_ignore > 0) THEN
3137: dbms_sql.column_value(l_cursor_id, 1, l_accomplish_date);
3138: dbms_sql.column_value(l_cursor_id, 2, l_org_id);
3139: IF l_accomplish_date IS NULL THEN
3140: -- create an exception
3141: l_reported_flag :='Y';
3142: l_exception_exists :='Y' ;