eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_COURSE_PKG dependencies on IGS_PS_COURSE

Line 1: package body IGS_PS_COURSE_PKG AS

1: package body IGS_PS_COURSE_PKG AS
2: /* $Header: IGSPI03B.pls 115.7 2003/04/16 05:42:12 smanglm ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PS_COURSE%RowType;

2: /* $Header: IGSPI03B.pls 115.7 2003/04/16 05:42:12 smanglm ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_COURSE%RowType;
7: new_references IGS_PS_COURSE%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_COURSE%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_COURSE%RowType;
7: new_references IGS_PS_COURSE%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 ,

Line 34: FROM IGS_PS_COURSE

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

Line 95: IGS_AD_PS_APPL_PKG.GET_FK_IGS_PS_COURSE (

91:
92: PROCEDURE Check_Child_Existance AS
93: BEGIN
94:
95: IGS_AD_PS_APPL_PKG.GET_FK_IGS_PS_COURSE (
96: old_references.course_cd
97: );
98:
99: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_PS_COURSE (

Line 99: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_PS_COURSE (

95: IGS_AD_PS_APPL_PKG.GET_FK_IGS_PS_COURSE (
96: old_references.course_cd
97: );
98:
99: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_PS_COURSE (
100: old_references.course_cd
101: );
102:
103: IGS_PE_ALTERNATV_EXT_PKG.GET_FK_IGS_PS_COURSE (

Line 103: IGS_PE_ALTERNATV_EXT_PKG.GET_FK_IGS_PS_COURSE (

99: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_PS_COURSE (
100: old_references.course_cd
101: );
102:
103: IGS_PE_ALTERNATV_EXT_PKG.GET_FK_IGS_PS_COURSE (
104: old_references.course_cd
105: );
106:
107: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_PS_COURSE (

Line 107: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_PS_COURSE (

103: IGS_PE_ALTERNATV_EXT_PKG.GET_FK_IGS_PS_COURSE (
104: old_references.course_cd
105: );
106:
107: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_PS_COURSE (
108: old_references.course_cd
109: );
110:
111: IGS_PS_RU_PKG.GET_FK_IGS_PS_COURSE (

Line 111: IGS_PS_RU_PKG.GET_FK_IGS_PS_COURSE (

107: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_PS_COURSE (
108: old_references.course_cd
109: );
110:
111: IGS_PS_RU_PKG.GET_FK_IGS_PS_COURSE (
112: old_references.course_cd
113: );
114:
115: IGS_PS_VER_PKG.GET_FK_IGS_PS_COURSE (

Line 115: IGS_PS_VER_PKG.GET_FK_IGS_PS_COURSE (

111: IGS_PS_RU_PKG.GET_FK_IGS_PS_COURSE (
112: old_references.course_cd
113: );
114:
115: IGS_PS_VER_PKG.GET_FK_IGS_PS_COURSE (
116: old_references.course_cd
117: );
118:
119: IGS_FI_FEE_AS_PKG.GET_FK_IGS_PS_COURSE (

Line 119: IGS_FI_FEE_AS_PKG.GET_FK_IGS_PS_COURSE (

115: IGS_PS_VER_PKG.GET_FK_IGS_PS_COURSE (
116: old_references.course_cd
117: );
118:
119: IGS_FI_FEE_AS_PKG.GET_FK_IGS_PS_COURSE (
120: old_references.course_cd
121: );
122:
123: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_PS_COURSE (

Line 123: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_PS_COURSE (

119: IGS_FI_FEE_AS_PKG.GET_FK_IGS_PS_COURSE (
120: old_references.course_cd
121: );
122:
123: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_PS_COURSE (
124: old_references.course_cd
125: );
126:
127: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PS_COURSE (

Line 127: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PS_COURSE (

123: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_PS_COURSE (
124: old_references.course_cd
125: );
126:
127: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PS_COURSE (
128: old_references.course_cd
129: );
130:
131: IGS_PR_OU_PS_PKG.GET_FK_IGS_PS_COURSE (

Line 131: IGS_PR_OU_PS_PKG.GET_FK_IGS_PS_COURSE (

127: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PS_COURSE (
128: old_references.course_cd
129: );
130:
131: IGS_PR_OU_PS_PKG.GET_FK_IGS_PS_COURSE (
132: old_references.course_cd
133: );
134:
135: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_COURSE (

Line 135: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_COURSE (

131: IGS_PR_OU_PS_PKG.GET_FK_IGS_PS_COURSE (
132: old_references.course_cd
133: );
134:
135: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_COURSE (
136: old_references.course_cd
137: );
138:
139: IGS_PR_STDNT_PR_PS_PKG.GET_FK_IGS_PS_COURSE (

Line 139: IGS_PR_STDNT_PR_PS_PKG.GET_FK_IGS_PS_COURSE (

135: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_COURSE (
136: old_references.course_cd
137: );
138:
139: IGS_PR_STDNT_PR_PS_PKG.GET_FK_IGS_PS_COURSE (
140: old_references.course_cd
141: );
142:
143: igs_da_cnfg_req_typ_pkg.get_fk_igs_ps_course (

Line 143: igs_da_cnfg_req_typ_pkg.get_fk_igs_ps_course (

139: IGS_PR_STDNT_PR_PS_PKG.GET_FK_IGS_PS_COURSE (
140: old_references.course_cd
141: );
142:
143: igs_da_cnfg_req_typ_pkg.get_fk_igs_ps_course (
144: x_course_cd => old_references.course_cd
145: );
146:
147: igs_da_req_wif_pkg.get_fk_igs_ps_course (

Line 147: igs_da_req_wif_pkg.get_fk_igs_ps_course (

143: igs_da_cnfg_req_typ_pkg.get_fk_igs_ps_course (
144: x_course_cd => old_references.course_cd
145: );
146:
147: igs_da_req_wif_pkg.get_fk_igs_ps_course (
148: x_course_cd => old_references.course_cd
149: );
150: igs_da_req_stdnts_pkg.get_fk_igs_ps_course (
151: x_course_cd => old_references.course_cd

Line 150: igs_da_req_stdnts_pkg.get_fk_igs_ps_course (

146:
147: igs_da_req_wif_pkg.get_fk_igs_ps_course (
148: x_course_cd => old_references.course_cd
149: );
150: igs_da_req_stdnts_pkg.get_fk_igs_ps_course (
151: x_course_cd => old_references.course_cd
152: );
153:
154: END Check_Child_Existance;

Line 168: FROM IGS_PS_COURSE

164: from the cursor, cur_rowid.
165: ***************************************************************************************/
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM IGS_PS_COURSE
169: WHERE course_cd = x_course_cd;
170:
171: lv_rowid cur_rowid%RowType;
172:

