APPS.IGS_PR_STAT_TYPE_PKG dependencies on IGS_PR_STAT_TYPE

Line 1: PACKAGE BODY igs_pr_stat_type_pkg AS

1: PACKAGE BODY igs_pr_stat_type_pkg AS
2: /* $Header: IGSQI32B.pls 115.8 2003/04/15 09:09:26 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stat_type%ROWTYPE;

Line 5: old_references igs_pr_stat_type%ROWTYPE;

1: PACKAGE BODY igs_pr_stat_type_pkg AS
2: /* $Header: IGSQI32B.pls 115.8 2003/04/15 09:09:26 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stat_type%ROWTYPE;
6: new_references igs_pr_stat_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_stat_type%ROWTYPE;

2: /* $Header: IGSQI32B.pls 115.8 2003/04/15 09:09:26 ddey noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stat_type%ROWTYPE;
6: new_references igs_pr_stat_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 34: FROM igs_pr_stat_type

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_pr_stat_type
35: WHERE rowid = x_rowid;
36:
37: CURSOR cur_stu_acad_stat IS
38: SELECT 'X'

Line 132: igs_pr_inst_stat_pkg.get_fk_igs_pr_stat_type (

128: || (reverse chronological order - newest change first)
129: */
130: BEGIN
131:
132: igs_pr_inst_stat_pkg.get_fk_igs_pr_stat_type (
133: old_references.stat_type
134: );
135:
136: igs_pr_org_stat_pkg.get_fk_igs_pr_stat_type (

Line 136: igs_pr_org_stat_pkg.get_fk_igs_pr_stat_type (

132: igs_pr_inst_stat_pkg.get_fk_igs_pr_stat_type (
133: old_references.stat_type
134: );
135:
136: igs_pr_org_stat_pkg.get_fk_igs_pr_stat_type (
137: old_references.stat_type
138: );
139:
140: igs_pr_sta_type_ele_pkg.get_fk_igs_pr_stat_type (

Line 140: igs_pr_sta_type_ele_pkg.get_fk_igs_pr_stat_type (

136: igs_pr_org_stat_pkg.get_fk_igs_pr_stat_type (
137: old_references.stat_type
138: );
139:
140: igs_pr_sta_type_ele_pkg.get_fk_igs_pr_stat_type (
141: old_references.stat_type
142: );
143:
144: igs_pr_stu_acad_stat_pkg.get_fk_igs_pr_stat_type (

Line 144: igs_pr_stu_acad_stat_pkg.get_fk_igs_pr_stat_type (

140: igs_pr_sta_type_ele_pkg.get_fk_igs_pr_stat_type (
141: old_references.stat_type
142: );
143:
144: igs_pr_stu_acad_stat_pkg.get_fk_igs_pr_stat_type (
145: old_references.stat_type
146: );
147:
148: igs_pr_cohort_pkg.get_fk_igs_pr_stat_type (

Line 148: igs_pr_cohort_pkg.get_fk_igs_pr_stat_type (

144: igs_pr_stu_acad_stat_pkg.get_fk_igs_pr_stat_type (
145: old_references.stat_type
146: );
147:
148: igs_pr_cohort_pkg.get_fk_igs_pr_stat_type (
149: old_references.stat_type
150: );
151:
152: igs_da_cnfg_stat_pkg.get_fk_igs_pr_stat_type (

Line 152: igs_da_cnfg_stat_pkg.get_fk_igs_pr_stat_type (

148: igs_pr_cohort_pkg.get_fk_igs_pr_stat_type (
149: old_references.stat_type
150: );
151:
152: igs_da_cnfg_stat_pkg.get_fk_igs_pr_stat_type (
153: old_references.stat_type
154: );
155: END check_child_existance;
156:

Line 172: FROM igs_pr_stat_type

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igs_pr_stat_type
173: WHERE stat_type = x_stat_type
174: FOR UPDATE NOWAIT;
175:
176: lv_rowid cur_rowid%RowType;

Line 281: FROM igs_pr_stat_type

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR c IS
280: SELECT rowid
281: FROM igs_pr_stat_type
282: WHERE stat_type = x_stat_type;
283:
284: x_last_update_date DATE;
285: x_last_updated_by NUMBER;

Line 323: INSERT INTO igs_pr_stat_type (

319: x_last_updated_by => x_last_updated_by,
320: x_last_update_login => x_last_update_login
321: );
322:
323: INSERT INTO igs_pr_stat_type (
324: stat_type,
325: description,
326: derivation,
327: closed_ind,

Line 377: FROM igs_pr_stat_type

373: SELECT
374: description,
375: derivation,
376: closed_ind
377: FROM igs_pr_stat_type
378: WHERE rowid = x_rowid
379: FOR UPDATE NOWAIT;
380:
381: tlinfo c1%ROWTYPE;

Line 469: UPDATE igs_pr_stat_type

465: x_last_updated_by => x_last_updated_by,
466: x_last_update_login => x_last_update_login
467: );
468:
469: UPDATE igs_pr_stat_type
470: SET
471: description = new_references.description,
472: derivation = new_references.derivation,
473: closed_ind = new_references.closed_ind,

Line 505: FROM igs_pr_stat_type

501: || (reverse chronological order - newest change first)
502: */
503: CURSOR c1 IS
504: SELECT rowid
505: FROM igs_pr_stat_type
506: WHERE stat_type = x_stat_type;
507:
508: BEGIN
509:

Line 558: DELETE FROM igs_pr_stat_type

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

Line 568: END igs_pr_stat_type_pkg;

564:
565: END delete_row;
566:
567:
568: END igs_pr_stat_type_pkg;