APPS.PA_PURGE_BATCHES_PKG dependencies on PA_PURGE_BATCHES

Line 1: package body pa_purge_batches_pkg as

1: package body pa_purge_batches_pkg as
2: /* $Header: PAXARPBB.pls 120.2 2005/08/05 00:42:45 rgandhi noship $ */
3: procedure insert_row(x_rowid in out NOCOPY VARCHAR2,/*File.sql.39*/
4: x_purge_batch_id in out NOCOPY NUMBER, /*File.sql.39*/
5: x_batch_name in VARCHAR2,

Line 26: cursor c is select rowid from pa_purge_batches

22: x_purge_release in VARCHAR2,
23: x_user_id in NUMBER,
24: x_org_id in NUMBER) is
25:
26: cursor c is select rowid from pa_purge_batches
27: where purge_batch_id = x_purge_batch_id;
28: cursor get_id is select pa_purge_batches_s.nextval from dual ;
29: x_err_code NUMBER;
30: x_return_status VARCHAR2(630);

Line 28: cursor get_id is select pa_purge_batches_s.nextval from dual ;

24: x_org_id in NUMBER) is
25:
26: cursor c is select rowid from pa_purge_batches
27: where purge_batch_id = x_purge_batch_id;
28: cursor get_id is select pa_purge_batches_s.nextval from dual ;
29: x_err_code NUMBER;
30: x_return_status VARCHAR2(630);
31: l_purge_batch_id NUMBER := x_purge_batch_id;
32:

Line 41: insert into pa_purge_batches(purge_batch_id,

37: fetch get_id into x_purge_batch_id ;
38: close get_id ;
39: end if;
40:
41: insert into pa_purge_batches(purge_batch_id,
42: batch_name,
43: description,
44: batch_status_code,
45: active_closed_flag,

Line 129: update pa_purge_batches

125: x_user_id in NUMBER) is
126:
127: BEGIN
128:
129: update pa_purge_batches
130: set purge_batch_id = x_purge_batch_id,
131: batch_name = x_batch_name,
132: description = x_description,
133: batch_status_code = x_batch_status_code,

Line 166: from pa_purge_batches

162:
163: procedure delete_row (x_rowid in VARCHAR2) is
164: cursor get_batch is select batch_status_code,
165: purge_batch_id
166: from pa_purge_batches
167: where rowid = x_rowid;
168: batches_rec get_batch%rowtype;
169:
170: BEGIN

Line 216: delete from pa_purge_batches

212: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
213: app_exception.raise_exception;
214: END;
215:
216: delete from pa_purge_batches
217: where rowid = x_rowid;
218:
219:
220: END delete_row;

Line 250: select * from pa_purge_batches

246:
247: dummy NUMBER;
248:
249: CURSOR C is
250: select * from pa_purge_batches
251: where rowid = x_rowid
252: for update of purge_batch_id ;
253:
254: recinfo C%ROWTYPE ;

Line 313: END pa_purge_batches_pkg;

309:
310: ---------------------------------------------------------------------------
311:
312:
313: END pa_purge_batches_pkg;