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 FV_SF224_TEMP

Line 47: L_NAME FV_SF224_TEMP.NAME%TYPE;

43: l_reportable VARCHAR2(1);
44:
45:
46: L_SF224_TYPE_CODE VARCHAR2(30);
47: L_NAME FV_SF224_TEMP.NAME%TYPE;
48: L_AMOUNT FV_SF224_TEMP.AMOUNT%TYPE;
49: L_D_R_FLAG FV_SF224_TEMP.D_R_FLAG%TYPE;
50: L_ACCOMPLISH_DATE DATE;
51:

Line 48: L_AMOUNT FV_SF224_TEMP.AMOUNT%TYPE;

44:
45:
46: L_SF224_TYPE_CODE VARCHAR2(30);
47: L_NAME FV_SF224_TEMP.NAME%TYPE;
48: L_AMOUNT FV_SF224_TEMP.AMOUNT%TYPE;
49: L_D_R_FLAG FV_SF224_TEMP.D_R_FLAG%TYPE;
50: L_ACCOMPLISH_DATE DATE;
51:
52: -- References Teasury confirmation Id

Line 49: L_D_R_FLAG FV_SF224_TEMP.D_R_FLAG%TYPE;

45:
46: L_SF224_TYPE_CODE VARCHAR2(30);
47: L_NAME FV_SF224_TEMP.NAME%TYPE;
48: L_AMOUNT FV_SF224_TEMP.AMOUNT%TYPE;
49: L_D_R_FLAG FV_SF224_TEMP.D_R_FLAG%TYPE;
50: L_ACCOMPLISH_DATE DATE;
51:
52: -- References Teasury confirmation Id
53: L_REFERENCE_1 FV_SF224_TEMP.REFERENCE_1%TYPE;

Line 53: L_REFERENCE_1 FV_SF224_TEMP.REFERENCE_1%TYPE;

49: L_D_R_FLAG FV_SF224_TEMP.D_R_FLAG%TYPE;
50: L_ACCOMPLISH_DATE DATE;
51:
52: -- References Teasury confirmation Id
53: L_REFERENCE_1 FV_SF224_TEMP.REFERENCE_1%TYPE;
54: L_REFERENCE_2 FV_SF224_TEMP.REFERENCE_2%TYPE;
55:
56: -- References Check_id
57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;

Line 54: L_REFERENCE_2 FV_SF224_TEMP.REFERENCE_2%TYPE;

50: L_ACCOMPLISH_DATE DATE;
51:
52: -- References Teasury confirmation Id
53: L_REFERENCE_1 FV_SF224_TEMP.REFERENCE_1%TYPE;
54: L_REFERENCE_2 FV_SF224_TEMP.REFERENCE_2%TYPE;
55:
56: -- References Check_id
57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;
58: L_REFERENCE_8 GL_JE_LINES.REFERENCE_8%TYPE; -- Invoice Dist Line Num

Line 57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;

53: L_REFERENCE_1 FV_SF224_TEMP.REFERENCE_1%TYPE;
54: L_REFERENCE_2 FV_SF224_TEMP.REFERENCE_2%TYPE;
55:
56: -- References Check_id
57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;
58: L_REFERENCE_8 GL_JE_LINES.REFERENCE_8%TYPE; -- Invoice Dist Line Num
59:
60: -- New Variable added as a part of bug fix #983941
61: L_REFERENCE_9 FV_SF224_TEMP.REFERENCE_9%TYPE ;

Line 61: L_REFERENCE_9 FV_SF224_TEMP.REFERENCE_9%TYPE ;

57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;
58: L_REFERENCE_8 GL_JE_LINES.REFERENCE_8%TYPE; -- Invoice Dist Line Num
59:
60: -- New Variable added as a part of bug fix #983941
61: L_REFERENCE_9 FV_SF224_TEMP.REFERENCE_9%TYPE ;
62:
63: -- A new vaiable added l_accomplish_attribute for Bug 1801069
64: l_accomplish_attribute VARCHAR2( 15);
65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;

Line 65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;

61: L_REFERENCE_9 FV_SF224_TEMP.REFERENCE_9%TYPE ;
62:
63: -- A new vaiable added l_accomplish_attribute for Bug 1801069
64: l_accomplish_attribute VARCHAR2( 15);
65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;
66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%TYPE ;
68: L_RECORD_CATEGORY FV_SF224_TEMP.RECORD_CATEGORY%TYPE ;
69: L_JE_HEADER_ID FV_SF224_TEMP.JE_HEADER_ID%TYPE ;

