32: AND LANGUAGE = USERENV('LANG');
33: --------------------------------------------------------------------
34: --To set the start_date and the end_date sources from parameters From Period and To Period.
35: --------------------------------------------------------------------
36: CURSOR C_period_startdate (p_period gl_period_statuses.period_name%type, p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
37: SELECT start_date
38: FROM gl_period_statuses
39: WHERE period_name = p_period
40: AND set_of_books_id = p_secondary_set_of_books_id
34: --To set the start_date and the end_date sources from parameters From Period and To Period.
35: --------------------------------------------------------------------
36: CURSOR C_period_startdate (p_period gl_period_statuses.period_name%type, p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
37: SELECT start_date
38: FROM gl_period_statuses
39: WHERE period_name = p_period
40: AND set_of_books_id = p_secondary_set_of_books_id
41: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name ='SQLGL');
42:
39: WHERE period_name = p_period
40: AND set_of_books_id = p_secondary_set_of_books_id
41: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name ='SQLGL');
42:
43: CURSOR C_period_enddate (p_period gl_period_statuses.period_name%type , p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
44: SELECT end_date
45: FROM gl_period_statuses
46: WHERE period_name = p_period
47: AND set_of_books_id = p_secondary_set_of_books_id
41: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name ='SQLGL');
42:
43: CURSOR C_period_enddate (p_period gl_period_statuses.period_name%type , p_secondary_set_of_books_id gl_interface.set_of_books_id%type ) IS
44: SELECT end_date
45: FROM gl_period_statuses
46: WHERE period_name = p_period
47: AND set_of_books_id = p_secondary_set_of_books_id
48: AND application_id =
49: (SELECT application_id FROM fnd_application WHERE application_short_name = 'SQLGL');
125:
126: PROCEDURE Submit(
127: errbuf OUT NOCOPY VARCHAR2,
128: retcode OUT NOCOPY NUMBER,
129: p_gl_from_period in gl_period_statuses.period_name%type,
130: p_gl_to_period in gl_period_statuses.period_name%type
131: ) is
132: l_request_id number ;
133: l_secondary_set_of_books_id NUMBER;
126: PROCEDURE Submit(
127: errbuf OUT NOCOPY VARCHAR2,
128: retcode OUT NOCOPY NUMBER,
129: p_gl_from_period in gl_period_statuses.period_name%type,
130: p_gl_to_period in gl_period_statuses.period_name%type
131: ) is
132: l_request_id number ;
133: l_secondary_set_of_books_id NUMBER;
134: l_chart_of_accounts_id NUMBER;