APPS.IGS_AD_SPL_TALENTS_PKG dependencies on IGS_AD_SPL_TALENTS

Line 1: PACKAGE BODY igs_ad_spl_talents_pkg AS

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

Line 4: old_references igs_ad_spl_talents%RowType;

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

Line 5: new_references igs_ad_spl_talents%RowType;

1: PACKAGE BODY igs_ad_spl_talents_pkg AS
2: /* $Header: IGSAI97B.pls 120.3 2005/10/03 08:21:07 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_spl_talents%RowType;
5: new_references igs_ad_spl_talents%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_TALENTS

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

Line 183: FROM igs_ad_spl_talents

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

Line 221: FROM igs_ad_spl_talents

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

Line 258: FROM igs_ad_spl_talents

254: ***************************************************************/
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igs_ad_spl_talents
259: WHERE special_talent_type_id = x_code_id ;
260:
261: lv_rowid cur_rowid%RowType;
262:

Line 296: FROM igs_ad_spl_talents

292: ***************************************************************/
293:
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM igs_ad_spl_talents
297: WHERE person_id = x_person_id
298: AND admission_appl_number = x_admission_appl_number;
299:
300: lv_rowid cur_rowid%RowType;

Line 459: cursor C is select ROWID from IGS_AD_SPL_TALENTS

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

Line 516: INSERT INTO IGS_AD_SPL_TALENTS (

512: x_last_update_login=>X_LAST_UPDATE_LOGIN);
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: INSERT INTO IGS_AD_SPL_TALENTS (
517: SPL_TALENT_ID
518: ,PERSON_ID
519: ,ADMISSION_APPL_NUMBER
520: ,SPECIAL_TALENT_TYPE_ID

Line 531: IGS_AD_SPL_TALENTS_S.NEXTVAL

527: ,PROGRAM_ID
528: ,PROGRAM_APPLICATION_ID
529: ,PROGRAM_UPDATE_DATE
530: ) values (
531: IGS_AD_SPL_TALENTS_S.NEXTVAL
532: ,NEW_REFERENCES.PERSON_ID
533: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
534: ,NEW_REFERENCES.SPECIAL_TALENT_TYPE_ID
535: ,X_LAST_UPDATE_DATE

Line 599: from IGS_AD_SPL_TALENTS

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

Line 702: UPDATE IGS_AD_SPL_TALENTS set

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

Line 767: cursor c1 is select ROWID from IGS_AD_SPL_TALENTS

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

Line 817: delete from IGS_AD_SPL_TALENTS

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

Line 853: END igs_ad_spl_talents_pkg;

849: RAISE;
850: END IF;
851: END DELETE_ROW;
852:
853: END igs_ad_spl_talents_pkg;