APPS.IGS_AD_SPL_INTERESTS_PKG dependencies on IGS_AD_SPL_INTERESTS

Line 1: PACKAGE BODY igs_ad_spl_interests_pkg AS

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

Line 4: old_references igs_ad_spl_interests%RowType;

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

Line 5: new_references igs_ad_spl_interests%RowType;

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

Line 34: FROM IGS_AD_SPL_INTERESTS

30: ***************************************************************/
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_AD_SPL_INTERESTS
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 183: FROM igs_ad_spl_interests

179: ***************************************************************/
180:
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_ad_spl_interests
184: WHERE spl_interest_id = x_spl_interest_id
185: FOR UPDATE NOWAIT;
186:
187: lv_rowid cur_rowid%RowType;

Line 221: FROM igs_ad_spl_interests

217: ***************************************************************/
218:
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM igs_ad_spl_interests
222: WHERE special_interest_type_id = x_special_interest_type_id
223: AND person_id = x_person_id
224: AND admission_appl_number = x_admission_appl_number
225: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 258: FROM igs_ad_spl_interests

254: ***************************************************************/
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igs_ad_spl_interests
259: WHERE person_id = x_person_id
260: AND admission_appl_number = x_admission_appl_number;
261:
262: lv_rowid cur_rowid%RowType;

Line 296: FROM igs_ad_spl_interests

292: ***************************************************************/
293:
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM igs_ad_spl_interests
297: WHERE special_interest_type_id = x_code_id ;
298:
299: lv_rowid cur_rowid%RowType;
300:

Line 458: cursor C is select ROWID from IGS_AD_SPL_INTERESTS

454:
455: (reverse chronological order - newest change first)
456: ***************************************************************/
457:
458: cursor C is select ROWID from IGS_AD_SPL_INTERESTS
459: where SPL_INTEREST_ID= X_SPL_INTEREST_ID
460: ;
461: X_LAST_UPDATE_DATE DATE ;
462: X_LAST_UPDATED_BY NUMBER ;

Line 515: insert into IGS_AD_SPL_INTERESTS (

511: x_last_update_login=>X_LAST_UPDATE_LOGIN);
512: IF (x_mode = 'S') THEN
513: igs_sc_gen_001.set_ctx('R');
514: END IF;
515: insert into IGS_AD_SPL_INTERESTS (
516: SPL_INTEREST_ID
517: ,PERSON_ID
518: ,ADMISSION_APPL_NUMBER
519: ,SPECIAL_INTEREST_TYPE_ID

Line 530: IGS_AD_SPL_INTERESTS_S.NEXTVAL

526: ,PROGRAM_ID
527: ,PROGRAM_APPLICATION_ID
528: ,PROGRAM_UPDATE_DATE
529: ) values (
530: IGS_AD_SPL_INTERESTS_S.NEXTVAL
531: ,NEW_REFERENCES.PERSON_ID
532: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
533: ,NEW_REFERENCES.SPECIAL_INTEREST_TYPE_ID
534: ,X_LAST_UPDATE_DATE

Line 599: from IGS_AD_SPL_INTERESTS

595: cursor c1 is select
596: PERSON_ID
597: , ADMISSION_APPL_NUMBER
598: , SPECIAL_INTEREST_TYPE_ID
599: from IGS_AD_SPL_INTERESTS
600: where ROWID = X_ROWID
601: for update nowait;
602: tlinfo c1%rowtype;
603: begin

Line 702: update IGS_AD_SPL_INTERESTS set

698:
699: IF (x_mode = 'S') THEN
700: igs_sc_gen_001.set_ctx('R');
701: END IF;
702: update IGS_AD_SPL_INTERESTS set
703: PERSON_ID = NEW_REFERENCES.PERSON_ID,
704: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
705: SPECIAL_INTEREST_TYPE_ID = NEW_REFERENCES.SPECIAL_INTEREST_TYPE_ID,
706: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 766: cursor c1 is select ROWID from IGS_AD_SPL_INTERESTS

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

Line 816: delete from IGS_AD_SPL_INTERESTS

812: );
813: IF (x_mode = 'S') THEN
814: igs_sc_gen_001.set_ctx('R');
815: END IF;
816: delete from IGS_AD_SPL_INTERESTS
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 854: END igs_ad_spl_interests_pkg;

850: RAISE;
851: END IF;
852: end DELETE_ROW;
853:
854: END igs_ad_spl_interests_pkg;