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.

[Home] [Help]

APPS.IGS_PS_GEN_005 dependencies on IGS_PS_UNIT_VER

Line 99: IGS_PS_UNIT_VER uv,

95: SELECT calul.unit_cd,
96: calul.uv_version_number,
97: us.s_unit_status
98: FROM IGS_PS_ANL_LOAD_U_LN calul,
99: IGS_PS_UNIT_VER uv,
100: IGS_PS_UNIT_STAT us
101: WHERE calul.course_cd = p_course_cd AND
102: calul.crv_version_number = p_version_number AND
103: calul.yr_num = p_yr_num AND

Line 231: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

227: p_last_update_who IN VARCHAR2 ,
228: p_percentage IN NUMBER )
229: AS
230: CURSOR c_unit_status(
231: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

Line 232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

228: p_percentage IN NUMBER )
229: AS
230: CURSOR c_unit_status(
231: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
236: IGS_PS_UNIT_VER.version_number = cp_version_number AND

Line 234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER

230: CURSOR c_unit_status(
231: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
236: IGS_PS_UNIT_VER.version_number = cp_version_number AND
237: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
238: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';

Line 235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

231: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
236: IGS_PS_UNIT_VER.version_number = cp_version_number AND
237: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
238: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
239: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

Line 236: IGS_PS_UNIT_VER.version_number = cp_version_number AND

232: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
236: IGS_PS_UNIT_VER.version_number = cp_version_number AND
237: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
238: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
239: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
240: x_rowid VARCHAR2(25);

Line 237: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

233: SELECT IGS_PS_UNIT_STAT.s_unit_status
234: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
235: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
236: IGS_PS_UNIT_VER.version_number = cp_version_number AND
237: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
238: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
239: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
240: x_rowid VARCHAR2(25);
241: l_org_id NUMBER(15);

Line 282: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

278: p_last_update_who IN VARCHAR2 ,
279: p_percentage IN NUMBER )
280: AS
281: CURSOR c_unit_status(
282: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

Line 283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

279: p_percentage IN NUMBER )
280: AS
281: CURSOR c_unit_status(
282: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
287: IGS_PS_UNIT_VER.version_number = cp_version_number AND

Line 285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER

281: CURSOR c_unit_status(
282: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
287: IGS_PS_UNIT_VER.version_number = cp_version_number AND
288: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
289: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';

Line 286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

282: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
287: IGS_PS_UNIT_VER.version_number = cp_version_number AND
288: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
289: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
290: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

Line 287: IGS_PS_UNIT_VER.version_number = cp_version_number AND

283: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
287: IGS_PS_UNIT_VER.version_number = cp_version_number AND
288: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
289: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
290: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
291: X_rowid VARCHAR2(25);

Line 288: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

284: SELECT IGS_PS_UNIT_STAT.s_unit_status
285: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
286: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
287: IGS_PS_UNIT_VER.version_number = cp_version_number AND
288: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
289: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
290: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
291: X_rowid VARCHAR2(25);
292: l_org_id NUMBER(15);

Line 334: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

330: p_last_update_who IN VARCHAR2 ,
331: p_description IN VARCHAR2 )
332: AS
333: CURSOR c_unit_status(
334: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

Line 335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

331: p_description IN VARCHAR2 )
332: AS
333: CURSOR c_unit_status(
334: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
339: IGS_PS_UNIT_VER.version_number = cp_version_number AND

Line 337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER

333: CURSOR c_unit_status(
334: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
339: IGS_PS_UNIT_VER.version_number = cp_version_number AND
340: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
341: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';

Line 338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND

334: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
339: IGS_PS_UNIT_VER.version_number = cp_version_number AND
340: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
341: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
342: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

Line 339: IGS_PS_UNIT_VER.version_number = cp_version_number AND

335: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
339: IGS_PS_UNIT_VER.version_number = cp_version_number AND
340: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
341: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
342: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
343: x_rowid VARCHAR2(25);

Line 340: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

336: SELECT IGS_PS_UNIT_STAT.s_unit_status
337: FROM IGS_PS_UNIT_STAT,IGS_PS_UNIT_VER
338: WHERE IGS_PS_UNIT_VER.unit_cd = cp_unit_cd AND
339: IGS_PS_UNIT_VER.version_number = cp_version_number AND
340: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
341: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
342: v_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
343: x_rowid VARCHAR2(25);
344: l_org_id NUMBER(15);