APPS.IGS_PR_OU_TYPE_PKG dependencies on IGS_PR_OU_TYPE_ALL

Line 5: old_references IGS_PR_OU_TYPE_ALL%RowType;

1: package body IGS_PR_OU_TYPE_PKG as
2: /* $Header: IGSQI06B.pls 115.9 2003/02/24 11:30:35 gjha ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_TYPE_ALL%RowType;
6: new_references IGS_PR_OU_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_OU_TYPE_ALL%RowType;

2: /* $Header: IGSQI06B.pls 115.9 2003/02/24 11:30:35 gjha ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_TYPE_ALL%RowType;
6: new_references IGS_PR_OU_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 30: FROM IGS_PR_OU_TYPE_ALL

26: ) AS
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_PR_OU_TYPE_ALL
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 139: FROM IGS_PR_OU_TYPE_ALL

135: ) RETURN BOOLEAN AS
136:
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM IGS_PR_OU_TYPE_ALL
140: WHERE progression_outcome_type = x_progression_outcome_type ; /* Removed for update of for the Locking issue. Bug 2784198 */
141:
142: lv_rowid cur_rowid%RowType;
143:

Line 164: FROM IGS_PR_OU_TYPE_ALL

160: ) AS
161:
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM IGS_PR_OU_TYPE_ALL
165: WHERE dflt_restricted_att_type = x_attendance_type ;
166:
167: lv_rowid cur_rowid%RowType;
168:

Line 190: FROM IGS_PR_OU_TYPE_ALL

186: ) AS
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_PR_OU_TYPE_ALL
191: WHERE encumbrance_type = x_encumbrance_type ;
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 216: FROM IGS_PR_OU_TYPE_ALL

212: ) AS
213:
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM IGS_PR_OU_TYPE_ALL
217: WHERE s_progression_outcome_type = x_s_progression_outcome_type ;
218:
219: lv_rowid cur_rowid%RowType;
220:

Line 345: cursor C is select ROWID from IGS_PR_OU_TYPE_ALL

341: X_MODE in VARCHAR2 default 'R',
342: X_ORG_ID IN NUMBER,
343: X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
344: ) as
345: cursor C is select ROWID from IGS_PR_OU_TYPE_ALL
346: where PROGRESSION_OUTCOME_TYPE = X_PROGRESSION_OUTCOME_TYPE;
347: X_LAST_UPDATE_DATE DATE;
348: X_LAST_UPDATED_BY NUMBER;
349: X_LAST_UPDATE_LOGIN NUMBER;

Line 388: insert into IGS_PR_OU_TYPE_ALL (

384: x_last_update_login => x_last_update_login,
385: x_org_id => igs_ge_gen_003.get_org_id,
386: x_positive_outcome_ind => x_positive_outcome_ind
387: );
388: insert into IGS_PR_OU_TYPE_ALL (
389: PROGRESSION_OUTCOME_TYPE,
390: S_PROGRESSION_OUTCOME_TYPE,
391: DESCRIPTION,
392: ENCUMBRANCE_TYPE,

Line 451: from IGS_PR_OU_TYPE_ALL

447: DFLT_RESTRICTED_ENROLMENT_CP,
448: DFLT_RESTRICTED_ATT_TYPE,
449: CLOSED_IND,
450: COMMENTS
451: from IGS_PR_OU_TYPE_ALL
452: where ROWID = X_ROWID for update nowait;
453: tlinfo c1%rowtype;
454:
455: begin

Line 546: update IGS_PR_OU_TYPE_ALL set

542: x_last_update_login => x_last_update_login,
543: x_positive_outcome_ind => x_positive_outcome_ind
544: );
545:
546: update IGS_PR_OU_TYPE_ALL set
547: S_PROGRESSION_OUTCOME_TYPE = NEW_REFERENCES.S_PROGRESSION_OUTCOME_TYPE,
548: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
549: ENCUMBRANCE_TYPE = NEW_REFERENCES.ENCUMBRANCE_TYPE,
550: DFLT_RESTRICTED_ENROLMENT_CP = NEW_REFERENCES.DFLT_RESTRICTED_ENROLMENT_CP,

Line 579: cursor c1 is select rowid from IGS_PR_OU_TYPE_ALL

575: X_MODE in VARCHAR2 default 'R',
576: X_ORG_ID in NUMBER,
577: X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
578: ) as
579: cursor c1 is select rowid from IGS_PR_OU_TYPE_ALL
580: where PROGRESSION_OUTCOME_TYPE = X_PROGRESSION_OUTCOME_TYPE
581: ;
582: begin
583: open c1;