Line 254: cursor C is select ROWID from IGS_PS_COURSE

250: X_ROWID in out NOCOPY VARCHAR2,
251: X_COURSE_CD in VARCHAR2,
252: X_MODE in VARCHAR2
253: ) AS
254: cursor C is select ROWID from IGS_PS_COURSE
255: where COURSE_CD = X_COURSE_CD;
256: X_LAST_UPDATE_DATE DATE;
257: X_LAST_UPDATED_BY NUMBER;
258: X_LAST_UPDATE_LOGIN NUMBER;

Line 290: insert into IGS_PS_COURSE (

286: x_last_updated_by => X_LAST_UPDATED_BY ,
287: x_last_update_login => X_LAST_UPDATE_LOGIN
288: );
289:
290: insert into IGS_PS_COURSE (
291: COURSE_CD,
292: CREATION_DATE,
293: CREATED_BY,
294: LAST_UPDATE_DATE,

Line 326: from IGS_PS_COURSE

322: X_ROWID IN VARCHAR2,
323: X_COURSE_CD in VARCHAR2
324: ) AS
325: cursor c1 is select ROWID
326: from IGS_PS_COURSE
327: where ROWID = X_ROWID
328: for update nowait;
329: tlinfo c1%rowtype;
330:

Line 356: delete from IGS_PS_COURSE

352: p_action => 'DELETE',
353: x_rowid => X_ROWID
354: );
355:
356: delete from IGS_PS_COURSE
357: where ROWID = X_ROWID;
358: if (sql%notfound) then
359: raise no_data_found;
360: end if;

Line 369: end IGS_PS_COURSE_PKG;

365: );
366:
367: end DELETE_ROW;
368:
369: end IGS_PS_COURSE_PKG;