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_EXPENDITURE_GROUPS

Line 1: package body pa_expenditure_groups_pkg as

1: package body pa_expenditure_groups_pkg as
2: /* $Header: PAXTGRPB.pls 120.3 2005/08/16 02:57:34 vthakkar noship $ */
3:
4: -- forward declarations
5: procedure check_submit_allowed (x_expenditure_group in VARCHAR2,

Line 36: cursor c is select rowid from pa_expenditure_groups

32: x_period_accrual_flag in VARCHAR2,
33: P_Org_Id in NUMBER) -- 12i MOAC changes
34: is
35:
36: cursor c is select rowid from pa_expenditure_groups
37: where expenditure_group = x_expenditure_group;
38: x_err_code NUMBER;
39: x_return_status VARCHAR2(630);
40:

Line 43: insert into pa_expenditure_groups (

39: x_return_status VARCHAR2(630);
40:
41: BEGIN
42:
43: insert into pa_expenditure_groups (
44: expenditure_group,
45: last_update_date,
46: last_updated_by ,
47: creation_date,

Line 110: cursor c_orig_group is select * from pa_expenditure_groups

106: x_last_update_login in NUMBER,
107: x_transaction_source in VARCHAR2,
108: x_period_accrual_flag in VARCHAR2) is
109:
110: cursor c_orig_group is select * from pa_expenditure_groups
111: where rowid = x_rowid;
112:
113: x_orig_group c_orig_group%rowtype;
114: x_err_code NUMBER;

Line 126: update pa_expenditure_groups

122: -- update all the columns to the new values, except for the
123: -- expenditure_group_status_code column - we call on the appropriate
124: -- submit/rework/release procedures to handle that.
125:
126: update pa_expenditure_groups
127: set expenditure_group = x_expenditure_group,
128: last_update_date = x_last_update_date,
129: last_updated_by = x_last_updated_by,
130: expenditure_ending_date = x_expenditure_ending_date,

Line 178: from pa_expenditure_groups

174:
175: procedure delete_row (x_rowid in VARCHAR2) is
176: cursor get_group is select expenditure_group,
177: expenditure_group_status_code
178: from pa_expenditure_groups
179: where rowid = x_rowid;
180: groups_rec get_group%rowtype;
181:
182: BEGIN

Line 221: delete from pa_expenditure_groups

217: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
218: app_exception.raise_exception;
219: END;
220:
221: delete from pa_expenditure_groups
222: where rowid = x_rowid;
223:
224: END delete_row;
225:

Line 234: from pa_expenditure_groups

230: procedure lock_row (x_rowid in VARCHAR2) is
231: dummy NUMBER;
232: BEGIN
233: select 1 into dummy
234: from pa_expenditure_groups
235: where rowid = x_rowid
236: for update of expenditure_group nowait;
237: EXCEPTION
238:

Line 259: cursor c_orig_group is select * from pa_expenditure_groups

255: procedure release (x_expenditure_group in VARCHAR2,
256: x_err_code in out NOCOPY NUMBER,
257: x_return_status in out NOCOPY VARCHAR2) is
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

Line 287: update pa_expenditure_groups

283:
284: -- if it reaches here, the locks succeeded.
285:
286: /* Bug 3754875 : Removed the literals and added bind variables.
287: update pa_expenditure_groups
288: set expenditure_group_status_code = 'RELEASED'
289: where expenditure_group = x_expenditure_group;
290: */
291:

Line 321: cursor c_orig_group is select * from pa_expenditure_groups

317: procedure rework (x_expenditure_group in VARCHAR2,
318: x_err_code in out NOCOPY NUMBER,
319: x_return_status in out NOCOPY VARCHAR2) is
320:
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

Line 352: update pa_expenditure_groups

348: fetch lock_exps into x_exps;
349:
350: -- if it reaches here, the locks succeeded.
351: /* Bug 3754875 : Removed the literals and added bind variables.
352: update pa_expenditure_groups
353: set expenditure_group_status_code = 'WORKING'
354: where expenditure_group = x_expenditure_group;
355: */
356:

Line 402: cursor c_orig_group is select * from pa_expenditure_groups

398: procedure check_submit_allowed (x_expenditure_group in VARCHAR2,
399: x_err_code in out NOCOPY NUMBER,
400: x_return_status in out NOCOPY VARCHAR2) is
401:
402: cursor c_orig_group is select * from pa_expenditure_groups
403: where expenditure_group = x_expenditure_group;
404:
405: x_orig_group c_orig_group%rowtype;
406: BEGIN

Line 534: update pa_expenditure_groups

530: open lock_exps;
531: fetch lock_exps into x_exps;
532:
533: /* Bug 3754875 : Removed the literals and added bind variables.
534: update pa_expenditure_groups
535: set expenditure_group_status_code = 'SUBMITTED'
536: where expenditure_group = x_expenditure_group;
537: */
538:

Line 569: update pa_expenditure_groups

565: Is
566:
567: Begin
568:
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

Line 584: END pa_expenditure_groups_pkg;

580:
581:
582:
583:
584: END pa_expenditure_groups_pkg;