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_AS_SU_SETATMPT_PKG dependencies on IGS_AS_SU_SETATMPT

Line 1: PACKAGE BODY IGS_AS_SU_SETATMPT_PKG AS

1: PACKAGE BODY IGS_AS_SU_SETATMPT_PKG AS
2: /* $Header: IGSDI29B.pls 120.2 2006/05/29 07:53:01 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SU_SETATMPT%ROWTYPE;

Line 5: old_references IGS_AS_SU_SETATMPT%ROWTYPE;

1: PACKAGE BODY IGS_AS_SU_SETATMPT_PKG AS
2: /* $Header: IGSDI29B.pls 120.2 2006/05/29 07:53:01 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SU_SETATMPT%ROWTYPE;
6: new_references IGS_AS_SU_SETATMPT%ROWTYPE;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 6: new_references IGS_AS_SU_SETATMPT%ROWTYPE;

2: /* $Header: IGSDI29B.pls 120.2 2006/05/29 07:53:01 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SU_SETATMPT%ROWTYPE;
6: new_references IGS_AS_SU_SETATMPT%ROWTYPE;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,
10: x_person_id IN NUMBER ,

Line 59: FROM IGS_AS_SU_SETATMPT

55: x_last_update_login IN NUMBER
56: ) AS
57: CURSOR cur_old_ref_values IS
58: SELECT *
59: FROM IGS_AS_SU_SETATMPT
60: WHERE ROWID = x_rowid;
61: BEGIN
62: l_rowid := x_rowid;
63: -- Code for setting the Old and New Reference Values.

Line 130: -- ON IGS_AS_SU_SETATMPT

126: END Set_Column_Values;
127: -- Trigger description :-
128: -- "OSS_TST".trg_susa_br_iud
129: -- BEFORE INSERT OR DELETE OR UPDATE
130: -- ON IGS_AS_SU_SETATMPT
131: -- FOR EACH ROW
132: PROCEDURE BeforeRowInsertUpdateDelete1(
133: p_inserting IN BOOLEAN ,
134: p_updating IN BOOLEAN ,

Line 172: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN

168: -- trigger. If wishing to disable the triggers, use a different table name as
169: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
170: -- IGS_GE_NOTE: Any alterations to susa triggers should be applied to module
171: -- enrp_val_susa.
172: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN
173: IF p_inserting THEN
174: -- Validate the the IGS_PS_UNIT set is able to be created.
175: -- against the student IGS_PS_COURSE attempt.
176: IF IGS_EN_VAL_SUSA.enrp_val_susa_sca(

Line 371: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN

367: v_delete BOOLEAN;
368: cst_error CONSTANT CHAR := 'E';
369: v_message_name VARCHAR2(30);
370: BEGIN
371: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN
372: IF p_inserting THEN
373: -- Validate the the unit set is able to be created
374: -- with the unit set status being valid and the
375: -- expiry date not set. If set then person must have

Line 545: -- ON IGS_AS_SU_SETATMPT

541: END RowValMutation;
542: -- Trigger description :-
543: -- "OSS_TST".trg_susa_ar_iu
544: -- AFTER INSERT OR UPDATE
545: -- ON IGS_AS_SU_SETATMPT
546: -- FOR EACH ROW
547: PROCEDURE AfterRowInsertUpdate2(
548: p_inserting IN BOOLEAN,
549: p_updating IN BOOLEAN,

Line 580: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN

576: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and
577: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment
578: -- trigger. If wishing to disable the triggers, use a different table name as
579: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
580: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN
581: -- Validate the the IGS_PS_UNIT set is able to be created
582: -- with the IGS_PS_UNIT set status being valid and the
583: -- expiry date not set. If set then IGS_PE_PERSON must have
584: -- previously selected it.

Line 729: -- ON IGS_AS_SU_SETATMPT

725: END AfterRowInsertUpdate2;
726: -- Trigger description :-
727: -- "OSS_TST".trg_susa_ar_ud_hist
728: -- AFTER DELETE OR UPDATE
729: -- ON IGS_AS_SU_SETATMPT
730: -- FOR EACH ROW
731: PROCEDURE AfterRowUpdateDelete3(
732: p_inserting IN BOOLEAN,
733: p_updating IN BOOLEAN,

Line 739: -- Create IGS_AS_SU_SETATMPT history record.

735: ) AS
736: v_message_name VARCHAR2(30);
737: BEGIN
738: IF p_updating THEN
739: -- Create IGS_AS_SU_SETATMPT history record.
740: IGS_EN_GEN_010.ENRP_INS_SUSA_HIST (
741: new_references.person_id,
742: new_references.course_cd,
743: new_references.unit_set_cd,

Line 783: -- Delete IGS_AS_SU_SETATMPT history records.

779: new_references.last_update_date,
780: old_references.last_update_date);
781: END IF;
782: IF p_deleting THEN
783: -- Delete IGS_AS_SU_SETATMPT history records.
784: IF IGS_EN_GEN_001.ENRP_DEL_SUSA_HIST (
785: old_references.person_id,
786: old_references.course_cd,
787: old_references.unit_set_cd,

Line 799: -- ON IGS_AS_SU_SETATMPT

795: END AfterRowUpdateDelete3;
796: -- Trigger description :-
797: -- "OSS_TST".trg_susa_as_iu
798: -- AFTER INSERT OR UPDATE
799: -- ON IGS_AS_SU_SETATMPT
800:
801: PROCEDURE Check_Parent_Existance AS
802:
803: -- check if the parent unit set is a valid one

Line 808: IGS_AS_SU_SETATMPT susa,

804: CURSOR c_parent_rel_exists IS
805:
806: SELECT 'x'
807: FROM IGS_PS_OF_UNT_SET_RL cousr,
808: IGS_AS_SU_SETATMPT susa,
809: IGS_EN_STDNT_PS_ATT spa
810: WHERE spa.person_id = susa.person_id AND
811: spa.course_cd = susa.course_cd AND
812: susa.person_id = new_references.person_id AND

Line 866: IF NOT IGS_AS_SU_SETATMPT_PKG.Get_PK_For_Validation (

862: (new_references.parent_unit_set_cd IS NULL) OR
863: (new_references.parent_sequence_number IS NULL)) THEN
864: NULL;
865: ELSE
866: IF NOT IGS_AS_SU_SETATMPT_PKG.Get_PK_For_Validation (
867: new_references.person_id,
868: new_references.course_cd,
869: new_references.parent_unit_set_cd,
870: new_references.parent_sequence_number

Line 1024: IGS_AS_SU_SETATMPT_PKG.GET_FK_IGS_AS_SU_SETATMPT (

1020:
1021:
1022: PROCEDURE Check_Child_Existance AS
1023: BEGIN
1024: IGS_AS_SU_SETATMPT_PKG.GET_FK_IGS_AS_SU_SETATMPT (
1025: OLD_references.person_id,
1026: OLD_references.course_cd,
1027: OLD_references.unit_set_cd,
1028: OLD_references.sequence_number

Line 1039: FROM IGS_AS_SU_SETATMPT

1035: x_sequence_number IN NUMBER
1036: ) RETURN BOOLEAN AS
1037: CURSOR cur_rowid IS
1038: SELECT ROWID
1039: FROM IGS_AS_SU_SETATMPT
1040: WHERE person_id = x_person_id
1041: AND course_cd = x_course_cd
1042: AND unit_set_cd = x_unit_set_cd
1043: AND sequence_number = x_sequence_number

Line 1063: FROM IGS_AS_SU_SETATMPT

1059: x_course_cd IN VARCHAR2
1060: ) AS
1061: CURSOR cur_rowid IS
1062: SELECT ROWID
1063: FROM IGS_AS_SU_SETATMPT
1064: WHERE person_id = x_person_id
1065: AND course_cd = x_course_cd ;
1066: lv_rowid cur_rowid%ROWTYPE;
1067: BEGIN

Line 1080: PROCEDURE GET_FK_IGS_AS_SU_SETATMPT (

1076: RETURN;
1077: END IF;
1078: CLOSE cur_rowid;
1079: END GET_FK_IGS_EN_STDNT_PS_ATT;
1080: PROCEDURE GET_FK_IGS_AS_SU_SETATMPT (
1081: x_person_id IN NUMBER,
1082: x_course_cd IN VARCHAR2,
1083: x_unit_set_cd IN VARCHAR2,
1084: x_sequence_number IN NUMBER

Line 1088: FROM IGS_AS_SU_SETATMPT

1084: x_sequence_number IN NUMBER
1085: ) AS
1086: CURSOR cur_rowid IS
1087: SELECT ROWID
1088: FROM IGS_AS_SU_SETATMPT
1089: WHERE person_id = x_person_id
1090: AND course_cd = x_course_cd
1091: AND parent_unit_set_cd = x_unit_set_cd
1092: AND parent_sequence_number = x_sequence_number ;

Line 1106: END GET_FK_IGS_AS_SU_SETATMPT;

1102:
1103: RETURN;
1104: END IF;
1105: CLOSE cur_rowid;
1106: END GET_FK_IGS_AS_SU_SETATMPT;
1107: PROCEDURE GET_FK_IGS_EN_UNIT_SET (
1108: x_unit_set_cd IN VARCHAR2,
1109: x_version_number IN NUMBER
1110: ) AS

Line 1113: FROM IGS_AS_SU_SETATMPT

1109: x_version_number IN NUMBER
1110: ) AS
1111: CURSOR cur_rowid IS
1112: SELECT ROWID
1113: FROM IGS_AS_SU_SETATMPT
1114: WHERE unit_set_cd = x_unit_set_cd
1115: AND us_version_number = x_version_number ;
1116: lv_rowid cur_rowid%ROWTYPE;
1117: BEGIN

Line 1139: FROM IGS_AS_SU_SETATMPT

1135: X_CATALOG_SEQ_NUM IN NUMBER
1136: ) AS
1137: CURSOR cur_rowid IS
1138: SELECT ROWID
1139: FROM IGS_AS_SU_SETATMPT
1140: WHERE CATALOG_CAL_TYPE = X_CATALOG_CAL_TYPE
1141: AND CATALOG_SEQ_NUM = X_CATALOG_SEQ_NUM
1142: ;
1143:

Line 1178: FROM igs_as_su_setatmpt a, igs_en_stdnt_ps_att b

1174: (reverse chronological order - newest change first)
1175: ***************************************************************/
1176: CURSOR cur_rowid IS
1177: SELECT a.rowid
1178: FROM igs_as_su_setatmpt a, igs_en_stdnt_ps_att b
1179: WHERE a.course_cd=b.course_cd
1180: AND a.person_id=b.person_id
1181: AND b.course_cd=x_course_cd
1182: AND b.version_number=x_version_number