Line 66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;

62:
63: -- A new vaiable added l_accomplish_attribute for Bug 1801069
64: l_accomplish_attribute VARCHAR2( 15);
65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;
66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%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;

Line 67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%TYPE ;

63: -- A new vaiable added l_accomplish_attribute for Bug 1801069
64: l_accomplish_attribute VARCHAR2( 15);
65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;
66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%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:

Line 68: L_RECORD_CATEGORY FV_SF224_TEMP.RECORD_CATEGORY%TYPE ;

64: l_accomplish_attribute VARCHAR2( 15);
65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;
66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%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;

Line 69: L_JE_HEADER_ID FV_SF224_TEMP.JE_HEADER_ID%TYPE ;

65: L_JE_LINE_NUM FV_SF224_TEMP.JE_LINE_NUM%TYPE ;
66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%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;

Line 70: L_EXCEPTION_SECTION FV_SF224_TEMP.EXCEPTION_SECTION%TYPE;

66: L_REPORTED_FLAG FV_SF224_TEMP.REPORTED_FLAG%TYPE ;
67: L_EXCEPTION_EXISTS FV_SF224_TEMP.EXCEPTION_EXISTS%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;

Line 73: L_REPORTED_MONTH FV_SF224_TEMP.REPORTED_MONTH%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;
77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;

Line 74: L_EXCEPTION_CATEGORY FV_SF224_TEMP.EXCEPTION_CATEGORY%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;
77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;
78:

Line 76: L_TXN_CATEGORY FV_SF224_TEMP.TXN_CATEGORY%TYPE;

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;
77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;
78:
79: L_BATCH_ID FV_SF224_TEMP.JE_BATCH_ID%TYPE;
80: L_RECORD_TYPE VARCHAR2(30);

Line 79: L_BATCH_ID FV_SF224_TEMP.JE_BATCH_ID%TYPE;

75: L_COLUMN_GROUP NUMBER;
76: L_TXN_CATEGORY FV_SF224_TEMP.TXN_CATEGORY%TYPE;
77: L_BILLING_AGENCY_FUND FV_INTERAGENCY_FUNDS.BILLING_AGENCY_FUND%TYPE;
78:
79: L_BATCH_ID FV_SF224_TEMP.JE_BATCH_ID%TYPE;
80: L_RECORD_TYPE VARCHAR2(30);
81: L_IA_FLAG VARCHAR2(2);
82: L_OBLIGATION_DATE DATE;
83:

Line 96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;

92: x_name VARCHAR2(100);
93:
94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;
95: l_je_category GL_JE_HEADERS.JE_CATEGORY%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;

Line 203: FROM fv_sf224_temp fst

199: fst.actual_amount,
200: fst.reclass,
201: fst.reported_flag,
202: fst.je_from_sla_flag
203: FROM fv_sf224_temp fst
204: WHERE fst.set_of_books_id = c_set_of_books_id
205: AND fst.sf224_processed_flag = 'Y'
206: AND fst.alc_code = DECODE (c_alc_code, 'ALL', fst.alc_code, c_alc_code)
207: AND fst.end_period_date < c_end_date;

Line 220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;

216: l_tot_alc_supplemental NUMBER := 0;
217: l_tmp_supplemental_flag NUMBER;
218:
219: TYPE row_id_t IS TABLE OF rowid;
220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;
221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;

Line 221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;

217: l_tmp_supplemental_flag NUMBER;
218:
219: TYPE row_id_t IS TABLE OF rowid;
220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;
221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;

Line 222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;

218:
219: TYPE row_id_t IS TABLE OF rowid;
220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;
221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;

Line 223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;

219: TYPE row_id_t IS TABLE OF rowid;
220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;
221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;

Line 224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;

220: TYPE gl_period_t IS TABLE OF fv_sf224_temp.gl_period%TYPE;
221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;

Line 225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;

221: TYPE accomplish_date_t IS TABLE OF fv_sf224_temp.accomplish_date%TYPE;
222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;

Line 226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;

222: TYPE reported_month_t IS TABLE OF fv_sf224_temp.reported_month%TYPE;
223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;

