APPS.IGF_GR_RFMS_BATCH_PKG dependencies on IGF_GR_RFMS_BATCH_ALL

Line 5: old_references igf_gr_rfms_batch_all%ROWTYPE;

1: PACKAGE BODY igf_gr_rfms_batch_pkg AS
2: /* $Header: IGFGI15B.pls 115.6 2002/11/28 14:18:45 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_batch_all%ROWTYPE;
6: new_references igf_gr_rfms_batch_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_rfms_batch_all%ROWTYPE;

2: /* $Header: IGFGI15B.pls 115.6 2002/11/28 14:18:45 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_batch_all%ROWTYPE;
6: new_references igf_gr_rfms_batch_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 38: FROM igf_gr_rfms_batch_all

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

Line 98: FROM igf_gr_rfms_batch_all

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

Line 248: FROM igf_gr_rfms_batch_all

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR c IS
247: SELECT rowid
248: FROM igf_gr_rfms_batch_all
249: WHERE rfmb_id = x_rfmb_id;
250:
251: x_last_update_date DATE;
252: x_last_updated_by NUMBER;

Line 258: l_org_id igf_gr_rfms_batch_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

254: x_request_id NUMBER;
255: x_program_id NUMBER;
256: x_program_application_id NUMBER;
257: x_program_update_date DATE;
258: l_org_id igf_gr_rfms_batch_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
259:
260: BEGIN
261:
262: x_last_update_date := SYSDATE;

Line 315: INSERT INTO igf_gr_rfms_batch_all (

311: x_last_updated_by => x_last_updated_by,
312: x_last_update_login => x_last_update_login
313: );
314:
315: INSERT INTO igf_gr_rfms_batch_all (
316: rfmb_id,
317: batch_id,
318: data_rec_length,
319: ope_id,

Line 399: FROM igf_gr_rfms_batch_all

395: rfms_process_dt,
396: rfms_ack_dt,
397: rfms_ack_batch_id,
398: reject_reason
399: FROM igf_gr_rfms_batch_all
400: WHERE rowid = x_rowid
401: FOR UPDATE NOWAIT;
402:
403: tlinfo c1%ROWTYPE;

Line 524: UPDATE igf_gr_rfms_batch_all

520: x_program_update_date := SYSDATE;
521: END IF;
522: END IF;
523:
524: UPDATE igf_gr_rfms_batch_all
525: SET
526: batch_id = new_references.batch_id,
527: data_rec_length = new_references.data_rec_length,
528: ope_id = new_references.ope_id,

Line 574: FROM igf_gr_rfms_batch_all

570: || (reverse chronological order - newest change first)
571: */
572: CURSOR c1 IS
573: SELECT rowid
574: FROM igf_gr_rfms_batch_all
575: WHERE rfmb_id = x_rfmb_id;
576:
577: BEGIN
578:

Line 637: DELETE FROM igf_gr_rfms_batch_all

633: p_action => 'DELETE',
634: x_rowid => x_rowid
635: );
636:
637: DELETE FROM igf_gr_rfms_batch_all
638: WHERE rowid = x_rowid;
639:
640: IF (SQL%NOTFOUND) THEN
641: RAISE NO_DATA_FOUND;