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_EXPENSE

Line 193: l_EXPENSE_TRN_ID gms_425_expense.EXPENSE_TRN_ID%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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
197: l_INDIRECT_EXP_PERIOD_TO gms_425_expense.INDIRECT_EXP_PERIOD_TO%type;

Line 194: l_INDIRECT_EXP_TYPE_CODE gms_425_expense.INDIRECT_EXP_TYPE_CODE%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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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;

Line 195: l_INDIRECT_EXP_RATE gms_425_expense.INDIRECT_EXP_RATE%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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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;

Line 196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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:

Line 197: l_INDIRECT_EXP_PERIOD_TO gms_425_expense.INDIRECT_EXP_PERIOD_TO%type;

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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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 */

Line 198: l_INDIRECT_EXP_BASE_AMT gms_425_expense.INDIRECT_EXP_BASE_AMT%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;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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:

Line 199: l_INDIRECT_EXP_FED_SHARE_AMT gms_425_expense.INDIRECT_EXP_FED_SHARE_AMT%type;

195: l_INDIRECT_EXP_RATE gms_425_expense.INDIRECT_EXP_RATE%type;
196: l_INDIRECT_EXP_PERIOD_FROM gms_425_expense.INDIRECT_EXP_PERIOD_FROM%type;
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;

Line 313: GMS_425_EXPENSE exp

309: INDIRECT_EXP_PERIOD_TO,
310: INDIRECT_EXP_BASE_AMT,
311: INDIRECT_EXP_FED_SHARE_AMT
312: FROM
313: GMS_425_EXPENSE exp
314: WHERE
315: exp.report_trn_id = p_last_report_trn_id;
316: Begin
317:

Line 322: select gms_425_expenses_id_s.nextval

318: -- loop through the previous versions expenses and insert same values again
319: FOR get_last_version_expenses_rec IN get_last_version_expenses_csr (p_last_report_trn_id) LOOP
320:
321: -- set the transaction id
322: select gms_425_expenses_id_s.nextval
323: into l_EXPENSE_TRN_ID
324: from dual;
325:
326: insert into gms_425_expense (

Line 326: insert into gms_425_expense (

322: select gms_425_expenses_id_s.nextval
323: into l_EXPENSE_TRN_ID
324: from dual;
325:
326: insert into gms_425_expense (
327: EXPENSE_TRN_ID,
328: REPORT_TRN_ID,
329: creation_date,
330: created_by,