Line 227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;

223: TYPE exception_category_t IS TABLE OF fv_sf224_temp.exception_category%TYPE;
224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;

Line 228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;

224: TYPE sf224_type_code_t IS TABLE OF fv_sf224_temp.sf224_type_code%TYPE;
225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;

Line 229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;

225: TYPE record_type_t IS TABLE OF fv_sf224_temp.record_type%TYPE;
226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;

Line 230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;

226: TYPE column_group_t IS TABLE OF fv_sf224_temp.column_group%TYPE;
227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;

Line 231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;

227: TYPE inter_agency_flag_t IS TABLE OF fv_sf224_temp.inter_agency_flag%TYPE;
228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;

Line 232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;

228: TYPE obligation_date_t IS TABLE OF fv_sf224_temp.obligation_date%TYPE;
229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;

Line 233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;

229: TYPE d_r_flag_t IS TABLE OF fv_sf224_temp.d_r_flag%TYPE;
230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;

Line 234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;

230: TYPE exception_section_t IS TABLE OF fv_sf224_temp.exception_section%TYPE;
231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;

Line 235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;

231: TYPE reported_gl_period_t IS TABLE OF fv_sf224_temp.reported_gl_period%TYPE;
232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;

Line 236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;

232: TYPE supplemental_flag_t IS TABLE OF fv_sf224_temp.supplemental_flag%TYPE;
233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;

Line 237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;

233: TYPE alc_code_t IS TABLE OF fv_sf224_temp.alc_code%TYPE;
234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;

Line 238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;

234: TYPE reference_2_t IS TABLE OF fv_sf224_temp.reference_2%TYPE;
235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;

Line 239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;

235: TYPE reference_3_t IS TABLE OF fv_sf224_temp.reference_3%TYPE;
236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;

Line 240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;

236: TYPE processed_flag_t IS TABLE OF fv_sf224_temp.processed_flag%TYPE;
237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;

Line 241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;

237: TYPE update_type_t IS TABLE OF fv_sf224_temp.update_type%TYPE;
238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;

Line 242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;

238: TYPE je_source_t IS TABLE OF fv_sf224_temp.je_source%TYPE;
239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;
246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;

Line 243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;

239: TYPE je_category_t IS TABLE OF fv_sf224_temp.je_category%TYPE;
240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;
246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;
247:

Line 244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;

240: TYPE txn_category_t IS TABLE OF fv_sf224_temp.txn_category%TYPE;
241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;
246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;
247:
248: l_rowid row_id_t;

Line 245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;

241: TYPE sign_number_t IS TABLE OF fv_sf224_temp.sign_number%TYPE;
242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;
246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;
247:
248: l_rowid row_id_t;
249: l_gl_period gl_period_t;

Line 246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;

242: TYPE amount_t IS TABLE OF fv_sf224_temp.amount%TYPE;
243: TYPE actual_amount_t IS TABLE OF fv_sf224_temp.actual_amount%TYPE;
244: TYPE reclass_t IS TABLE OF fv_sf224_temp.reclass%TYPE;
245: TYPE reported_flag_t IS TABLE OF fv_sf224_temp.reported_flag%TYPE;
246: TYPE je_from_sla_flag_t IS TABLE OF fv_sf224_temp.je_from_sla_flag%TYPE;
247:
248: l_rowid row_id_t;
249: l_gl_period gl_period_t;
250: l_accomplish_date accomplish_date_t;

Line 694: UPDATE fv_sf224_temp fst

690:
691: IF (p_error_code = g_SUCCESS) THEN
692: BEGIN
693: FORALL i IN l_rowid.first .. l_rowid.last
694: UPDATE fv_sf224_temp fst
695: SET fst.column_group = l_column_group(i),
696: fst.exception_category = l_exception_category(i),
697: fst.reported_month = l_reported_month(i),
698: fst.reported_flag = DECODE(l_reported_month(i), 'CURRENT', 'Y', 'CURRENT/PRIOR','Y','N'),

Line 715: l_location := l_module_name||'update_fv_sf224_temp';

711: EXCEPTION
712: WHEN OTHERS THEN
713: p_error_code := g_FAILURE;
714: p_error_desc := SQLERRM;
715: l_location := l_module_name||'update_fv_sf224_temp';
716: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
717: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
718: END;
719: END IF;

