APPS.IGS_AD_ACAD_INTEREST_PKG dependencies on IGS_AD_ACAD_INTEREST

Line 1: PACKAGE BODY igs_ad_acad_interest_pkg AS

1: PACKAGE BODY igs_ad_acad_interest_pkg AS
2: /* $Header: IGSAI95B.pls 120.3 2005/10/03 08:20:26 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_acad_interest%RowType;
5: new_references igs_ad_acad_interest%RowType;

Line 4: old_references igs_ad_acad_interest%RowType;

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

Line 5: new_references igs_ad_acad_interest%RowType;

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

Line 36: FROM IGS_AD_ACAD_INTEREST

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

Line 179: FROM igs_ad_acad_interest

175: ***************************************************************/
176:
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM igs_ad_acad_interest
180: WHERE acad_interest_id = x_acad_interest_id
181: FOR UPDATE NOWAIT;
182:
183: lv_rowid cur_rowid%RowType;

Line 218: FROM igs_ad_acad_interest

214: ***************************************************************/
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM igs_ad_acad_interest
219: WHERE admission_appl_number = x_admission_appl_number
220: AND field_of_study = x_field_of_study
221: AND person_id = x_person_id
222: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 254: FROM igs_ad_acad_interest

250: ***************************************************************/
251:
252: CURSOR cur_rowid IS
253: SELECT rowid
254: FROM igs_ad_acad_interest
255: WHERE field_of_study = x_field_of_study ;
256:
257: lv_rowid cur_rowid%RowType;
258:

Line 293: FROM igs_ad_acad_interest

289: ***************************************************************/
290:
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM igs_ad_acad_interest
294: WHERE person_id = x_person_id
295: AND admission_appl_number = x_admission_appl_number;
296:
297: lv_rowid cur_rowid%RowType;

Line 455: cursor C is select ROWID from IGS_AD_ACAD_INTEREST

451:
452: (reverse chronological order - newest change first)
453: ***************************************************************/
454:
455: cursor C is select ROWID from IGS_AD_ACAD_INTEREST
456: where ACAD_INTEREST_ID= X_ACAD_INTEREST_ID
457: ;
458: X_LAST_UPDATE_DATE DATE ;
459: X_LAST_UPDATED_BY NUMBER ;

Line 512: insert into IGS_AD_ACAD_INTEREST (

508: x_last_update_login=>X_LAST_UPDATE_LOGIN);
509: IF (x_mode = 'S') THEN
510: igs_sc_gen_001.set_ctx('R');
511: END IF;
512: insert into IGS_AD_ACAD_INTEREST (
513: ACAD_INTEREST_ID
514: ,PERSON_ID
515: ,ADMISSION_APPL_NUMBER
516: ,FIELD_OF_STUDY

Line 527: IGS_AD_ACAD_INTEREST_S.NEXTVAL

523: ,PROGRAM_ID
524: ,PROGRAM_APPLICATION_ID
525: ,PROGRAM_UPDATE_DATE
526: ) values (
527: IGS_AD_ACAD_INTEREST_S.NEXTVAL
528: ,NEW_REFERENCES.PERSON_ID
529: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
530: ,NEW_REFERENCES.FIELD_OF_STUDY
531: ,X_LAST_UPDATE_DATE

Line 596: from IGS_AD_ACAD_INTEREST

592: cursor c1 is select
593: PERSON_ID
594: , ADMISSION_APPL_NUMBER
595: , FIELD_OF_STUDY
596: from IGS_AD_ACAD_INTEREST
597: where ROWID = X_ROWID
598: for update nowait;
599: tlinfo c1%rowtype;
600: begin

Line 699: update IGS_AD_ACAD_INTEREST set

695:
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: update IGS_AD_ACAD_INTEREST set
700: PERSON_ID = NEW_REFERENCES.PERSON_ID,
701: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
702: FIELD_OF_STUDY = NEW_REFERENCES.FIELD_OF_STUDY,
703: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 766: cursor c1 is select ROWID from IGS_AD_ACAD_INTEREST

762:
763: (reverse chronological order - newest change first)
764: ***************************************************************/
765:
766: cursor c1 is select ROWID from IGS_AD_ACAD_INTEREST
767: where ACAD_INTEREST_ID= X_ACAD_INTEREST_ID
768: ;
769: begin
770: open c1;

Line 816: DELETE from IGS_AD_ACAD_INTEREST

812: );
813: IF (x_mode = 'S') THEN
814: igs_sc_gen_001.set_ctx('R');
815: END IF;
816: DELETE from IGS_AD_ACAD_INTEREST
817: WHERE ROWID = X_ROWID;
818: IF (sql%notfound) THEN
819: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
820: igs_ge_msg_stack.add;

Line 853: END igs_ad_acad_interest_pkg;

849: ELSE
850: RAISE;
851: END IF;
852: end DELETE_ROW;
853: END igs_ad_acad_interest_pkg;