APPS.IGS_AD_OTHER_INST_PKG dependencies on IGS_AD_OTHER_INST

Line 1: PACKAGE BODY igs_ad_other_inst_pkg AS

1: PACKAGE BODY igs_ad_other_inst_pkg AS
2: /* $Header: IGSAI99B.pls 120.5 2005/12/06 02:41:28 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_other_inst%RowType;
5: new_references igs_ad_other_inst%RowType;

Line 4: old_references igs_ad_other_inst%RowType;

1: PACKAGE BODY igs_ad_other_inst_pkg AS
2: /* $Header: IGSAI99B.pls 120.5 2005/12/06 02:41:28 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_other_inst%RowType;
5: new_references igs_ad_other_inst%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_other_inst%RowType;

1: PACKAGE BODY igs_ad_other_inst_pkg AS
2: /* $Header: IGSAI99B.pls 120.5 2005/12/06 02:41:28 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_other_inst%RowType;
5: new_references igs_ad_other_inst%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_AD_OTHER_INST

34: ***************************************************************/
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_AD_OTHER_INST
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 198: FROM igs_ad_other_inst

194: ***************************************************************/
195:
196: CURSOR cur_rowid IS
197: SELECT rowid
198: FROM igs_ad_other_inst
199: WHERE other_inst_id = x_other_inst_id
200: FOR UPDATE NOWAIT;
201:
202: lv_rowid cur_rowid%RowType;

Line 240: FROM igs_ad_other_inst

236: ***************************************************************/
237:
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM igs_ad_other_inst
241: WHERE admission_appl_number = x_admission_appl_number
242: AND institution_code = x_institution_code
243: AND person_id = x_person_id
244: AND NVL(new_institution,'-1') = NVL(x_new_institution,'-1')

Line 280: FROM igs_ad_other_inst

276: ***************************************************************/
277:
278: CURSOR cur_rowid IS
279: SELECT rowid
280: FROM igs_ad_other_inst
281: WHERE person_id = x_person_id
282: AND admission_appl_number = x_admission_appl_number;
283:
284: lv_rowid cur_rowid%RowType;

Line 318: FROM igs_ad_other_inst

314: ***************************************************************/
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM igs_ad_other_inst
319: WHERE institution_code = x_institution_cd ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 489: cursor C is select ROWID from IGS_AD_OTHER_INST

485: nominated_course_cd and
486: sequence_number
487: ***************************************************************/
488:
489: cursor C is select ROWID from IGS_AD_OTHER_INST
490: where OTHER_INST_ID= X_OTHER_INST_ID;
491:
492: X_LAST_UPDATE_DATE DATE ;
493: X_LAST_UPDATED_BY NUMBER ;

Line 548: insert into IGS_AD_OTHER_INST (

544:
545: IF (x_mode = 'S') THEN
546: igs_sc_gen_001.set_ctx('R');
547: END IF;
548: insert into IGS_AD_OTHER_INST (
549: OTHER_INST_ID
550: ,PERSON_ID
551: ,ADMISSION_APPL_NUMBER
552: ,INSTITUTION_CODE

Line 564: IGS_AD_OTHER_INST_S.NEXTVAL

560: ,PROGRAM_APPLICATION_ID
561: ,PROGRAM_UPDATE_DATE
562: ,NEW_INSTITUTION
563: ) values (
564: IGS_AD_OTHER_INST_S.NEXTVAL
565: ,NEW_REFERENCES.PERSON_ID
566: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
567: ,NEW_REFERENCES.INSTITUTION_CODE
568: ,X_LAST_UPDATE_DATE

Line 638: from IGS_AD_OTHER_INST

634: cursor c1 is select
635: PERSON_ID
636: , ADMISSION_APPL_NUMBER
637: , INSTITUTION_CODE
638: from IGS_AD_OTHER_INST
639: where ROWID = X_ROWID
640: for update nowait;
641: tlinfo c1%rowtype;
642: begin

Line 746: update IGS_AD_OTHER_INST set

742:
743: IF (x_mode = 'S') THEN
744: igs_sc_gen_001.set_ctx('R');
745: END IF;
746: update IGS_AD_OTHER_INST set
747: PERSON_ID = NEW_REFERENCES.PERSON_ID,
748: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
749: INSTITUTION_CODE = NEW_REFERENCES.INSTITUTION_CODE,
750: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 816: cursor c1 is select ROWID from IGS_AD_OTHER_INST

812: nominated_course_cd and
813: sequence_number
814: ***************************************************************/
815:
816: cursor c1 is select ROWID from IGS_AD_OTHER_INST
817: where OTHER_INST_ID= X_OTHER_INST_ID;
818: begin
819: open c1;
820: fetch c1 into X_ROWID;

Line 866: delete from IGS_AD_OTHER_INST

862: );
863: IF (x_mode = 'S') THEN
864: igs_sc_gen_001.set_ctx('R');
865: END IF;
866: delete from IGS_AD_OTHER_INST
867: where ROWID = X_ROWID;
868: if (sql%notfound) then
869: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
870: igs_ge_msg_stack.add;

Line 902: END igs_ad_other_inst_pkg;

898: RAISE;
899: END IF;
900: end DELETE_ROW;
901:
902: END igs_ad_other_inst_pkg;