Line 814: FROM fv_sf224_temp fst

810: je_source,
811: je_category,
812: document_number,
813: je_from_sla_flag
814: FROM fv_sf224_temp fst
815: WHERE ((fst.reported_month in ('CURRENT/PRIOR','CURRENT')
816: AND fst.reported_flag = 'Y'
817: AND fst.record_category = 'GLRECORD')
818: OR (exception_category IN ('INVALID_BA_GWA_SEC_COMBO', 'GWA_REPORTABLE')))

Line 826: l_location := l_module_name||'insert_fv_sf224_temp';

822: EXCEPTION
823: WHEN OTHERS THEN
824: p_error_code := g_FAILURE;
825: p_error_desc := SQLERRM;
826: l_location := l_module_name||'insert_fv_sf224_temp';
827: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
828: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
829: END;
830:

Line 833: DELETE fv_sf224_temp fst

829: END;
830:
831: IF (p_error_code = g_SUCCESS) THEN
832: BEGIN
833: DELETE fv_sf224_temp fst
834: WHERE fst.reported_month in ('CURRENT/PRIOR','CURRENT')
835: AND fst.reported_flag = 'Y'
836: AND fst.record_category = 'GLRECORD'
837: AND fst.set_of_books_id = p_set_of_books_id

Line 844: l_location := l_module_name||'delete_fv_sf224_temp';

840: EXCEPTION
841: WHEN OTHERS THEN
842: p_error_code := g_FAILURE;
843: p_error_desc := SQLERRM;
844: l_location := l_module_name||'delete_fv_sf224_temp';
845: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
846: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
847: END;
848: END IF;

Line 1773: l_string1 := 'INSERT INTO FV_SF224_TEMP

1769:
1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1771: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'in insert_sf224_batches procedure, before the insert.');
1772: END IF;
1773: l_string1 := 'INSERT INTO FV_SF224_TEMP
1774: (
1775: je_batch_id,
1776: fund_code,
1777: fund_description,

Line 2731: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;

2727: l_check_date DATE;
2728: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2729:
2730: -- References invoice_id populated by treasury confirmation procedure
2731: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2732: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2733: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2734:
2735: l_fund_code VARCHAR2(25);

Line 2732: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;

2728: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2729:
2730: -- References invoice_id populated by treasury confirmation procedure
2731: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2732: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2733: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2734:
2735: l_fund_code VARCHAR2(25);
2736: l_error_stage NUMBER;

Line 2733: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;

2729:
2730: -- References invoice_id populated by treasury confirmation procedure
2731: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2732: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2733: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2734:
2735: l_fund_code VARCHAR2(25);
2736: l_error_stage NUMBER;
2737: l_processed_flag VARCHAR2(1);

Line 2806: FROM fv_sf224_temp

2802: txn_category,
2803: je_source,
2804: je_category,
2805: je_from_sla_flag
2806: FROM fv_sf224_temp
2807: WHERE set_of_books_id = c_set_of_books_id
2808: AND sf224_processed_flag = 'N';
2809:
2810: CURSOR C2

Line 2833: FROM fv_sf224_temp

2829: c_je_from_sla_flag VARCHAR2
2830: )
2831: IS
2832: SELECT COUNT(*)
2833: FROM fv_sf224_temp
2834: WHERE je_batch_id = c_batch_id
2835: AND je_header_id = c_je_header_id
2836: AND DECODE(c_je_from_sla_flag, 'Y', reference_2, DECODE(c_je_category,'Misc Receipts',reference_2, SUBSTR(reference_2,0,INSTR(reference_2,'C')-1)))
2837: = TO_CHAR(c_cash_receipt_id)

Line 3659: 'THE # OF RECORDS IN FV_SF224_TEMP '||VL_REFUND_CNT);

3655: FETCH Get_Count_Csr INTO vl_refund_cnt;
3656: CLOSE Get_Count_Csr;
3657: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3659: 'THE # OF RECORDS IN FV_SF224_TEMP '||VL_REFUND_CNT);
3660: END IF;
3661: IF (vl_refund_cnt = 0) THEN
3662: l_record_type := 'Receipt_refund';
3663: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4508: DELETE fv_sf224_temp fv