Line 1422: CURSOR C IS SELECT ROWID FROM IGS_AS_SU_SETATMPT

1418: X_ATTRIBUTE19 IN VARCHAR2 ,
1419: X_ATTRIBUTE20 IN VARCHAR2 ,
1420: X_MODE IN VARCHAR2
1421: ) AS
1422: CURSOR C IS SELECT ROWID FROM IGS_AS_SU_SETATMPT
1423: WHERE PERSON_ID = X_PERSON_ID
1424: AND COURSE_CD = X_COURSE_CD
1425: AND UNIT_SET_CD = X_UNIT_SET_CD
1426: AND SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 1519: INSERT INTO IGS_AS_SU_SETATMPT (

1515: --
1516: IF (x_mode = 'S') THEN
1517: igs_sc_gen_001.set_ctx('R');
1518: END IF;
1519: INSERT INTO IGS_AS_SU_SETATMPT (
1520: PERSON_ID,
1521: COURSE_CD,
1522: UNIT_SET_CD,
1523: US_VERSION_NUMBER,

Line 1735: FROM IGS_AS_SU_SETATMPT

1731: ATTRIBUTE17,
1732: ATTRIBUTE18,
1733: ATTRIBUTE19,
1734: ATTRIBUTE20
1735: FROM IGS_AS_SU_SETATMPT
1736: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
1737: tlinfo c1%ROWTYPE;
1738: BEGIN
1739: OPEN c1;

Line 1999: UPDATE IGS_AS_SU_SETATMPT SET

1995: END IF;
1996: IF (x_mode = 'S') THEN
1997: igs_sc_gen_001.set_ctx('R');
1998: END IF;
1999: UPDATE IGS_AS_SU_SETATMPT SET
2000: US_VERSION_NUMBER = NEW_REFERENCES.US_VERSION_NUMBER,
2001: SELECTION_DT = NEW_REFERENCES.SELECTION_DT,
2002: STUDENT_CONFIRMED_IND = NEW_REFERENCES.STUDENT_CONFIRMED_IND,
2003: END_DT = NEW_REFERENCES.END_DT,

Line 2120: CURSOR c1 IS SELECT ROWID FROM IGS_AS_SU_SETATMPT

2116: X_ATTRIBUTE19 IN VARCHAR2 ,
2117: X_ATTRIBUTE20 IN VARCHAR2 ,
2118: X_MODE IN VARCHAR2
2119: ) AS
2120: CURSOR c1 IS SELECT ROWID FROM IGS_AS_SU_SETATMPT
2121: WHERE PERSON_ID = X_PERSON_ID
2122: AND COURSE_CD = X_COURSE_CD
2123: AND UNIT_SET_CD = X_UNIT_SET_CD
2124: AND SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 2236: DELETE FROM IGS_AS_SU_SETATMPT

2232: --
2233: IF (x_mode = 'S') THEN
2234: igs_sc_gen_001.set_ctx('R');
2235: END IF;
2236: DELETE FROM IGS_AS_SU_SETATMPT
2237: WHERE ROWID = X_ROWID;
2238: IF (SQL%NOTFOUND) THEN
2239: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2240: igs_ge_msg_stack.add;

Line 2255: END IGS_AS_SU_SETATMPT_PKG;

2251: x_rowid => X_ROWID
2252: );
2253: --
2254: END DELETE_ROW;
2255: END IGS_AS_SU_SETATMPT_PKG;