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 GL_PERIODS

Line 72: L_GL_PERIOD GL_PERIODS.PERIOD_NAME%TYPE;

68: L_RECORD_CATEGORY FV_SF224_TEMP.RECORD_CATEGORY%TYPE ;
69: L_JE_HEADER_ID FV_SF224_TEMP.JE_HEADER_ID%TYPE ;
70: L_EXCEPTION_SECTION FV_SF224_TEMP.EXCEPTION_SECTION%TYPE;
71:
72: L_GL_PERIOD GL_PERIODS.PERIOD_NAME%TYPE;
73: L_REPORTED_MONTH FV_SF224_TEMP.REPORTED_MONTH%TYPE;
74: L_EXCEPTION_CATEGORY FV_SF224_TEMP.EXCEPTION_CATEGORY%TYPE;
75: L_COLUMN_GROUP NUMBER;
76: L_TXN_CATEGORY FV_SF224_TEMP.TXN_CATEGORY%TYPE;

Line 100: l_txn_end_date GL_PERIODS.END_DATE%TYPE;

96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;
97: l_document_number VARCHAR2(100);
98:
99: --Define variable to store the end date for the transaction period
100: l_txn_end_date GL_PERIODS.END_DATE%TYPE;
101: l_txn_start_date GL_PERIODS.START_DATE%TYPE;
102:
103:
104: PROCEDURE process_sf224_transactions;

Line 101: l_txn_start_date GL_PERIODS.START_DATE%TYPE;

97: l_document_number VARCHAR2(100);
98:
99: --Define variable to store the end date for the transaction period
100: l_txn_end_date GL_PERIODS.END_DATE%TYPE;
101: l_txn_start_date GL_PERIODS.START_DATE%TYPE;
102:
103:
104: PROCEDURE process_sf224_transactions;
105: PROCEDURE Set_Exception(exp_type VARCHAR2) ;

Line 157: l_start_date gl_periods.start_date%TYPE;

153: l_location VARCHAR2(200);
154: l_exists VARCHAR2(2);
155: l_last_fetch BOOLEAN;
156: l_yr_start_date DATE;
157: l_start_date gl_periods.start_date%TYPE;
158: l_end_date gl_periods.end_date%TYPE;
159: l_start_date_2 gl_periods.start_date%TYPE;
160: l_end_date_2 gl_periods.end_date%TYPE;
161: l_cash_receipt_id NUMBER;

Line 158: l_end_date gl_periods.end_date%TYPE;

154: l_exists VARCHAR2(2);
155: l_last_fetch BOOLEAN;
156: l_yr_start_date DATE;
157: l_start_date gl_periods.start_date%TYPE;
158: l_end_date gl_periods.end_date%TYPE;
159: l_start_date_2 gl_periods.start_date%TYPE;
160: l_end_date_2 gl_periods.end_date%TYPE;
161: l_cash_receipt_id NUMBER;
162: l_hi_date DATE := TO_DATE('12/31/9999', 'MM/DD/YYYY');

Line 159: l_start_date_2 gl_periods.start_date%TYPE;

155: l_last_fetch BOOLEAN;
156: l_yr_start_date DATE;
157: l_start_date gl_periods.start_date%TYPE;
158: l_end_date gl_periods.end_date%TYPE;
159: l_start_date_2 gl_periods.start_date%TYPE;
160: l_end_date_2 gl_periods.end_date%TYPE;
161: l_cash_receipt_id NUMBER;
162: l_hi_date DATE := TO_DATE('12/31/9999', 'MM/DD/YYYY');
163: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;

Line 160: l_end_date_2 gl_periods.end_date%TYPE;

156: l_yr_start_date DATE;
157: l_start_date gl_periods.start_date%TYPE;
158: l_end_date gl_periods.end_date%TYPE;
159: l_start_date_2 gl_periods.start_date%TYPE;
160: l_end_date_2 gl_periods.end_date%TYPE;
161: l_cash_receipt_id NUMBER;
162: l_hi_date DATE := TO_DATE('12/31/9999', 'MM/DD/YYYY');
163: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
164: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;