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.GMS_REPORT_SF425 dependencies on GMS_425_HISTORY

Line 13: from gms_425_history

9: ) IS
10:
11: CURSOR last_version_csr (p_award_id IN NUMBER) IS
12: select nvl(max(version),0)
13: from gms_425_history
14: where award_id = p_award_id
15: and status_code IN ('F');
16:
17: CURSOR last_version_details_csr (p_version_number IN NUMBER, p_award_id IN NUMBER) IS

Line 33: from gms_425_history

29: nvl(RECPT_SHARE_EXP_AMT,0) RECPT_SHARE_EXP_AMT,
30: nvl(TOTAL_FED_PRG_INC_EARN_AMT,0) TOTAL_FED_PRG_INC_EARN_AMT,
31: nvl(PRG_INC_EXP_DEDUCT_ALT_AMT,0) PRG_INC_EXP_DEDUCT_ALT_AMT,
32: nvl(PRG_INC_EXP_ADD_ALT_AMT,0) PRG_INC_EXP_ADD_ALT_AMT
33: from gms_425_history
34: where award_id = p_award_id
35: and status_code IN ('F')
36: and version = p_version_number;
37:

Line 168: l_status_code gms_425_history.status_code%type;

164: AND gbc.award_id = p_award_id
165: AND trunc(gbc.expenditure_item_date) <= trunc(p_report_end_date) -- added to get additional commitments
166: GROUP BY GBC.award_id) ;
167:
168: l_status_code gms_425_history.status_code%type;
169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;

Line 169: l_creation_date gms_425_history.creation_date%type;

165: AND trunc(gbc.expenditure_item_date) <= trunc(p_report_end_date) -- added to get additional commitments
166: GROUP BY GBC.award_id) ;
167:
168: l_status_code gms_425_history.status_code%type;
169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;

Line 170: l_created_by gms_425_history.created_by%type;

166: GROUP BY GBC.award_id) ;
167:
168: l_status_code gms_425_history.status_code%type;
169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;

Line 171: l_last_update_date gms_425_history.last_update_date%type;

167:
168: l_status_code gms_425_history.status_code%type;
169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;

Line 172: l_last_updated_by gms_425_history.last_updated_by%type;

168: l_status_code gms_425_history.status_code%type;
169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;

Line 173: l_last_update_login gms_425_history.last_update_login%type;

169: l_creation_date gms_425_history.creation_date%type;
170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;

Line 174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;

170: l_created_by gms_425_history.created_by%type;
171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;

Line 175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;

171: l_last_update_date gms_425_history.last_update_date%type;
172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;

Line 176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;

172: l_last_updated_by gms_425_history.last_updated_by%type;
173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;

Line 177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;

173: l_last_update_login gms_425_history.last_update_login%type;
174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;

Line 178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;

174: l_REPORT_TRN_ID gms_425_history.REPORT_TRN_ID%type;
175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;

Line 179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;

175: l_BASIS_OF_ACCNT_CODE gms_425_history.BASIS_OF_ACCNT_CODE%type;
176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;

Line 180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;

176: l_REPORT_TYPE_CODE gms_425_history.REPORT_TYPE_CODE%type;
177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;

Line 181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;

177: l_CASH_RECEIPTS_AMT gms_425_history.CASH_RECEIPTS_AMT%type;
178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;

Line 182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;

178: l_CASH_DISBURSEMENTS_AMT gms_425_history.CASH_DISBURSEMENTS_AMT%type;
179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;

Line 183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;

179: l_TOTAL_FED_FUNDS_AUTH_AMT gms_425_history.TOTAL_FED_FUNDS_AUTH_AMT%type;
180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;

Line 184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;

180: l_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type;
181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;

Line 185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;

181: l_FED_SHARE_OF_UNLIQ_OBL_AMT gms_425_history.FED_SHARE_OF_UNLIQ_OBL_AMT%type;
182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;

Line 186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;

182: l_TOTAL_RECPT_SHARE_REQ_AMT gms_425_history.TOTAL_RECPT_SHARE_REQ_AMT%type;
183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;

Line 187: l_REMARKS gms_425_history.REMARKS%type;