4504: IF l_reportable='X' or l_reportable='E' THEN
4505: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4506: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'deleting the section VI, VII exception ');
4507: END IF;
4508: DELETE fv_sf224_temp fv
4509: WHERE fv.je_line_num = L_JE_LINE_NUM
4510: AND fv.je_header_id = L_JE_HEADER_ID
4511: AND fv.exception_category IN ('DEFAULT_ALC','REPORTED_AS_MANUAL','NO_PA_ACCOMPLISH_DATE');
4512:

Line 4528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING FV_SF224_TEMP WITH THE ALC_CODE');

4524: Insert_New_Transaction(l_org_amount, 1);
4525:
4526: END IF;
4527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING FV_SF224_TEMP WITH THE ALC_CODE');
4529: END IF;
4530:
4531:
4532: Update fv_sf224_temp

Line 4532: Update fv_sf224_temp

4528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING FV_SF224_TEMP WITH THE ALC_CODE');
4529: END IF;
4530:
4531:
4532: Update fv_sf224_temp
4533: set reported_month = l_reported_month,
4534: accomplish_date = l_accomplish_date,
4535: exception_category = l_exception_category,
4536: exception_section = l_exception_section,

Line 4566: update fv_sf224_temp

4562: updated_request_id = g_request_id
4563: where rowid = l_rowid;
4564:
4565: ELSE -- if accomplish_date
4566: update fv_sf224_temp
4567: set reported_flag = 'N',
4568: sf224_Processed_flag = 'Y',
4569: exception_exists = l_exception_exists,
4570: last_updated_by = g_user_id,

Line 4578: error_buf := 'fv_sf224_temp table Update failed ';

4574: where rowid = l_rowid ;
4575: END IF; -- if accomplish_date
4576:
4577: IF (sqlcode < 0) THEN
4578: error_buf := 'fv_sf224_temp table Update failed ';
4579: error_code := g_FAILURE;
4580: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error31', error_buf) ;
4581: RETURN;
4582: END IF;

Line 4767: INSERT INTO fv_sf224_temp

4763: l_module_name VARCHAR2(200) ;
4764:
4765: BEGIN
4766: l_module_name := g_module_name || 'Insert_new_transaction';
4767: INSERT INTO fv_sf224_temp
4768: (
4769: je_batch_id,
4770: fund_code,
4771: name,

Line 4939: DELETE fv_sf224_temp fst

4935: p_error_code := g_SUCCESS;
4936:
4937: BEGIN
4938: /* Delete all exceptions */
4939: DELETE fv_sf224_temp fst
4940: WHERE fst.set_of_books_id = p_set_of_books_id
4941: AND fst.exception_exists IS NULL
4942: AND fst.record_category = 'EXCEPTION';
4943: EXCEPTION

Line 4947: l_location := l_module_name||'delete_fv_sf224_temp';

4943: EXCEPTION
4944: WHEN OTHERS THEN
4945: p_error_code := g_FAILURE;
4946: p_error_desc := SQLERRM;
4947: l_location := l_module_name||'delete_fv_sf224_temp';
4948: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
4949: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4950: END;
4951:

Line 4955: UPDATE fv_sf224_temp fst

4951:
4952: IF (p_error_code = g_SUCCESS) THEN
4953: BEGIN
4954: /* Reprocess all exceptions */
4955: UPDATE fv_sf224_temp fst
4956: SET fst.sf224_processed_flag = 'N',
4957: last_updated_by = g_user_id,
4958: last_update_date = g_sysdate,
4959: last_update_login = g_login_id,

Line 4967: l_location := l_module_name||'update_fv_sf224_temp';

4963: EXCEPTION
4964: WHEN OTHERS THEN
4965: p_error_code := g_FAILURE;
4966: p_error_desc := SQLERRM;
4967: l_location := l_module_name||'update_fv_sf224_temp';
4968: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
4969: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4970: END;
4971: END IF;

Line 5002: FROM fv_sf224_temp tmp

4998: l_count NUMBER;
4999: l_alc_add_missing_count NUMBER := 0;
5000: CURSOR alc_code_csr IS
5001: SELECT DISTINCT tmp.alc_code
5002: FROM fv_sf224_temp tmp
5003: WHERE tmp.set_of_books_id = sob
5004: AND tmp.alc_code IS NOT NULL;
5005: BEGIN
5006: l_module_name := g_module_name || 'check_alc_address';