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_VER_PKG dependencies on IGS_PS_STAT

Line 39: igs_ps_stat us

35: cp_version_number igs_ps_ver_all.version_number%TYPE)
36: IS
37: SELECT 'x'
38: FROM igs_ps_ver_all uv,
39: igs_ps_stat us
40: WHERE uv.course_status=us.course_status
41: AND us.s_course_status='PLANNED'
42: AND uv.course_cd = cp_course_cd
43: AND uv.version_number = cp_version_number;

Line 74: CURSOR cur_get_status (cp_course_status igs_ps_stat.course_status%TYPE)

70: --
71: --Change History:
72: --Who When What
73: -------------------------------------------------------------------
74: CURSOR cur_get_status (cp_course_status igs_ps_stat.course_status%TYPE)
75: IS
76: SELECT s_course_status
77: FROM igs_ps_stat
78: WHERE course_status = cp_course_status;

Line 77: FROM igs_ps_stat

73: -------------------------------------------------------------------
74: CURSOR cur_get_status (cp_course_status igs_ps_stat.course_status%TYPE)
75: IS
76: SELECT s_course_status
77: FROM igs_ps_stat
78: WHERE course_status = cp_course_status;
79: l_s_course_status igs_ps_stat.s_course_status%TYPE;
80:
81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,

Line 79: l_s_course_status igs_ps_stat.s_course_status%TYPE;

75: IS
76: SELECT s_course_status
77: FROM igs_ps_stat
78: WHERE course_status = cp_course_status;
79: l_s_course_status igs_ps_stat.s_course_status%TYPE;
80:
81: CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
82: cp_version_number igs_ps_ver_all.version_number%TYPE)
83: IS

Line 86: igs_ps_stat us

82: cp_version_number igs_ps_ver_all.version_number%TYPE)
83: IS
84: SELECT 'x'
85: FROM igs_ps_ver_all uv,
86: igs_ps_stat us
87: WHERE uv.course_status=us.course_status
88: AND us.s_course_status <> 'PLANNED'
89: AND uv.course_cd = cp_course_cd
90: AND uv.version_number = cp_version_number;

Line 326: v_s_course_status igs_ps_stat.s_course_status%TYPE;

322: *************************************************************************/
323: v_message_name VARCHAR2(30);
324: cst_active VARCHAR2 (6) := 'ACTIVE';
325: cst_inactive VARCHAR2 (8) := 'INACTIVE';
326: v_s_course_status igs_ps_stat.s_course_status%TYPE;
327: CURSOR c_get_s_course_status
328: (cp_course_status igs_ps_stat.course_status%TYPE) IS
329: SELECT s_course_status
330: FROM igs_ps_stat

Line 328: (cp_course_status igs_ps_stat.course_status%TYPE) IS

324: cst_active VARCHAR2 (6) := 'ACTIVE';
325: cst_inactive VARCHAR2 (8) := 'INACTIVE';
326: v_s_course_status igs_ps_stat.s_course_status%TYPE;
327: CURSOR c_get_s_course_status
328: (cp_course_status igs_ps_stat.course_status%TYPE) IS
329: SELECT s_course_status
330: FROM igs_ps_stat
331: WHERE course_status = cp_course_status;
332:

Line 330: FROM igs_ps_stat

326: v_s_course_status igs_ps_stat.s_course_status%TYPE;
327: CURSOR c_get_s_course_status
328: (cp_course_status igs_ps_stat.course_status%TYPE) IS
329: SELECT s_course_status
330: FROM igs_ps_stat
331: WHERE course_status = cp_course_status;
332:
333: BEGIN
334: -- Validate mutating rows.

Line 442: v_s_course_status igs_ps_stat.s_course_status%TYPE;

438:
439: cst_active VARCHAR2 (6) := 'ACTIVE';
440: cst_inactive VARCHAR2 (8) := 'INACTIVE';
441: cst_error VARCHAR2 (1) := 'E';
442: v_s_course_status igs_ps_stat.s_course_status%TYPE;
443:
444: CURSOR c_get_s_course_status IS
445: SELECT s_course_status
446: FROM igs_ps_stat

Line 446: FROM igs_ps_stat

442: v_s_course_status igs_ps_stat.s_course_status%TYPE;
443:
444: CURSOR c_get_s_course_status IS
445: SELECT s_course_status
446: FROM igs_ps_stat
447: WHERE course_status = new_references.course_status;
448:
449: CURSOR spvh_cur IS
450: SELECT ROWID

Line 457: -- version has a system status of 'INACTIVE'. IGS_GE_EXCEPTIONS are : IGS_PS_STAT,

