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_1219_TRANSACTIONS dependencies on GL_PERIODS

Line 17: l_start_date1 GL_PERIODS.start_date%TYPE;

13: p_delete_corrections varchar2(1);
14: p_error_code number;
15: p_error_msg varchar2(150);
16:
17: l_start_date1 GL_PERIODS.start_date%TYPE;
18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;

Line 18: l_end_date1 GL_PERIODS.end_date%TYPE;

14: p_error_code number;
15: p_error_msg varchar2(150);
16:
17: l_start_date1 GL_PERIODS.start_date%TYPE;
18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;
22: l_period_year GL_PERIODS.period_year%TYPE;

Line 19: l_gl_period GL_PERIODS.period_name%TYPE;

15: p_error_msg varchar2(150);
16:
17: l_start_date1 GL_PERIODS.start_date%TYPE;
18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;
22: l_period_year GL_PERIODS.period_year%TYPE;
23:

Line 20: l_start_date2 GL_PERIODS.start_date%TYPE;

16:
17: l_start_date1 GL_PERIODS.start_date%TYPE;
18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;
22: l_period_year GL_PERIODS.period_year%TYPE;
23:
24: l_rowid varchar2(25);

Line 21: l_end_date2 GL_PERIODS.end_date%TYPE;

17: l_start_date1 GL_PERIODS.start_date%TYPE;
18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;
22: l_period_year GL_PERIODS.period_year%TYPE;
23:
24: l_rowid varchar2(25);
25:

Line 22: l_period_year GL_PERIODS.period_year%TYPE;

18: l_end_date1 GL_PERIODS.end_date%TYPE;
19: l_gl_period GL_PERIODS.period_name%TYPE;
20: l_start_date2 GL_PERIODS.start_date%TYPE;
21: l_end_date2 GL_PERIODS.end_date%TYPE;
22: l_period_year GL_PERIODS.period_year%TYPE;
23:
24: l_rowid varchar2(25);
25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;

Line 427: FROM gl_periods glp,

423: l_error_stage := 1;
424:
425: SELECT distinct year_start_date
426: INTO l_yr_start_date
427: FROM gl_periods glp,
428: gl_ledgers_public_v gsob
429: WHERE gsob.ledger_id = p_set_bks_id
430: AND gsob.period_set_name = glp.period_set_name
431: AND gsob.chart_of_accounts_id = flex_num

Line 446: FROM gl_periods glp,

442: l_error_stage := 3;
443:
444: SELECT start_date, end_date, period_year
445: INTO l_start_date1, l_end_date1, l_period_year
446: FROM gl_periods glp,
447: gl_ledgers_public_v gsob
448: WHERE glp.period_name = p_gl_period
449: AND glp.period_type = period_type
450: AND gsob.ledger_id = p_set_bks_id

Line 459: FROM gl_periods glp, gl_ledgers_public_v gsob

455:
456: -- Determine the last date of the period year
457: SELECT MAX(glp.end_date)
458: INTO l_yr_end_date
459: FROM gl_periods glp, gl_ledgers_public_v gsob
460: WHERE glp.period_year = l_period_year
461: AND gsob.ledger_id = p_set_bks_id
462: AND glp.period_set_name = gsob.period_set_name;
463:

Line 3786: FROM gl_periods glp, gl_sets_of_books gsob

3782: BEGIN
3783:
3784: SELECT end_date
3785: INTO l_accomplish_date
3786: FROM gl_periods glp, gl_sets_of_books gsob
3787: WHERE glp.period_name = l_gl_period
3788: AND glp.period_type = period_type
3789: AND gsob.set_of_books_id = p_set_bks_id
3790: AND gsob.chart_of_accounts_id = flex_num

Line 3937: FROM GL_PERIODS glp, GL_SETS_OF_BOOKS gsob

3933:
3934: BEGIN
3935: SELECT start_date, end_date
3936: INTO l_start_date2, l_end_date2
3937: FROM GL_PERIODS glp, GL_SETS_OF_BOOKS gsob
3938: WHERE glp.period_name = l_gl_period_name
3939: AND glp.period_type = period_type
3940: AND gsob.set_of_books_id = p_set_bks_id
3941: AND gsob.chart_of_accounts_id = flex_num

Line 3948: of TEMP exists in GL_PERIODS' ;

3944: EXCEPTION
3945: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
3946: p_error_code := -1 ;
3947: p_error_msg := 'No such period ('||l_gl_period||')
3948: of TEMP exists in GL_PERIODS' ;
3949: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3950: l_module_name||'.error1',p_error_msg);
3951: ROLLBACK ;
3952: RETURN ;

Line 4586: FROM gl_periods glp,

4582: WHERE set_of_books_id = p_set_bks_id;
4583:
4584: SELECT end_date
4585: INTO l_end_date
4586: FROM gl_periods glp,
4587: gl_sets_of_books gsob
4588: WHERE glp.period_name = p_gl_period
4589: AND gsob.set_of_books_id = p_set_bks_id
4590: AND gsob.chart_of_accounts_id = flex_num

Line 5029: FROM gl_periods glp,

5025: WHERE set_of_books_id = p_set_bks_id;
5026:
5027: SELECT end_date
5028: INTO l_end_date
5029: FROM gl_periods glp,
5030: gl_sets_of_books gsob
5031: WHERE glp.period_name = v_period
5032: AND gsob.set_of_books_id = p_set_bks_id
5033: AND gsob.chart_of_accounts_id = flex_num