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 202: FROM fv_sf224_temp fst

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 710: UPDATE fv_sf224_temp fst

706:
707: IF (p_error_code = g_SUCCESS) THEN
708: BEGIN
709: FORALL i IN l_rowid.first .. l_rowid.last
710: UPDATE fv_sf224_temp fst
711: SET fst.column_group = l_column_group(i),
712: fst.exception_category = l_exception_category(i),
713: fst.reported_month = l_reported_month(i),
714: fst.reported_flag = DECODE(l_reported_month(i), 'CURRENT', 'Y', 'CURRENT/PRIOR','Y','N'),

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

727: EXCEPTION
728: WHEN OTHERS THEN
729: p_error_code := g_FAILURE;
730: p_error_desc := SQLERRM;
731: l_location := l_module_name||'update_fv_sf224_temp';
732: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
733: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
734: END;
735: END IF;

Line 830: FROM fv_sf224_temp fst

826: je_source,
827: je_category,
828: document_number,
829: je_from_sla_flag
830: FROM fv_sf224_temp fst
831: WHERE ((fst.reported_month in ('CURRENT/PRIOR','CURRENT')
832: AND fst.reported_flag = 'Y'
833: AND fst.record_category = 'GLRECORD')
834: OR (exception_category IN ('INVALID_BA_GWA_SEC_COMBO', 'GWA_REPORTABLE')))

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

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

Line 849: DELETE fv_sf224_temp fst

845: END;
846:
847: IF (p_error_code = g_SUCCESS) THEN
848: BEGIN
849: DELETE fv_sf224_temp fst
850: WHERE fst.reported_month in ('CURRENT/PRIOR','CURRENT')
851: AND fst.reported_flag = 'Y'
852: AND fst.record_category = 'GLRECORD'
853: AND fst.set_of_books_id = p_set_of_books_id

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

856: EXCEPTION
857: WHEN OTHERS THEN
858: p_error_code := g_FAILURE;
859: p_error_desc := SQLERRM;
860: l_location := l_module_name||'delete_fv_sf224_temp';
861: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
862: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
863: END;
864: END IF;

Line 1796: l_string1 := 'INSERT INTO FV_SF224_TEMP

1792:
1793: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1794: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'in insert_sf224_batches procedure, before the insert.');
1795: END IF;
1796: l_string1 := 'INSERT INTO FV_SF224_TEMP
1797: (
1798: je_batch_id,
1799: fund_code,
1800: fund_description,

Line 2859: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;

2855: l_check_date DATE;
2856: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2857:
2858: -- References invoice_id populated by treasury confirmation procedure
2859: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2860: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2861: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2862:
2863: l_fund_code VARCHAR2(25);

Line 2860: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;

2856: l_payables_ia_paygroup FV_system_parameters_v.payables_ia_paygroup%type;
2857:
2858: -- References invoice_id populated by treasury confirmation procedure
2859: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2860: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2861: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2862:
2863: l_fund_code VARCHAR2(25);
2864: l_error_stage NUMBER;

Line 2861: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;

2857:
2858: -- References invoice_id populated by treasury confirmation procedure
2859: L_REFERENCE_4 FV_SF224_TEMP.REFERENCE_4%TYPE ;
2860: L_REFERENCE_5 FV_SF224_TEMP.REFERENCE_5%TYPE ;
2861: L_REFERENCE_6 FV_SF224_TEMP.REFERENCE_6%TYPE ;
2862:
2863: l_fund_code VARCHAR2(25);
2864: l_error_stage NUMBER;
2865: l_processed_flag VARCHAR2(1);

Line 2934: FROM fv_sf224_temp

2930: txn_category,
2931: je_source,
2932: je_category,
2933: je_from_sla_flag
2934: FROM fv_sf224_temp
2935: WHERE set_of_books_id = c_set_of_books_id
2936: AND sf224_processed_flag = 'N';
2937:
2938: CURSOR C2

Line 2961: FROM fv_sf224_temp

2957: c_je_from_sla_flag VARCHAR2
2958: )
2959: IS
2960: SELECT COUNT(*)
2961: FROM fv_sf224_temp
2962: WHERE je_batch_id = c_batch_id
2963: AND je_header_id = c_je_header_id
2964: 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)))
2965: = TO_CHAR(c_cash_receipt_id)

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

