APPS.IGF_AW_FUND_PRG_PKG dependencies on IGF_AW_FUND_PRG

Line 1: PACKAGE BODY igf_aw_fund_prg_pkg AS

1: PACKAGE BODY igf_aw_fund_prg_pkg AS
2: /* $Header: IGFWI47B.pls 115.2 2002/11/28 12:22:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_prg_all%ROWTYPE;

Line 5: old_references igf_aw_fund_prg_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fund_prg_pkg AS
2: /* $Header: IGFWI47B.pls 115.2 2002/11/28 12:22:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_prg_all%ROWTYPE;
6: new_references igf_aw_fund_prg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fund_prg_all%ROWTYPE;

2: /* $Header: IGFWI47B.pls 115.2 2002/11/28 12:22:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_prg_all%ROWTYPE;
6: new_references igf_aw_fund_prg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM igf_aw_fund_prg_all

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igf_aw_fund_prg_all
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 140: FROM igf_aw_fund_prg_all

136: || (reverse chronological order - newest change first)
137: */
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM igf_aw_fund_prg_all
141: WHERE fprg_id = x_fprg_id
142: FOR UPDATE NOWAIT;
143:
144: lv_rowid cur_rowid%RowType;

Line 177: FROM igf_aw_fund_prg

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igf_aw_fund_prg
178: WHERE fund_id = x_fund_id
179: AND course_cd = x_course_cd
180: AND version_number = x_version_number
181: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 214: FROM igf_aw_fund_prg_all

210: || (reverse chronological order - newest change first)
211: */
212: CURSOR cur_rowid IS
213: SELECT rowid
214: FROM igf_aw_fund_prg_all
215: WHERE ((fund_id = x_fund_id));
216:
217: lv_rowid cur_rowid%RowType;
218:

Line 327: FROM igf_aw_fund_prg_all

323: || (reverse chronological order - newest change first)
324: */
325: CURSOR c IS
326: SELECT rowid
327: FROM igf_aw_fund_prg_all
328: WHERE fprg_id = x_fprg_id;
329:
330: x_last_update_date DATE;
331: x_last_updated_by NUMBER;

Line 355: SELECT igf_aw_fund_prg_s.NEXTVAL

351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
355: SELECT igf_aw_fund_prg_s.NEXTVAL
356: INTO x_fprg_id
357: FROM dual;
358:
359: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 375: INSERT INTO igf_aw_fund_prg_all (

371: x_last_updated_by => x_last_updated_by,
372: x_last_update_login => x_last_update_login
373: );
374:
375: INSERT INTO igf_aw_fund_prg_all (
376: fprg_id,
377: fund_id,
378: course_cd,
379: version_number,

Line 431: FROM igf_aw_fund_prg_all

427: SELECT
428: fund_id,
429: course_cd,
430: version_number
431: FROM igf_aw_fund_prg_all
432: WHERE rowid = x_rowid
433: FOR UPDATE NOWAIT;
434:
435: tlinfo c1%ROWTYPE;

Line 523: UPDATE igf_aw_fund_prg_all

519: x_last_updated_by => x_last_updated_by,
520: x_last_update_login => x_last_update_login
521: );
522:
523: UPDATE igf_aw_fund_prg_all
524: SET
525: fund_id = new_references.fund_id,
526: course_cd = new_references.course_cd,
527: version_number = new_references.version_number,

Line 559: FROM igf_aw_fund_prg_all

555: || (reverse chronological order - newest change first)
556: */
557: CURSOR c1 IS
558: SELECT rowid
559: FROM igf_aw_fund_prg_all
560: WHERE fprg_id = x_fprg_id;
561:
562: BEGIN
563:

Line 612: DELETE FROM igf_aw_fund_prg_all

608: p_action => 'DELETE',
609: x_rowid => x_rowid
610: );
611:
612: DELETE FROM igf_aw_fund_prg_all
613: WHERE rowid = x_rowid;
614:
615: IF (SQL%NOTFOUND) THEN
616: RAISE NO_DATA_FOUND;

Line 622: END igf_aw_fund_prg_pkg;

618:
619: END delete_row;
620:
621:
622: END igf_aw_fund_prg_pkg;