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_CFS_PKG dependencies on GL_PERIOD_STATUSES

Line 7: v_period_name gl_period_statuses.period_name%TYPE;

3: ------------Global Variables---------------
4: g_module_name VARCHAR2(100);
5: v_cursor_id INTEGER;
6: v_sob gl_ledgers_public_v.ledger_id%TYPE;
7: v_period_name gl_period_statuses.period_name%TYPE;
8: v_units NUMBER;
9: v_report_type VARCHAR2(30);
10: v_table_ind VARCHAR2(1);
11: v_end_date DATE;

Line 44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;

40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;
46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;
47: v_select1 VARCHAR2(32000);
48: v_select2 VARCHAR2(32000);

Line 45: v_period_num gl_period_statuses.period_num%TYPE;

41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;
46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;
47: v_select1 VARCHAR2(32000);
48: v_select2 VARCHAR2(32000);
49: v_select3 VARCHAR2(32000);

Line 68: v_begin_period_name gl_period_statuses.period_name%TYPE;

64: v_glbal_grpby_sel VARCHAR2(32000);
65: v_glbal_curid INTEGER;
66: v_glbal_grpby_curid INTEGER;
67: v_begin_period NUMBER;
68: v_begin_period_name gl_period_statuses.period_name%TYPE;
69: v_begin_period_end_date DATE;
70: v_end_period NUMBER;
71: v_end_period_end_date DATE;
72: v_begin_period_1 NUMBER;

Line 73: v_begin_period_name_1 gl_period_statuses.period_name%TYPE;

69: v_begin_period_end_date DATE;
70: v_end_period NUMBER;
71: v_end_period_end_date DATE;
72: v_begin_period_1 NUMBER;
73: v_begin_period_name_1 gl_period_statuses.period_name%TYPE;
74: v_begin_period_1_end_date DATE;
75: v_end_period_1_end_date DATE;
76: v_cy_gl_beg_bal NUMBER;
77: v_cy_gl_end_bal NUMBER;

Line 390: FROM gl_period_statuses

386: period_year
387: INTO v_end_date,
388: v_period_num ,
389: v_period_fiscal_year
390: FROM gl_period_statuses
391: WHERE ledger_id = v_sob
392: AND application_id = parm_application_id
393: AND period_name = v_period_name;
394: /*Sequence for fv_cfs_rep_temp table */

Line 439: FROM gl_period_statuses

435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||parm_treasury_value);
436: END IF;
437: SELECT period_num
438: INTO report_period_num
439: FROM gl_period_statuses
440: WHERE application_id = parm_application_id
441: AND set_of_books_id = v_sob
442: AND period_name = v_period_name
443: AND period_year = v_period_fiscal_year;

Line 1240: FROM gl_period_statuses

1236: INTO v_end_date ,
1237: v_period_num ,
1238: v_period_fiscal_year,
1239: v_end_period_end_date
1240: FROM gl_period_statuses
1241: WHERE ledger_id = v_sob
1242: AND application_id = '101'
1243: AND period_name = v_period_name;
1244:

Line 1255: FROM gl_period_statuses

1251: end_date
1252: INTO v_begin_period,
1253: v_begin_period_name ,
1254: v_begin_period_end_date
1255: FROM gl_period_statuses
1256: WHERE ledger_id = v_sob
1257: AND period_year = v_period_fiscal_year
1258: AND adjustment_period_flag = 'N'
1259: AND application_id = '101'

Line 1262: FROM gl_period_statuses

