APPS.IGF_AP_ISIR_BATCHES_PKG dependencies on IGF_AP_ISIR_BATCHES_ALL

Line 5: old_references igf_ap_isir_batches_all%ROWTYPE;

1: PACKAGE BODY igf_ap_isir_batches_pkg AS
2: /* $Header: IGFAI06B.pls 115.7 2002/11/28 13:55:14 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_isir_batches_all%ROWTYPE;
6: new_references igf_ap_isir_batches_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_isir_batches_all%ROWTYPE;

2: /* $Header: IGFAI06B.pls 115.7 2002/11/28 13:55:14 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_isir_batches_all%ROWTYPE;
6: new_references igf_ap_isir_batches_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGF_AP_ISIR_BATCHES_ALL

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGF_AP_ISIR_BATCHES_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 98: FROM igf_ap_isir_batches_all

94: || (reverse chronological order - newest change first)
95: */
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM igf_ap_isir_batches_all
99: WHERE batch_number = x_batch_number
100: FOR UPDATE NOWAIT;
101:
102: lv_rowid cur_rowid%RowType;

Line 217: FROM igf_ap_isir_batches_all

213: || (reverse chronological order - newest change first)
214: */
215: CURSOR c IS
216: SELECT rowid
217: FROM igf_ap_isir_batches_all
218: WHERE batch_number = x_batch_number;
219:
220: x_last_update_date DATE;
221: x_last_updated_by NUMBER;

Line 224: l_org_id igf_ap_isir_batches_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

220: x_last_update_date DATE;
221: x_last_updated_by NUMBER;
222: x_last_update_login NUMBER;
223:
224: l_org_id igf_ap_isir_batches_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
225:
226: BEGIN
227:
228: x_last_update_date := SYSDATE;

Line 266: INSERT INTO igf_ap_isir_batches_all (

262: x_last_updated_by => x_last_updated_by,
263: x_last_update_login => x_last_update_login
264: );
265:
266: INSERT INTO igf_ap_isir_batches_all (
267: batch_number,
268: batch_year,
269: batch_type,
270: batch_count,

Line 343: FROM igf_ap_isir_batches_all

339: err_rec_count,
340: not_on_db_count,
341: batch_creation_date,
342: org_id
343: FROM igf_ap_isir_batches_all
344: WHERE rowid = x_rowid
345: FOR UPDATE NOWAIT;
346:
347: tlinfo c1%ROWTYPE;

Line 451: UPDATE igf_ap_isir_batches_all

447: x_last_updated_by => x_last_updated_by,
448: x_last_update_login => x_last_update_login
449: );
450:
451: UPDATE igf_ap_isir_batches_all
452: SET
453: batch_year = new_references.batch_year,
454: batch_type = new_references.batch_type,
455: batch_count = new_references.batch_count,

Line 497: FROM igf_ap_isir_batches_all

493: || (reverse chronological order - newest change first)
494: */
495: CURSOR c1 IS
496: SELECT rowid
497: FROM igf_ap_isir_batches_all
498: WHERE batch_number = x_batch_number;
499:
500: BEGIN
501:

Line 560: DELETE FROM igf_ap_isir_batches_all

556: p_action => 'DELETE',
557: x_rowid => x_rowid
558: );
559:
560: DELETE FROM igf_ap_isir_batches_all
561: WHERE rowid = x_rowid;
562:
563: IF (SQL%NOTFOUND) THEN
564: RAISE NO_DATA_FOUND;