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.PA_EXPENDITURE_GROUPS_PKG dependencies on PA_EXPENDITURES

Line 152: update pa_expenditures

148: app_exception.raise_exception;
149: end if;
150:
151: -- added the below update for the bug 12547691
152: update pa_expenditures
153: set last_update_date = x_last_update_date,
154: last_updated_by = x_last_updated_by,
155: last_update_login = x_last_update_login
156: where expenditure_group = x_expenditure_group ;

Line 168: update pa_expenditures

164: app_exception.raise_exception;
165: end if;
166:
167: -- added the below update for the bug 12547691
168: update pa_expenditures
169: set last_update_date = x_last_update_date,
170: last_updated_by = x_last_updated_by,
171: last_update_login = x_last_update_login
172: where expenditure_group = x_expenditure_group ;

Line 184: update pa_expenditures

180: app_exception.raise_exception;
181: end if;
182:
183: -- added the below update for the bug 12547691
184: update pa_expenditures
185: set last_update_date = x_last_update_date,
186: last_updated_by = x_last_updated_by,
187: last_update_login = x_last_update_login
188: where expenditure_group = x_expenditure_group ;

Line 218: cursor expnds is select expenditure_id from pa_expenditures

214: end if;
215:
216: -- cascade delete to expenditures.
217: DECLARE
218: cursor expnds is select expenditure_id from pa_expenditures
219: where expenditure_group = groups_rec.expenditure_group
220: for update of expenditure_id nowait;
221: exp_rec expnds%rowtype;
222: BEGIN

Line 235: pa_expenditures_pkg.delete_row (exp_rec.expenditure_id);

231: -- delete award distribution lines..
232: --
233: gms_awards_dist_pkg.delete_adls(exp_rec.expenditure_id, NULL, 'EXP' ) ;
234:
235: pa_expenditures_pkg.delete_row (exp_rec.expenditure_id);
236: end if;
237: END LOOP;
238:
239: EXCEPTION

Line 286: cursor lock_exps is select expenditure_id from pa_expenditures

282:
283: cursor c_orig_group is select * from pa_expenditure_groups
284: where expenditure_group = x_expenditure_group;
285:
286: cursor lock_exps is select expenditure_id from pa_expenditures
287: where expenditure_group = x_expenditure_group
288: for update of expenditure_status_code nowait;
289:
290: x_orig_group c_orig_group%rowtype;

Line 317: update pa_expenditures

313: where expenditure_group = x_expenditure_group;
314: */
315:
316: /* Bug 3754869 : Removed the literals and added bind variables.
317: update pa_expenditures
318: set expenditure_status_code = 'APPROVED'
319: where expenditure_group = x_expenditure_group;
320: */
321:

Line 349: cursor lock_exps is select expenditure_id from pa_expenditures

345: cursor c_orig_group is select * from pa_expenditure_groups
346: where expenditure_group = x_expenditure_group
347: for update of expenditure_group_status_code nowait;
348:
349: cursor lock_exps is select expenditure_id from pa_expenditures
350: where expenditure_group = x_expenditure_group
351: for update of expenditure_status_code nowait;
352:
353: x_orig_group c_orig_group%rowtype;

Line 382: update pa_expenditures

378: where expenditure_group = x_expenditure_group;
379: */
380:
381: /* Bug 3754869 : Removed the literals and added bind variables.
382: update pa_expenditures
383: set expenditure_status_code = 'WORKING'
384: where expenditure_group = x_expenditure_group;
385: */
386:

Line 456: (select expenditure_id from pa_expenditures

452: DECLARE
453: cursor count_ei is
454: select count(*) from pa_expenditure_items
455: where expenditure_id in
456: (select expenditure_id from pa_expenditures
457: where expenditure_group = x_expenditure_group);
458: x_count NUMBER;
459: BEGIN
460: open count_ei;

Line 475: select count(*) from pa_expenditures

471: -- If control amounts were entered, make sure they match
472: -- the actual amounts.
473: DECLARE
474: cursor count_exp is
475: select count(*) from pa_expenditures
476: where expenditure_group = x_expenditure_group;
477:
478: cursor totals is
479: select sum(quantity)

Line 482: (select expenditure_id from pa_expenditures

478: cursor totals is
479: select sum(quantity)
480: from pa_expenditure_items
481: where expenditure_id in
482: (select expenditure_id from pa_expenditures
483: where expenditure_group = x_expenditure_group);
484:
485: x_count NUMBER;
486: x_total NUMBER;

Line 521: select expenditure_id from pa_expenditures

517: DECLARE
518: cursor null_qty is
519: select count(*) from pa_expenditure_items
520: where expenditure_id in (
521: select expenditure_id from pa_expenditures
522: where expenditure_group = x_expenditure_group )
523: and quantity is null ;
524: number_of_nulls NUMBER ;
525: BEGIN

Line 545: cursor lock_exps is select expenditure_id from pa_expenditures

541: procedure execute_submit (x_expenditure_group VARCHAR2,
542: x_err_code in out NOCOPY NUMBER,
543: x_return_status in out NOCOPY VARCHAR2) is
544:
545: cursor lock_exps is select expenditure_id from pa_expenditures
546: where expenditure_group = x_expenditure_group
547: for update of expenditure_status_code nowait;
548:
549: x_exps lock_exps%rowtype;

Line 564: update pa_expenditures

560: where expenditure_group = x_expenditure_group;
561: */
562:
563: /* Bug 3754869 : Removed the literals and added bind variables.
564: update pa_expenditures
565: set expenditure_status_code = 'SUBMITTED'
566: where expenditure_group = x_expenditure_group;
567: */
568:

Line 597: update pa_expenditures

593: update pa_expenditure_groups
594: set expenditure_group_status_code = p_exp_grp_status_code
595: where expenditure_group = p_expenditure_group ;
596:
597: update pa_expenditures
598: set expenditure_status_code = p_exp_status_code
599: where expenditure_group = p_expenditure_group ;
600:
601: End;