453: version_number = old_references.version_number;
454:
455: BEGIN
456: -- Validate the IGS_PS_COURSE version fields cannot be updated if the IGS_PS_COURSE
457: -- version has a system status of 'INACTIVE'. IGS_GE_EXCEPTIONS are : IGS_PS_STAT,
458: -- expiry_dt and end_dt.
459: IF p_updating THEN
460: OPEN c_get_s_course_status;
461: FETCH c_get_s_course_status

Line 534: -- Save the rowid, old expiry_dt and old IGS_PS_STAT,

530: -- IGS_GE_NOTE: A IGS_PS_COURSE version can only be created with a status of PLANNED.
531: -- Hence, only need to perform the check if p_updating.
532: IF p_updating AND
533: (v_s_course_status = cst_active) THEN
534: -- Save the rowid, old expiry_dt and old IGS_PS_STAT,
535: -- and process in the "after statement" trigger
536: -- as function will cause a mutating table error if called here.
537: rowvalmutation(
538: p_inserting => p_inserting,

Line 921: CURSOR cur_get_status(cp_course_status igs_ps_stat.course_status%TYPE) IS

917: FROM igs_ps_unit_lvl_all ulvl
918: WHERE course_cd = new_references.course_cd;
919: l_rowid VARCHAR2(25);
920:
921: CURSOR cur_get_status(cp_course_status igs_ps_stat.course_status%TYPE) IS
922: SELECT s_course_status
923: FROM igs_ps_stat
924: WHERE course_status=cp_course_status;
925:

Line 923: FROM igs_ps_stat

919: l_rowid VARCHAR2(25);
920:
921: CURSOR cur_get_status(cp_course_status igs_ps_stat.course_status%TYPE) IS
922: SELECT s_course_status
923: FROM igs_ps_stat
924: WHERE course_status=cp_course_status;
925:
926: l_old_course_status igs_ps_stat.s_course_status%TYPE;
927: l_new_course_status igs_ps_stat.s_course_status%TYPE;

Line 926: l_old_course_status igs_ps_stat.s_course_status%TYPE;

922: SELECT s_course_status
923: FROM igs_ps_stat
924: WHERE course_status=cp_course_status;
925:
926: l_old_course_status igs_ps_stat.s_course_status%TYPE;
927: l_new_course_status igs_ps_stat.s_course_status%TYPE;
928:
929: BEGIN
930: --

Line 927: l_new_course_status igs_ps_stat.s_course_status%TYPE;

923: FROM igs_ps_stat
924: WHERE course_status=cp_course_status;
925:
926: l_old_course_status igs_ps_stat.s_course_status%TYPE;
927: l_new_course_status igs_ps_stat.s_course_status%TYPE;
928:
929: BEGIN
930: --
931: -- Copy the New Program Version details to the Unit Level when the New Program Version is created.

Line 1407: IF NOT igs_ps_stat_pkg.get_pk_for_validation (

1403: IF (((old_references.course_status = new_references.course_status)) OR
1404: ((new_references.course_status IS NULL))) THEN
1405: NULL;
1406: ELSE
1407: IF NOT igs_ps_stat_pkg.get_pk_for_validation (
1408: new_references.course_status
1409: )THEN
1410: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1411: igs_ge_msg_stack.add;

Line 1695: igs_ps_stat st

1691: -- opening different cursors depending on the course status
1692: CURSOR cur_get_status IS
1693: SELECT st.s_course_status
1694: FROM igs_ps_ver_all v ,
1695: igs_ps_stat st
1696: WHERE v.course_status=st.course_status
1697: AND v.course_cd = x_course_cd
1698: AND v.version_number = x_version_number;
1699: l_course_status igs_ps_stat.s_course_status%TYPE;

Line 1699: l_course_status igs_ps_stat.s_course_status%TYPE;

1695: igs_ps_stat st
1696: WHERE v.course_status=st.course_status
1697: AND v.course_cd = x_course_cd
1698: AND v.version_number = x_version_number;
1699: l_course_status igs_ps_stat.s_course_status%TYPE;
1700:
1701: CURSOR cur_rowid_planned IS
1702: SELECT ROWID
1703: FROM igs_ps_ver_all

Line 1859: PROCEDURE get_fk_igs_ps_stat (

1855: CLOSE cur_rowid;
1856:
1857: END get_fk_igs_or_unit;
1858:
1859: PROCEDURE get_fk_igs_ps_stat (
1860: x_course_status IN VARCHAR2
1861: ) AS
1862: /************************************************************************
1863: Created By :

Line 1893: END get_fk_igs_ps_stat;

1889: RETURN;
1890: END IF;
1891: CLOSE cur_rowid;
1892:
1893: END get_fk_igs_ps_stat;
1894:
1895: PROCEDURE before_dml (
1896: p_action IN VARCHAR2,
1897: x_rowid IN VARCHAR2 ,