APPS.IGS_PS_STDNT_TRN_PKG dependencies on IGS_PS_STDNT_TRN

Line 1: PACKAGE BODY Igs_Ps_Stdnt_Trn_Pkg AS

1: PACKAGE BODY Igs_Ps_Stdnt_Trn_Pkg AS
2: /* $Header: IGSPI64B.pls 120.0 2005/06/01 16:18:11 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_TRN%ROWTYPE;
5: new_references IGS_PS_STDNT_TRN%ROWTYPE;

Line 4: old_references IGS_PS_STDNT_TRN%ROWTYPE;

1: PACKAGE BODY Igs_Ps_Stdnt_Trn_Pkg AS
2: /* $Header: IGSPI64B.pls 120.0 2005/06/01 16:18:11 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_TRN%ROWTYPE;
5: new_references IGS_PS_STDNT_TRN%ROWTYPE;
6:
7: PROCEDURE AfterRowInsertUpdate2(
8: p_inserting IN BOOLEAN ,

Line 5: new_references IGS_PS_STDNT_TRN%ROWTYPE;

1: PACKAGE BODY Igs_Ps_Stdnt_Trn_Pkg AS
2: /* $Header: IGSPI64B.pls 120.0 2005/06/01 16:18:11 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_TRN%ROWTYPE;
5: new_references IGS_PS_STDNT_TRN%ROWTYPE;
6:
7: PROCEDURE AfterRowInsertUpdate2(
8: p_inserting IN BOOLEAN ,
9: p_updating IN BOOLEAN ,

Line 39: FROM IGS_PS_STDNT_TRN

35: ) AS
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_PS_STDNT_TRN
40: WHERE ROWID = x_rowid;
41:
42: BEGIN
43:

Line 207: IGS_PS_STDNT_UNT_TRN_PKG.GET_FK_IGS_PS_STDNT_TRN (

203:
204: PROCEDURE Check_Child_Existance AS
205: BEGIN
206:
207: IGS_PS_STDNT_UNT_TRN_PKG.GET_FK_IGS_PS_STDNT_TRN (
208: old_references.person_id,
209: old_references.course_cd,
210: old_references.transfer_course_cd,
211: old_references.transfer_dt

Line 225: FROM IGS_PS_STDNT_TRN

221: ) RETURN BOOLEAN AS
222:
223: CURSOR cur_rowid IS
224: SELECT ROWID
225: FROM IGS_PS_STDNT_TRN
226: WHERE person_id = x_person_id
227: AND course_cd = x_course_cd
228: AND transfer_course_cd = x_transfer_course_cd
229: AND transfer_dt = x_transfer_dt

Line 254: FROM IGS_PS_STDNT_TRN

250: ) AS
251:
252: CURSOR cur_rowid IS
253: SELECT ROWID
254: FROM IGS_PS_STDNT_TRN
255: WHERE (person_id = x_person_id
256: AND course_cd = x_course_cd)
257: OR (person_id = x_person_id
258: AND transfer_course_cd = x_course_cd);

Line 451: CURSOR C IS SELECT ROWID FROM IGS_PS_STDNT_TRN

447: X_TRANSFER_ADV_STAND_FLAG IN VARCHAR2,
448: X_STATUS_DATE IN DATE ,
449: X_STATUS_FLAG IN VARCHAR2
450: ) AS
451: CURSOR C IS SELECT ROWID FROM IGS_PS_STDNT_TRN
452: WHERE PERSON_ID = X_PERSON_ID
453: AND TRANSFER_COURSE_CD = X_TRANSFER_COURSE_CD
454: AND TRANSFER_DT = X_TRANSFER_DT
455: AND COURSE_CD = X_COURSE_CD;

Line 501: INSERT INTO IGS_PS_STDNT_TRN (

497: x_last_updated_by => X_LAST_UPDATED_BY,
498: x_last_update_login => X_LAST_UPDATE_LOGIN
499: );
500:
501: INSERT INTO IGS_PS_STDNT_TRN (
502: PERSON_ID,
503: COURSE_CD,
504: TRANSFER_COURSE_CD,
505: TRANSFER_DT,

Line 577: FROM IGS_PS_STDNT_TRN

573: ) AS
574: CURSOR c1 IS SELECT
575: COMMENTS, APPROVED_DATE, EFFECTIVE_TERM_CAL_TYPE, EFFECTIVE_TERM_SEQUENCE_NUM, DISCONTINUE_SOURCE_FLAG,
576: UOOIDS_TO_TRANSFER, SUSA_TO_TRANSFER, TRANSFER_ADV_STAND_FLAG, STATUS_DATE, STATUS_FLAG
577: FROM IGS_PS_STDNT_TRN
578: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
579: tlinfo c1%ROWTYPE;
580:
581: BEGIN

Line 708: UPDATE IGS_PS_STDNT_TRN SET

704: x_last_updated_by => X_LAST_UPDATED_BY,
705: x_last_update_login => X_LAST_UPDATE_LOGIN
706: );
707:
708: UPDATE IGS_PS_STDNT_TRN SET
709: COMMENTS = NEW_REFERENCES.COMMENTS,
710: APPROVED_DATE = NEW_REFERENCES.APPROVED_DATE,
711: EFFECTIVE_TERM_CAL_TYPE = NEW_REFERENCES.EFFECTIVE_TERM_CAL_TYPE,
712: EFFECTIVE_TERM_SEQUENCE_NUM = NEW_REFERENCES.EFFECTIVE_TERM_SEQUENCE_NUM,

Line 753: CURSOR c1 IS SELECT ROWID FROM IGS_PS_STDNT_TRN

749: X_STATUS_DATE IN DATE,
750: X_STATUS_FLAG IN VARCHAR2
751:
752: ) AS
753: CURSOR c1 IS SELECT ROWID FROM IGS_PS_STDNT_TRN
754: WHERE PERSON_ID = X_PERSON_ID
755: AND TRANSFER_COURSE_CD = X_TRANSFER_COURSE_CD
756: AND TRANSFER_DT = X_TRANSFER_DT
757: AND COURSE_CD = X_COURSE_CD

Line 810: DELETE FROM IGS_PS_STDNT_TRN

806: BEGIN
807: Before_DML( p_action => 'DELETE',
808: x_rowid => X_ROWID
809: );
810: DELETE FROM IGS_PS_STDNT_TRN
811: WHERE ROWID = X_ROWID;
812: IF (SQL%NOTFOUND) THEN
813: RAISE NO_DATA_FOUND;
814: END IF;

Line 821: END Igs_Ps_Stdnt_Trn_Pkg;

817: x_rowid => X_ROWID
818: );
819: END DELETE_ROW;
820:
821: END Igs_Ps_Stdnt_Trn_Pkg;