APPS.PA_EXPENDITURE_GROUPS_PKG dependencies on PA_EXPENDITURES

Line 194: cursor expnds is select expenditure_id from pa_expenditures

190: end if;
191:
192: -- cascade delete to expenditures.
193: DECLARE
194: cursor expnds is select expenditure_id from pa_expenditures
195: where expenditure_group = groups_rec.expenditure_group
196: for update of expenditure_id nowait;
197: exp_rec expnds%rowtype;
198: BEGIN

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

207: -- delete award distribution lines..
208: --
209: gms_awards_dist_pkg.delete_adls(exp_rec.expenditure_id, NULL, 'EXP' ) ;
210:
211: pa_expenditures_pkg.delete_row (exp_rec.expenditure_id);
212: end if;
213: END LOOP;
214:
215: EXCEPTION

Line 262: cursor lock_exps is select expenditure_id from pa_expenditures

258:
259: cursor c_orig_group is select * from pa_expenditure_groups
260: where expenditure_group = x_expenditure_group;
261:
262: cursor lock_exps is select expenditure_id from pa_expenditures
263: where expenditure_group = x_expenditure_group
264: for update of expenditure_status_code nowait;
265:
266: x_orig_group c_orig_group%rowtype;

Line 293: update pa_expenditures

289: where expenditure_group = x_expenditure_group;
290: */
291:
292: /* Bug 3754869 : Removed the literals and added bind variables.
293: update pa_expenditures
294: set expenditure_status_code = 'APPROVED'
295: where expenditure_group = x_expenditure_group;
296: */
297:

Line 325: cursor lock_exps is select expenditure_id from pa_expenditures

321: cursor c_orig_group is select * from pa_expenditure_groups
322: where expenditure_group = x_expenditure_group
323: for update of expenditure_group_status_code nowait;
324:
325: cursor lock_exps is select expenditure_id from pa_expenditures
326: where expenditure_group = x_expenditure_group
327: for update of expenditure_status_code nowait;
328:
329: x_orig_group c_orig_group%rowtype;

Line 358: update pa_expenditures

354: where expenditure_group = x_expenditure_group;
355: */
356:
357: /* Bug 3754869 : Removed the literals and added bind variables.
358: update pa_expenditures
359: set expenditure_status_code = 'WORKING'
360: where expenditure_group = x_expenditure_group;
361: */
362:

Line 432: (select expenditure_id from pa_expenditures

428: DECLARE
429: cursor count_ei is
430: select count(*) from pa_expenditure_items
431: where expenditure_id in
432: (select expenditure_id from pa_expenditures
433: where expenditure_group = x_expenditure_group);
434: x_count NUMBER;
435: BEGIN
436: open count_ei;

Line 451: select count(*) from pa_expenditures

447: -- If control amounts were entered, make sure they match
448: -- the actual amounts.
449: DECLARE
450: cursor count_exp is
451: select count(*) from pa_expenditures
452: where expenditure_group = x_expenditure_group;
453:
454: cursor totals is
455: select sum(quantity)

Line 458: (select expenditure_id from pa_expenditures

454: cursor totals is
455: select sum(quantity)
456: from pa_expenditure_items
457: where expenditure_id in
458: (select expenditure_id from pa_expenditures
459: where expenditure_group = x_expenditure_group);
460:
461: x_count NUMBER;
462: x_total NUMBER;

Line 497: select expenditure_id from pa_expenditures

493: DECLARE
494: cursor null_qty is
495: select count(*) from pa_expenditure_items
496: where expenditure_id in (
497: select expenditure_id from pa_expenditures
498: where expenditure_group = x_expenditure_group )
499: and quantity is null ;
500: number_of_nulls NUMBER ;
501: BEGIN

Line 521: cursor lock_exps is select expenditure_id from pa_expenditures

517: procedure execute_submit (x_expenditure_group VARCHAR2,
518: x_err_code in out NOCOPY NUMBER,
519: x_return_status in out NOCOPY VARCHAR2) is
520:
521: cursor lock_exps is select expenditure_id from pa_expenditures
522: where expenditure_group = x_expenditure_group
523: for update of expenditure_status_code nowait;
524:
525: x_exps lock_exps%rowtype;

Line 540: update pa_expenditures

536: where expenditure_group = x_expenditure_group;
537: */
538:
539: /* Bug 3754869 : Removed the literals and added bind variables.
540: update pa_expenditures
541: set expenditure_status_code = 'SUBMITTED'
542: where expenditure_group = x_expenditure_group;
543: */
544:

Line 573: update pa_expenditures

569: update pa_expenditure_groups
570: set expenditure_group_status_code = p_exp_grp_status_code
571: where expenditure_group = p_expenditure_group ;
572:
573: update pa_expenditures
574: set expenditure_status_code = p_exp_status_code
575: where expenditure_group = p_expenditure_group ;
576:
577: End;