183: l_RECPT_SHARE_EXP_AMT gms_425_history.RECPT_SHARE_EXP_AMT%type;
184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;
191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;

Line 188: l_NAME gms_425_history.NAME%type;

184: l_TOTAL_FED_PRG_INC_EARN_AMT gms_425_history.TOTAL_FED_PRG_INC_EARN_AMT%type;
185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;
191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;
192:

Line 189: l_TELEPHONE gms_425_history.TELEPHONE%type;

185: l_PRG_INC_EXP_DEDUCT_ALT_AMT gms_425_history.PRG_INC_EXP_DEDUCT_ALT_AMT%type;
186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;
191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;
192:
193: l_EXPENSE_TRN_ID gms_425_expense.EXPENSE_TRN_ID%type;

Line 190: l_EMAIL gms_425_history.EMAIL%type;

186: l_PRG_INC_EXP_ADD_ALT_AMT gms_425_history.PRG_INC_EXP_ADD_ALT_AMT%type;
187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;
191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;
192:
193: l_EXPENSE_TRN_ID gms_425_expense.EXPENSE_TRN_ID%type;
194: l_INDIRECT_EXP_TYPE_CODE gms_425_expense.INDIRECT_EXP_TYPE_CODE%type;

Line 191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;

187: l_REMARKS gms_425_history.REMARKS%type;
188: l_NAME gms_425_history.NAME%type;
189: l_TELEPHONE gms_425_history.TELEPHONE%type;
190: l_EMAIL gms_425_history.EMAIL%type;
191: l_REPORT_SUBMIT_DATE gms_425_history.REPORT_SUBMIT_DATE%type;
192:
193: l_EXPENSE_TRN_ID gms_425_expense.EXPENSE_TRN_ID%type;
194: l_INDIRECT_EXP_TYPE_CODE gms_425_expense.INDIRECT_EXP_TYPE_CODE%type;
195: l_INDIRECT_EXP_RATE gms_425_expense.INDIRECT_EXP_RATE%type;

Line 201: l_TEMP_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type; /* bug 12760021 */

197: l_INDIRECT_EXP_PERIOD_TO gms_425_expense.INDIRECT_EXP_PERIOD_TO%type;
198: l_INDIRECT_EXP_BASE_AMT gms_425_expense.INDIRECT_EXP_BASE_AMT%type;
199: l_INDIRECT_EXP_FED_SHARE_AMT gms_425_expense.INDIRECT_EXP_FED_SHARE_AMT%type;
200:
201: l_TEMP_FED_SHARE_OF_EXP_AMT gms_425_history.FED_SHARE_OF_EXP_AMT%type; /* bug 12760021 */
202:
203: last_version_details_rec last_version_details_csr%ROWTYPE;
204: l_last_version NUMBER;
205: l_current_version NUMBER;

Line 218: Procedure insert_425_history (p_status_code IN gms_425_history.status_code%type) is

214: l_burden_cost NUMBER;
215: l_run_date DATE;
216:
217:
218: Procedure insert_425_history (p_status_code IN gms_425_history.status_code%type) is
219: Begin
220:
221: -- set the transaction id
222: select gms_425_history_report_id_s.nextval

Line 222: select gms_425_history_report_id_s.nextval

218: Procedure insert_425_history (p_status_code IN gms_425_history.status_code%type) is
219: Begin
220:
221: -- set the transaction id
222: select gms_425_history_report_id_s.nextval
223: into l_report_trn_id
224: from dual;
225:
226: insert into gms_425_history (

Line 226: insert into gms_425_history (

222: select gms_425_history_report_id_s.nextval
223: into l_report_trn_id
224: from dual;
225:
226: insert into gms_425_history (
227: REPORT_TRN_ID,
228: award_id,
229: version,
230: status_code,

Line 369: -- for gms_425_history

365: Begin
366:
367: --1. Basic defaults
368:
369: -- for gms_425_history
370: l_creation_date := trunc(sysdate);
371: l_created_by := fnd_global.user_id;
372: l_last_update_date := trunc(sysdate);
373: l_last_updated_by := fnd_global.user_id;