1258: AND adjustment_period_flag = 'N'
1259: AND application_id = '101'
1260: AND period_num =
1261: (SELECT MIN(period_num)
1262: FROM gl_period_statuses
1263: WHERE ledger_id = v_sob
1264: AND period_year = v_period_fiscal_year
1265: AND adjustment_period_flag = 'N'
1266: AND application_id = '101'

Line 1277: FROM gl_period_statuses

1273: end_date
1274: INTO v_begin_period_1,
1275: v_begin_period_name_1 ,
1276: v_begin_period_1_end_date
1277: FROM gl_period_statuses
1278: WHERE ledger_id = v_sob
1279: AND period_year = v_period_fiscal_year-1
1280: AND adjustment_period_flag = 'N'
1281: AND application_id = '101'

Line 1284: FROM gl_period_statuses

1280: AND adjustment_period_flag = 'N'
1281: AND application_id = '101'
1282: AND period_num =
1283: (SELECT MIN(period_num)
1284: FROM gl_period_statuses
1285: WHERE ledger_id = v_sob
1286: AND period_year = v_period_fiscal_year-1
1287: AND adjustment_period_flag = 'N'
1288: AND application_id = '101'

Line 1294: FROM gl_period_statuses

1290: -- Get py period end date for the period being run
1291: l_stage := 5;
1292: SELECT end_date
1293: INTO v_end_period_1_end_date
1294: FROM gl_period_statuses
1295: WHERE ledger_id = v_sob
1296: AND period_year = v_period_fiscal_year-1
1297: AND application_id = '101'
1298: AND period_num = v_period_num;

Line 1439: l_period_name_1 gl_period_statuses.period_name%TYPE;

1435: l_ignore INTEGER;
1436: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
1437: l_begin_balance NUMBER;
1438: l_end_balance NUMBER;
1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;
1441: l_begin_period_name gl_period_statuses.period_name%TYPE;
1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

Line 1440: l_period_name_2 gl_period_statuses.period_name%TYPE;

1436: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
1437: l_begin_balance NUMBER;
1438: l_end_balance NUMBER;
1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;
1441: l_begin_period_name gl_period_statuses.period_name%TYPE;
1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
1444: l_period_fiscal_year NUMBER;

Line 1441: l_begin_period_name gl_period_statuses.period_name%TYPE;

1437: l_begin_balance NUMBER;
1438: l_end_balance NUMBER;
1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;
1441: l_begin_period_name gl_period_statuses.period_name%TYPE;
1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
1444: l_period_fiscal_year NUMBER;
1445: l_begin_period NUMBER;

Line 1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;

1438: l_end_balance NUMBER;
1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;
1441: l_begin_period_name gl_period_statuses.period_name%TYPE;
1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
1444: l_period_fiscal_year NUMBER;
1445: l_begin_period NUMBER;
1446: l_end_period NUMBER := v_period_num;

Line 1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;
1441: l_begin_period_name gl_period_statuses.period_name%TYPE;
1442: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
1443: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
1444: l_period_fiscal_year NUMBER;
1445: l_begin_period NUMBER;
1446: l_end_period NUMBER := v_period_num;
1447: l_end_period_1 NUMBER ;

Line 1448: l_end_period_name_1 gl_period_statuses.period_name%TYPE;

1444: l_period_fiscal_year NUMBER;
1445: l_begin_period NUMBER;
1446: l_end_period NUMBER := v_period_num;
1447: l_end_period_1 NUMBER ;
1448: l_end_period_name_1 gl_period_statuses.period_name%TYPE;
1449: l_begin_period_1 NUMBER;
1450: l_begin_period_end_date DATE;
1451: l_end_period_end_date DATE := v_end_date;
1452: l_begin_period_1_end_date DATE;

Line 1468: l_period_year gl_period_statuses.period_name%TYPE;

1464: l_diff_amt NUMBER;
1465: l_diff_amt_tot NUMBER := 0;
1466: l_temp_amount NUMBER;
1467: l_ussgl_acct_num NUMBER;
1468: l_period_year gl_period_statuses.period_name%TYPE;
1469: l_amount NUMBER;
1470: l_end_period_num1 NUMBER;
1471: l_end_period_num2 NUMBER;
1472: l_ccid_gl_amt NUMBER;

Line 2723: FROM gl_period_statuses

2719: --
2720: --
2721: SELECT MIN(period_num)
2722: INTO g_period_num
2723: FROM gl_period_statuses
2724: WHERE ledger_id = v_sob
2725: AND period_year = v_period_fiscal_year
2726: AND adjustment_period_flag = 'N'
2727: AND application_id = '101' ;

Line 2732: FROM GL_PERIOD_STATUSES

2728: -- Added on 4/28/98 by Surya Padmanabhan
2729: -- Get the Period Number For the Quarter
2730: SELECT PERIOD_NUM
2731: INTO parm_gl_period_num
2732: FROM GL_PERIOD_STATUSES
2733: WHERE LEDGER_ID = v_sob
2734: AND PERIOD_YEAR = v_period_fiscal_year
2735: AND APPLICATION_ID = '101'
2736: AND CLOSING_STATUS IN ('O','C')

Line 2940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before gl_period_statuses ');

2936: c_total_balance_bud :=0;
2937: c_total_balance_nbfa :=0;
2938: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in balance_type_cursor :c_acct_number->'||c_acct_number);
2939:
2940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before gl_period_statuses ');
2941:
2942: SELECT start_date,
2943: end_date
2944: INTO beg_date,

Line 2946: FROM gl_period_statuses

2942: SELECT start_date,
2943: end_date
2944: INTO beg_date,
2945: close_date
2946: FROM gl_period_statuses
2947: WHERE period_year = p_fiscal_year
2948: AND period_num = report_period_num
2949: AND application_id = 101
2950: AND set_of_books_id = v_sob;

Line 3756: l_period_name_1 gl_period_statuses.period_name%TYPE;

3752: l_ignore INTEGER;
3753: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
3754: l_begin_balance NUMBER;
3755: l_end_balance NUMBER;
3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;
3758: l_begin_period_name gl_period_statuses.period_name%TYPE;
3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

Line 3757: l_period_name_2 gl_period_statuses.period_name%TYPE;

3753: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
3754: l_begin_balance NUMBER;
3755: l_end_balance NUMBER;
3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;
3758: l_begin_period_name gl_period_statuses.period_name%TYPE;
3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
3761: l_period_fiscal_year NUMBER;

Line 3758: l_begin_period_name gl_period_statuses.period_name%TYPE;

3754: l_begin_balance NUMBER;
3755: l_end_balance NUMBER;
3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;
3758: l_begin_period_name gl_period_statuses.period_name%TYPE;
3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
3761: l_period_fiscal_year NUMBER;
3762: l_begin_period NUMBER;

Line 3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;

3755: l_end_balance NUMBER;
3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;
3758: l_begin_period_name gl_period_statuses.period_name%TYPE;
3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
3761: l_period_fiscal_year NUMBER;
3762: l_begin_period NUMBER;
3763: l_end_period NUMBER := v_period_num;

Line 3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;
3758: l_begin_period_name gl_period_statuses.period_name%TYPE;
3759: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
3760: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
3761: l_period_fiscal_year NUMBER;
3762: l_begin_period NUMBER;
3763: l_end_period NUMBER := v_period_num;
3764: l_end_period_1 NUMBER ;

Line 3765: l_end_period_name_1 gl_period_statuses.period_name%TYPE;

3761: l_period_fiscal_year NUMBER;
3762: l_begin_period NUMBER;
3763: l_end_period NUMBER := v_period_num;
3764: l_end_period_1 NUMBER ;
3765: l_end_period_name_1 gl_period_statuses.period_name%TYPE;
3766: l_begin_period_1 NUMBER;
3767: l_begin_period_end_date DATE;
3768: l_end_period_end_date DATE := v_end_date;
3769: l_begin_period_1_end_date DATE;

Line 3785: l_period_year gl_period_statuses.period_name%TYPE;

3781: l_diff_amt NUMBER;
3782: l_diff_amt_tot NUMBER := 0;
3783: l_temp_amount NUMBER;
3784: l_ussgl_acct_num NUMBER;
3785: l_period_year gl_period_statuses.period_name%TYPE;
3786: l_amount NUMBER;
3787: l_end_period_num1 NUMBER;
3788: l_end_period_num2 NUMBER;
3789: l_ccid_gl_amt NUMBER;