APPS.IGS_PS_STDNT_UNT_TRN_PKG dependencies on IGS_PS_STDNT_UNT_TRN

Line 1: package body IGS_PS_STDNT_UNT_TRN_PKG as

1: package body IGS_PS_STDNT_UNT_TRN_PKG as
2: /* $Header: IGSPI67B.pls 115.7 2003/07/23 07:11:34 kkillams ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 11: old_references IGS_PS_STDNT_UNT_TRN%RowType;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: --svanukur 29-apr-03 Added uoo-id as part of MUS build #2829262
9: -------------------------------------------------------------------------------------------
10: l_rowid VARCHAR2(25);
11: old_references IGS_PS_STDNT_UNT_TRN%RowType;
12: new_references IGS_PS_STDNT_UNT_TRN%RowType;
13:
14:
15: PROCEDURE Set_Column_Values (

Line 12: new_references IGS_PS_STDNT_UNT_TRN%RowType;

8: --svanukur 29-apr-03 Added uoo-id as part of MUS build #2829262
9: -------------------------------------------------------------------------------------------
10: l_rowid VARCHAR2(25);
11: old_references IGS_PS_STDNT_UNT_TRN%RowType;
12: new_references IGS_PS_STDNT_UNT_TRN%RowType;
13:
14:
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,

Line 35: FROM IGS_PS_STDNT_UNT_TRN

31: ) AS
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_PS_STDNT_UNT_TRN
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 90: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PS_STDNT_UNT_TRN') THEN

86: ) AS
87: v_message_name VARCHAR2(30);
88: BEGIN
89: -- If trigger has not been disabled, perform required processing
90: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PS_STDNT_UNT_TRN') THEN
91: -- Insert validation
92: IF p_inserting THEN
93: IF IGS_EN_VAL_SUT.enrp_val_sut_insert (
94: new_references.person_id,

Line 252: FROM IGS_PS_STDNT_UNT_TRN

248: ) RETURN BOOLEAN AS
249:
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM IGS_PS_STDNT_UNT_TRN
253: WHERE person_id = x_person_id
254: AND course_cd = x_course_cd
255: AND transfer_course_cd = x_transfer_course_cd
256: AND transfer_dt = x_transfer_dt

Line 284: FROM IGS_PS_STDNT_UNT_TRN

280: ) AS
281:
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM IGS_PS_STDNT_UNT_TRN
285: WHERE person_id = x_person_id
286: AND course_cd = x_course_cd
287: AND transfer_course_cd = x_transfer_course_cd
288: AND transfer_dt = x_transfer_dt ;

Line 315: FROM IGS_PS_STDNT_UNT_TRN

311: ) AS
312:
313: CURSOR cur_rowid IS
314: SELECT rowid
315: FROM IGS_PS_STDNT_UNT_TRN
316: WHERE person_id = x_person_id
317: AND transfer_course_cd = x_course_cd
318: AND uoo_id = x_uoo_id
319: ;

Line 440: cursor C is select ROWID from IGS_PS_STDNT_UNT_TRN

436: X_TRANSFER_DT in DATE,
437: X_MODE in VARCHAR2 default 'R',
438: X_UOO_ID in NUMBER
439: ) as
440: cursor C is select ROWID from IGS_PS_STDNT_UNT_TRN
441: where PERSON_ID = X_PERSON_ID
442: and TRANSFER_COURSE_CD = X_TRANSFER_COURSE_CD
443: and COURSE_CD = X_COURSE_CD
444: and UOO_ID = X_UOO_ID

Line 487: insert into IGS_PS_STDNT_UNT_TRN (

483: x_last_update_login => X_LAST_UPDATE_LOGIN,
484: x_uoo_id =>X_UOO_ID
485: );
486:
487: insert into IGS_PS_STDNT_UNT_TRN (
488: PERSON_ID,
489: COURSE_CD,
490: TRANSFER_COURSE_CD,
491: TRANSFER_DT,

Line 543: from IGS_PS_STDNT_UNT_TRN

539: X_TRANSFER_DT in DATE,
540: X_UOO_ID in NUMBER
541: ) as
542: cursor c1 is select ROWID
543: from IGS_PS_STDNT_UNT_TRN
544: where ROWID = X_ROWID
545: for update nowait;
546: tlinfo c1%rowtype;
547:

Line 571: delete from IGS_PS_STDNT_UNT_TRN

567: Before_DML(
568: p_action => 'DELETE',
569: x_rowid => X_ROWID
570: );
571: delete from IGS_PS_STDNT_UNT_TRN
572: where ROWID = X_ROWID;
573: if (sql%notfound) then
574: raise no_data_found;
575: end if;

Line 582: end IGS_PS_STDNT_UNT_TRN_PKG;

578: x_rowid => X_ROWID
579: );
580: end DELETE_ROW;
581:
582: end IGS_PS_STDNT_UNT_TRN_PKG;