3790: FETCH Get_Count_Csr INTO vl_refund_cnt;
3791: CLOSE Get_Count_Csr;
3792: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3794: 'THE # OF RECORDS IN FV_SF224_TEMP '||VL_REFUND_CNT);
3795: END IF;
3796: IF (vl_refund_cnt = 0) THEN
3797: l_record_type := 'Receipt_refund';
3798: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4646: DELETE fv_sf224_temp fv

4642: IF l_reportable='X' or l_reportable='E' THEN
4643: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4644: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'deleting the section VI, VII exception ');
4645: END IF;
4646: DELETE fv_sf224_temp fv
4647: WHERE fv.je_line_num = L_JE_LINE_NUM
4648: AND fv.je_header_id = L_JE_HEADER_ID
4649: AND fv.exception_category IN ('DEFAULT_ALC','REPORTED_AS_MANUAL','NO_PA_ACCOMPLISH_DATE');
4650:

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

4662: Insert_New_Transaction(l_org_amount, 1);
4663:
4664: END IF;
4665: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING FV_SF224_TEMP WITH THE ALC_CODE');
4667: END IF;
4668:
4669:
4670: Update fv_sf224_temp

Line 4670: Update fv_sf224_temp

4666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING FV_SF224_TEMP WITH THE ALC_CODE');
4667: END IF;
4668:
4669:
4670: Update fv_sf224_temp
4671: set reported_month = l_reported_month,
4672: accomplish_date = l_accomplish_date,
4673: exception_category = l_exception_category,
4674: exception_section = l_exception_section,

Line 4704: update fv_sf224_temp

4700: updated_request_id = g_request_id
4701: where rowid = l_rowid;
4702:
4703: ELSE -- if accomplish_date
4704: update fv_sf224_temp
4705: set reported_flag = 'N',
4706: sf224_Processed_flag = 'Y',
4707: exception_exists = l_exception_exists,
4708: last_updated_by = g_user_id,

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

4712: where rowid = l_rowid ;
4713: END IF; -- if accomplish_date
4714:
4715: IF (sqlcode < 0) THEN
4716: error_buf := 'fv_sf224_temp table Update failed ';
4717: error_code := g_FAILURE;
4718: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error31', error_buf) ;
4719: RETURN;
4720: END IF;

Line 4905: INSERT INTO fv_sf224_temp

4901: l_module_name VARCHAR2(200) ;
4902:
4903: BEGIN
4904: l_module_name := g_module_name || 'Insert_new_transaction';
4905: INSERT INTO fv_sf224_temp
4906: (
4907: je_batch_id,
4908: fund_code,
4909: name,

Line 5077: DELETE fv_sf224_temp fst

5073: p_error_code := g_SUCCESS;
5074:
5075: BEGIN
5076: /* Delete all exceptions */
5077: DELETE fv_sf224_temp fst
5078: WHERE fst.set_of_books_id = p_set_of_books_id
5079: AND fst.exception_exists IS NULL
5080: AND fst.record_category = 'EXCEPTION';
5081: EXCEPTION

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

5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: p_error_code := g_FAILURE;
5084: p_error_desc := SQLERRM;
5085: l_location := l_module_name||'delete_fv_sf224_temp';
5086: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
5087: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
5088: END;
5089:

Line 5093: UPDATE fv_sf224_temp fst

5089:
5090: IF (p_error_code = g_SUCCESS) THEN
5091: BEGIN
5092: /* Reprocess all exceptions */
5093: UPDATE fv_sf224_temp fst
5094: SET fst.sf224_processed_flag = 'N',
5095: last_updated_by = g_user_id,
5096: last_update_date = g_sysdate,
5097: last_update_login = g_login_id,

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

5101: EXCEPTION
5102: WHEN OTHERS THEN
5103: p_error_code := g_FAILURE;
5104: p_error_desc := SQLERRM;
5105: l_location := l_module_name||'update_fv_sf224_temp';
5106: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
5107: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
5108: END;
5109: END IF;

Line 5140: FROM fv_sf224_temp tmp

5136: l_count NUMBER;
5137: l_alc_add_missing_count NUMBER := 0;
5138: CURSOR alc_code_csr IS
5139: SELECT DISTINCT tmp.alc_code
5140: FROM fv_sf224_temp tmp
5141: WHERE tmp.set_of_books_id = sob
5142: AND tmp.alc_code IS NOT NULL;
5143: BEGIN
5144: l_module_name := g_module_name || 'check_alc_address';