APPS.IGF_GR_RFMS_DISB_PKG dependencies on IGF_GR_RFMS_DISB_ALL

Line 5: old_references igf_gr_rfms_disb_all%ROWTYPE;

1: PACKAGE BODY igf_gr_rfms_disb_pkg AS
2: /* $Header: IGFGI06B.pls 115.13 2002/11/28 14:16:27 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_disb_all%ROWTYPE;
6: new_references igf_gr_rfms_disb_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_rfms_disb_all%ROWTYPE;

2: /* $Header: IGFGI06B.pls 115.13 2002/11/28 14:16:27 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_rfms_disb_all%ROWTYPE;
6: new_references igf_gr_rfms_disb_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 46: FROM IGF_GR_RFMS_DISB_ALL

42: */
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGF_GR_RFMS_DISB_ALL
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 176: FROM igf_gr_rfms_disb_all

172: || (reverse chronological order - newest change first)
173: */
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM igf_gr_rfms_disb_all
177: WHERE rfmd_id = x_rfmd_id
178: FOR UPDATE NOWAIT;
179:
180: lv_rowid cur_rowid%RowType;

Line 212: FROM igf_gr_rfms_disb_all

208: || (reverse chronological order - newest change first)
209: */
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM igf_gr_rfms_disb_all
213: WHERE disb_ref_num = x_disb_ref_num
214: AND origination_id = x_origination_id
215: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
216:

Line 248: FROM igf_gr_rfms_disb_all

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM igf_gr_rfms_disb_all
249: WHERE ((rfmb_id = x_rfmb_id));
250:
251: lv_rowid cur_rowid%RowType;
252:

Line 283: FROM igf_gr_rfms_disb_all

279: || (reverse chronological order - newest change first)
280: */
281: CURSOR cur_rowid IS
282: SELECT rowid
283: FROM igf_gr_rfms_disb_all
284: WHERE ((origination_id = x_origination_id));
285:
286: lv_rowid cur_rowid%RowType;
287:

Line 435: FROM igf_gr_rfms_disb_all

431: || (reverse chronological order - newest change first)
432: */
433: CURSOR c IS
434: SELECT rowid
435: FROM igf_gr_rfms_disb_all
436: WHERE rfmd_id = x_rfmd_id;
437:
438: x_last_update_date DATE;
439: x_last_updated_by NUMBER;

Line 445: l_org_id igf_gr_rfms_disb_all.org_id%TYPE;

441: x_request_id NUMBER;
442: x_program_id NUMBER;
443: x_program_application_id NUMBER;
444: x_program_update_date DATE;
445: l_org_id igf_gr_rfms_disb_all.org_id%TYPE;
446:
447: BEGIN
448:
449: l_org_id := igf_aw_gen.get_org_id;

Line 512: INSERT INTO igf_gr_rfms_disb_all (

508: x_ed_use_flags => x_ed_use_flags
509:
510: );
511:
512: INSERT INTO igf_gr_rfms_disb_all (
513: rfmd_id,
514: origination_id,
515: disb_ref_num,
516: disb_dt,

Line 628: FROM igf_gr_rfms_disb_all

624: accpt_pymt_prd_start_dt,
625: edit_code,
626: rfmb_id,
627: ed_use_flags
628: FROM igf_gr_rfms_disb_all
629: WHERE rowid = x_rowid
630: FOR UPDATE NOWAIT;
631:
632: tlinfo c1%ROWTYPE;

Line 777: UPDATE igf_gr_rfms_disb_all

773: x_program_update_date := SYSDATE;
774: END IF;
775: END IF;
776:
777: UPDATE igf_gr_rfms_disb_all
778: SET
779: origination_id = new_references.origination_id,
780: disb_ref_num = new_references.disb_ref_num,
781: disb_dt = new_references.disb_dt,

Line 843: FROM igf_gr_rfms_disb_all

839: || (reverse chronological order - newest change first)
840: */
841: CURSOR c1 IS
842: SELECT rowid
843: FROM igf_gr_rfms_disb_all
844: WHERE rfmd_id = x_rfmd_id;
845:
846: BEGIN
847:

Line 922: DELETE FROM igf_gr_rfms_disb_all

918: p_action => 'DELETE',
919: x_rowid => x_rowid
920: );
921:
922: DELETE FROM igf_gr_rfms_disb_all
923: WHERE rowid = x_rowid;
924:
925: IF (SQL%NOTFOUND) THEN
926: RAISE NO_DATA_FOUND;