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_EN_STDNTPSHECSOP_PKG dependencies on IGS_EN_STDNTPSHECSOP

Line 1: package body IGS_EN_STDNTPSHECSOP_PKG AS

1: package body IGS_EN_STDNTPSHECSOP_PKG AS
2: /* $Header: IGSEI17B.pls 115.4 2002/11/28 23:35:22 nsidana ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 12: old_references IGS_EN_STDNTPSHECSOP%RowType;

8: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------
11: l_rowid VARCHAR2(25);
12: old_references IGS_EN_STDNTPSHECSOP%RowType;
13: new_references IGS_EN_STDNTPSHECSOP%RowType;
14:
15:
16:

Line 13: new_references IGS_EN_STDNTPSHECSOP%RowType;

9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------
11: l_rowid VARCHAR2(25);
12: old_references IGS_EN_STDNTPSHECSOP%RowType;
13: new_references IGS_EN_STDNTPSHECSOP%RowType;
14:
15:
16:
17: PROCEDURE Set_Column_Values (

Line 47: FROM IGS_EN_STDNTPSHECSOP

43: ) AS
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_EN_STDNTPSHECSOP
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 103: -- ON IGS_EN_STDNTPSHECSOP

99:
100: -- Trigger description :-
101: -- "OSS_TST".trg_scho_br_iud
102: -- BEFORE INSERT OR DELETE OR UPDATE
103: -- ON IGS_EN_STDNTPSHECSOP
104: -- FOR EACH ROW
105:
106: PROCEDURE BeforeRowInsertUpdateDelete1(
107: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 118: -- IGS_EN_STDNTPSHECSOP, consider if this should be replicated

114: cst_error CONSTANT VARCHAR2(1) := 'E';
115: BEGIN
116: -- IMPORTANT IGS_GE_NOTE!
117: -- If making any changes to functionality associated with
118: -- IGS_EN_STDNTPSHECSOP, consider if this should be replicated
119: -- in the validation associated with the merging of ID's.
120: -- Refer to enrp_val_ps_scho_mrg.
121: -- If trigger has not been disabled, perform required processing
122: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN

Line 122: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN

118: -- IGS_EN_STDNTPSHECSOP, consider if this should be replicated
119: -- in the validation associated with the merging of ID's.
120: -- Refer to enrp_val_ps_scho_mrg.
121: -- If trigger has not been disabled, perform required processing
122: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
123: IF p_inserting THEN
124: -- Validate if the insert is allowed.
125: IF IGS_EN_VAL_SCHO.enrp_val_scho_insert (
126: new_references.person_id,

Line 259: -- IGS_EN_STDNTPSHECSOP and IGS_PE_STATISTICS and IGS_PS_COURSE VERSION.

255: app_exception.raise_exception;
256: END IF;
257: END IF;
258: -- Cross-table validations.
259: -- IGS_EN_STDNTPSHECSOP and IGS_PE_STATISTICS and IGS_PS_COURSE VERSION.
260: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,
261: -- and the IGS_PS_COURSE type of the IGS_PS_COURSE version for the student IGS_PS_COURSE attempt.
262: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
263: NVL(new_references.hecs_payment_option, 'NULL')) THEN

Line 522: -- ON IGS_EN_STDNTPSHECSOP

518:
519: -- Trigger description :-
520: -- "OSS_TST".trg_scho_ar_iu
521: -- AFTER INSERT OR UPDATE
522: -- ON IGS_EN_STDNTPSHECSOP
523: -- FOR EACH ROW
524:
525: PROCEDURE AfterRowInsertUpdate2(
526: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 535: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN

531: v_rowid_saved BOOLEAN := FALSE;
532: v_return_type VARCHAR2(1);
533: BEGIN
534: -- If trigger has not been disabled, perform required processing
535: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
536: -- Validate for open ended student IGS_PS_COURSE HECS option records.
537: IF new_references.end_dt IS NULL THEN
538: v_rowid_saved := TRUE;
539: END IF;

Line 588: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN

584: -- For all the 4 cases above where the rowid has been inserted the processing is done below
585: -- Dt: 8-Nov-99
586: IF v_rowid_saved = TRUE THEN
587: -- If trigger has not been disabled, perform required processing
588: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
589: -- Validate for open ended IGS_EN_STDNTPSHECSOP records.
590: IF New_References.end_dt IS NULL THEN
591: IF IGS_EN_VAL_SCHO.enrp_val_scho_open (
592: New_References.person_id,

Line 589: -- Validate for open ended IGS_EN_STDNTPSHECSOP records.

585: -- Dt: 8-Nov-99
586: IF v_rowid_saved = TRUE THEN
587: -- If trigger has not been disabled, perform required processing
588: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
589: -- Validate for open ended IGS_EN_STDNTPSHECSOP records.
590: IF New_References.end_dt IS NULL THEN
591: IF IGS_EN_VAL_SCHO.enrp_val_scho_open (
592: New_References.person_id,
593: New_References.course_cd,

Line 601: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.

597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: END IF;
600: END IF;
601: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.
602: IF IGS_EN_VAL_SCHO.enrp_val_scho_ovrlp (
603: New_References.person_id,
604: New_References.course_cd,
605: New_References.start_dt,

Line 812: FROM IGS_EN_STDNTPSHECSOP

808: ) RETURN BOOLEAN AS
809:
810: CURSOR cur_rowid IS
811: SELECT rowid
812: FROM IGS_EN_STDNTPSHECSOP
813: WHERE person_id = x_person_id
814: AND course_cd = x_course_cd
815: AND start_dt = x_start_dt
816: FOR UPDATE NOWAIT;

Line 840: FROM IGS_EN_STDNTPSHECSOP

836: ) AS
837:
838: CURSOR cur_rowid IS
839: SELECT rowid
840: FROM IGS_EN_STDNTPSHECSOP
841: WHERE hecs_payment_option = x_hecs_payment_option ;
842:
843: lv_rowid cur_rowid%RowType;
844:

Line 867: FROM IGS_EN_STDNTPSHECSOP

863: ) AS
864:
865: CURSOR cur_rowid IS
866: SELECT rowid
867: FROM IGS_EN_STDNTPSHECSOP
868: WHERE person_id = x_person_id
869: AND course_cd = x_course_cd ;
870:
871: lv_rowid cur_rowid%RowType;

Line 1032: cursor C is select ROWID from IGS_EN_STDNTPSHECSOP

1028: X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
1029: X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2,
1030: X_MODE in VARCHAR2 default 'R'
1031: ) AS
1032: cursor C is select ROWID from IGS_EN_STDNTPSHECSOP
1033: where PERSON_ID = X_PERSON_ID
1034: and COURSE_CD = X_COURSE_CD
1035: and START_DT = NEW_REFERENCES.START_DT;
1036: X_LAST_UPDATE_DATE DATE;

Line 1108: insert into IGS_EN_STDNTPSHECSOP (

1104: x_last_updated_by => X_LAST_UPDATED_BY,
1105: x_last_update_login => X_LAST_UPDATE_LOGIN
1106: );
1107:
1108: insert into IGS_EN_STDNTPSHECSOP (
1109: PERSON_ID,
1110: COURSE_CD,
1111: START_DT,
1112: END_DT,

Line 1218: from IGS_EN_STDNTPSHECSOP

1214: TAX_FILE_NUMBER_COLLECTED_DT,
1215: TAX_FILE_INVALID_DT,
1216: TAX_FILE_CERTIFICATE_NUMBER,
1217: DIFF_HECS_IND_UPDATE_COMMENTS
1218: from IGS_EN_STDNTPSHECSOP
1219: where ROWID = X_ROWID
1220: for update nowait;
1221: tlinfo c1%rowtype;
1222:

Line 1374: update IGS_EN_STDNTPSHECSOP set

1370: end if;
1371: end if;
1372:
1373:
1374: update IGS_EN_STDNTPSHECSOP set
1375: END_DT = X_END_DT,
1376: HECS_PAYMENT_OPTION = NEW_REFERENCES.HECS_PAYMENT_OPTION,
1377: DIFFERENTIAL_HECS_IND = NEW_REFERENCES.DIFFERENTIAL_HECS_IND,
1378: DIFF_HECS_IND_UPDATE_WHO = NEW_REFERENCES.DIFF_HECS_IND_UPDATE_WHO,

Line 1434: cursor c1 is select rowid from IGS_EN_STDNTPSHECSOP

1430: X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
1431: X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2,
1432: X_MODE in VARCHAR2 default 'R'
1433: ) AS
1434: cursor c1 is select rowid from IGS_EN_STDNTPSHECSOP
1435: where PERSON_ID = X_PERSON_ID
1436: and COURSE_CD = X_COURSE_CD
1437: and START_DT = nvl(X_START_DT,SYSDATE)
1438: ;

Line 1503: delete from IGS_EN_STDNTPSHECSOP

1499: x_rowid => X_ROWID
1500: );
1501:
1502:
1503: delete from IGS_EN_STDNTPSHECSOP
1504: where ROWID = X_ROWID;
1505: if (sql%notfound) then
1506: raise no_data_found;
1507: end if;

Line 1517: end IGS_EN_STDNTPSHECSOP_PKG;

1513:
1514:
1515: end DELETE_ROW;
1516:
1517: end IGS_EN_STDNTPSHECSOP_PKG;