APPS.IGS_AD_EDUGOAL_PKG dependencies on IGS_AD_EDUGOAL

Line 1: PACKAGE BODY igs_ad_edugoal_pkg AS

1: PACKAGE BODY igs_ad_edugoal_pkg AS
2: /* $Header: IGSAIA1B.pls 120.3 2005/10/03 08:22:07 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_edugoal%RowType;
5: new_references igs_ad_edugoal%RowType;

Line 4: old_references igs_ad_edugoal%RowType;

1: PACKAGE BODY igs_ad_edugoal_pkg AS
2: /* $Header: IGSAIA1B.pls 120.3 2005/10/03 08:22:07 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_edugoal%RowType;
5: new_references igs_ad_edugoal%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_edugoal%RowType;

1: PACKAGE BODY igs_ad_edugoal_pkg AS
2: /* $Header: IGSAIA1B.pls 120.3 2005/10/03 08:22:07 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_edugoal%RowType;
5: new_references igs_ad_edugoal%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_AD_EDUGOAL

32: ***************************************************************/
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_AD_EDUGOAL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 195: FROM igs_ad_edugoal

191: ***************************************************************/
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_ad_edugoal
196: WHERE post_edugoal_id = x_post_edugoal_id
197: FOR UPDATE NOWAIT;
198:
199: lv_rowid cur_rowid%RowType;

Line 235: FROM igs_ad_edugoal

231: ***************************************************************/
232:
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM igs_ad_edugoal
236: WHERE admission_appl_number = x_admission_appl_number
237: AND edu_goal_id = x_edu_goal_id
238: AND nominated_course_cd = x_nominated_course_cd
239: AND person_id = x_person_id

Line 277: FROM igs_ad_edugoal

273: ***************************************************************/
274:
275: CURSOR cur_rowid IS
276: SELECT rowid
277: FROM igs_ad_edugoal
278: WHERE person_id = x_person_id
279: AND admission_appl_number = x_admission_appl_number
280: AND nominated_course_cd = x_nominated_course_cd
281: AND sequence_number = x_sequence_number ;

Line 317: FROM igs_ad_edugoal

313: ***************************************************************/
314:
315: CURSOR cur_rowid IS
316: SELECT rowid
317: FROM igs_ad_edugoal
318: WHERE edu_goal_id = x_code_id ;
319:
320: lv_rowid cur_rowid%RowType;
321:

Line 484: cursor C is select ROWID from IGS_AD_EDUGOAL

480: ravishar 05/27/05 Security related changes
481: (reverse chronological order - newest change first)
482: ***************************************************************/
483:
484: cursor C is select ROWID from IGS_AD_EDUGOAL
485: where POST_EDUGOAL_ID= X_POST_EDUGOAL_ID
486: ;
487: X_LAST_UPDATE_DATE DATE ;
488: X_LAST_UPDATED_BY NUMBER ;

Line 528: INSERT INTO IGS_AD_EDUGOAL (

524: x_last_update_login=>X_LAST_UPDATE_LOGIN);
525: IF (x_mode = 'S') THEN
526: igs_sc_gen_001.set_ctx('R');
527: END IF;
528: INSERT INTO IGS_AD_EDUGOAL (
529: POST_EDUGOAL_ID
530: ,PERSON_ID
531: ,ADMISSION_APPL_NUMBER
532: ,NOMINATED_COURSE_CD

Line 541: IGS_AD_EDUGOALS_S.NEXTVAL

537: ,LAST_UPDATE_DATE
538: ,LAST_UPDATED_BY
539: ,LAST_UPDATE_LOGIN
540: ) VALUES (
541: IGS_AD_EDUGOALS_S.NEXTVAL
542: ,NEW_REFERENCES.PERSON_ID
543: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
544: ,NEW_REFERENCES.NOMINATED_COURSE_CD
545: ,NEW_REFERENCES.SEQUENCE_NUMBER

Line 611: from IGS_AD_EDUGOAL

607: , ADMISSION_APPL_NUMBER
608: , NOMINATED_COURSE_CD
609: , SEQUENCE_NUMBER
610: , EDU_GOAL_ID
611: from IGS_AD_EDUGOAL
612: where ROWID = X_ROWID
613: for update nowait;
614: tlinfo c1%rowtype;
615: begin

Line 700: UPDATE IGS_AD_EDUGOAL set

696: x_last_update_login=>X_LAST_UPDATE_LOGIN);
697: IF (x_mode = 'S') THEN
698: igs_sc_gen_001.set_ctx('R');
699: END IF;
700: UPDATE IGS_AD_EDUGOAL set
701: PERSON_ID = NEW_REFERENCES.PERSON_ID,
702: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
703: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
704: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,

Line 767: cursor c1 is select ROWID from IGS_AD_EDUGOAL

763:
764: (reverse chronological order - newest change first)
765: ***************************************************************/
766:
767: cursor c1 is select ROWID from IGS_AD_EDUGOAL
768: where POST_EDUGOAL_ID= X_POST_EDUGOAL_ID
769: ;
770: begin
771: open c1;

Line 820: DELETE FROM IGS_AD_EDUGOAL

816: );
817: IF (x_mode = 'S') THEN
818: igs_sc_gen_001.set_ctx('R');
819: END IF;
820: DELETE FROM IGS_AD_EDUGOAL
821: WHERE ROWID = X_ROWID;
822: if (sql%notfound) then
823: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
824: igs_ge_msg_stack.add;

Line 857: END igs_ad_edugoal_pkg;

853: ELSE
854: RAISE;
855: END IF;
856: end DELETE_ROW;
857: END igs_ad_edugoal_pkg;