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 8: v_period_name gl_period_statuses.period_name%TYPE;

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

Line 40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;

36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
41: v_period_num gl_period_statuses.period_num%TYPE;
42: v_select1 VARCHAR2(32000);
43: v_select2 VARCHAR2(32000);
44: v_select3 VARCHAR2(32000);

Line 41: v_period_num gl_period_statuses.period_num%TYPE;

37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
41: v_period_num gl_period_statuses.period_num%TYPE;
42: v_select1 VARCHAR2(32000);
43: v_select2 VARCHAR2(32000);
44: v_select3 VARCHAR2(32000);
45: v_select4 VARCHAR2(32000);

Line 63: v_begin_period_name gl_period_statuses.period_name%TYPE;

59: v_glbal_curid INTEGER;
60: v_glbal_grpby_curid INTEGER;
61:
62: v_begin_period NUMBER;
63: v_begin_period_name gl_period_statuses.period_name%TYPE;
64: v_begin_period_end_date DATE;
65:
66: v_end_period NUMBER;
67: v_end_period_end_date DATE;

Line 69: v_begin_period_name_1 gl_period_statuses.period_name%TYPE;

65:
66: v_end_period NUMBER;
67: v_end_period_end_date DATE;
68: v_begin_period_1 NUMBER;
69: v_begin_period_name_1 gl_period_statuses.period_name%TYPE;
70: v_begin_period_1_end_date DATE;
71: v_end_period_1_end_date DATE;
72:
73: v_cy_gl_beg_bal NUMBER;

Line 172: FROM gl_period_statuses

168: END IF;
169:
170: SELECT trunc(end_date), period_num, period_year
171: INTO v_end_date, v_period_num, v_period_fiscal_year
172: FROM gl_period_statuses
173: WHERE ledger_id = v_sob
174: AND application_id = '101'
175: AND period_name = v_period_name;
176:

Line 784: FROM gl_period_statuses

780: -- Get period number and fiscal year being run for
781: l_stage := 2;
782: SELECT trunc(end_date), period_num, period_year, end_date
783: INTO v_end_date, v_period_num, v_period_fiscal_year, v_end_period_end_date
784: FROM gl_period_statuses
785: WHERE ledger_id = v_sob
786: AND application_id = '101'
787: AND period_name = v_period_name;
788:

Line 796: FROM gl_period_statuses

792: -- first non adjusting period of the current year
793: l_stage := 3;
794: SELECT period_num, period_name, end_date
795: INTO v_begin_period, v_begin_period_name, v_begin_period_end_date
796: FROM gl_period_statuses
797: WHERE ledger_id = v_sob
798: AND period_year = v_period_fiscal_year
799: AND adjustment_period_flag = 'N'
800: AND application_id = '101'

Line 803: FROM gl_period_statuses

799: AND adjustment_period_flag = 'N'
800: AND application_id = '101'
801: AND period_num =
802: (SELECT MIN(period_num)
803: FROM gl_period_statuses
804: WHERE ledger_id = v_sob
805: AND period_year = v_period_fiscal_year
806: AND adjustment_period_flag = 'N'
807: AND application_id = '101' );

Line 814: FROM gl_period_statuses

810: -- first non adjusting period of the prior year
811: l_stage := 4;
812: SELECT period_num, period_name, end_date
813: INTO v_begin_period_1, v_begin_period_name_1, v_begin_period_1_end_date
814: FROM gl_period_statuses
815: WHERE ledger_id = v_sob
816: AND period_year = v_period_fiscal_year-1
817: AND adjustment_period_flag = 'N'
818: AND application_id = '101'

Line 821: FROM gl_period_statuses

817: AND adjustment_period_flag = 'N'
818: AND application_id = '101'
819: AND period_num =
820: (SELECT MIN(period_num)
821: FROM gl_period_statuses
822: WHERE ledger_id = v_sob
823: AND period_year = v_period_fiscal_year-1
824: AND adjustment_period_flag = 'N'
825: AND application_id = '101') ;

Line 832: FROM gl_period_statuses

828: -- Get py period end date for the period being run
829: l_stage := 5;
830: SELECT end_date
831: INTO v_end_period_1_end_date
832: FROM gl_period_statuses
833: WHERE ledger_id = v_sob
834: AND period_year = v_period_fiscal_year-1
835: AND application_id = '101'
836: AND period_num = v_period_num;

Line 915: l_period_name_1 gl_period_statuses.period_name%TYPE;

911: l_ignore INTEGER;
912: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
913: l_begin_balance NUMBER;
914: l_end_balance NUMBER;
915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;
917: l_begin_period_name gl_period_statuses.period_name%TYPE;
918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

Line 916: l_period_name_2 gl_period_statuses.period_name%TYPE;

912: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
913: l_begin_balance NUMBER;
914: l_end_balance NUMBER;
915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;
917: l_begin_period_name gl_period_statuses.period_name%TYPE;
918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
920: l_period_fiscal_year NUMBER;

Line 917: l_begin_period_name gl_period_statuses.period_name%TYPE;

913: l_begin_balance NUMBER;
914: l_end_balance NUMBER;
915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;
917: l_begin_period_name gl_period_statuses.period_name%TYPE;
918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
920: l_period_fiscal_year NUMBER;
921: l_begin_period NUMBER;

Line 918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;

914: l_end_balance NUMBER;
915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;
917: l_begin_period_name gl_period_statuses.period_name%TYPE;
918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
920: l_period_fiscal_year NUMBER;
921: l_begin_period NUMBER;
922: l_end_period NUMBER := v_period_num;

Line 919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;

915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;
917: l_begin_period_name gl_period_statuses.period_name%TYPE;
918: l_begin_period_name_1 gl_period_statuses.period_name%TYPE;
919: l_begin_period_name_2 gl_period_statuses.period_name%TYPE;
920: l_period_fiscal_year NUMBER;
921: l_begin_period NUMBER;
922: l_end_period NUMBER := v_period_num;
923: l_end_period_1 NUMBER ;

Line 924: l_end_period_name_1 gl_period_statuses.period_name%TYPE;

920: l_period_fiscal_year NUMBER;
921: l_begin_period NUMBER;
922: l_end_period NUMBER := v_period_num;
923: l_end_period_1 NUMBER ;
924: l_end_period_name_1 gl_period_statuses.period_name%TYPE;
925: l_begin_period_1 NUMBER;
926: l_begin_period_end_date DATE;
927: l_end_period_end_date DATE := v_end_date;
928: l_begin_period_1_end_date DATE;

Line 944: l_period_year gl_period_statuses.period_name%TYPE;

940: l_diff_amt NUMBER;
941: l_diff_amt_tot NUMBER := 0;
942: l_temp_amount NUMBER;
943: l_ussgl_acct_num NUMBER;
944: l_period_year gl_period_statuses.period_name%TYPE;
945:
946: l_amount NUMBER;
947:
948: l_end_period_num1 NUMBER;