APPS.IGS_PS_FACLTY_DEGRS_PKG dependencies on IGS_PS_FACLTY_DEGRS

Line 1: PACKAGE BODY igs_ps_faclty_degrs_pkg AS

1: PACKAGE BODY igs_ps_faclty_degrs_pkg AS
2: /* $Header: IGSPI0OB.pls 120.1 2005/06/28 06:23:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_degrs%RowType;
5: new_references igs_ps_faclty_degrs%RowType;

Line 4: old_references igs_ps_faclty_degrs%RowType;

1: PACKAGE BODY igs_ps_faclty_degrs_pkg AS
2: /* $Header: IGSPI0OB.pls 120.1 2005/06/28 06:23:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_degrs%RowType;
5: new_references igs_ps_faclty_degrs%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_faclty_degrs%RowType;

1: PACKAGE BODY igs_ps_faclty_degrs_pkg AS
2: /* $Header: IGSPI0OB.pls 120.1 2005/06/28 06:23:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_degrs%RowType;
5: new_references igs_ps_faclty_degrs%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PS_FACLTY_DEGRS

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

Line 199: FROM igs_ps_faclty_degrs

195: ***************************************************************/
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_ps_faclty_degrs
200: WHERE faclty_degrd_id = x_faclty_degrd_id
201: FOR UPDATE NOWAIT;
202:
203: lv_rowid cur_rowid%RowType;

Line 238: FROM igs_ps_faclty_degrs

234: ***************************************************************/
235:
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM igs_ps_faclty_degrs
239: WHERE degree_cd = x_degree_cd
240: AND person_id = x_person_id
241: AND program = x_program
242: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 276: FROM igs_ps_faclty_degrs

272: ***************************************************************/
273:
274: CURSOR cur_rowid IS
275: SELECT rowid
276: FROM igs_ps_faclty_degrs
277: WHERE degree_cd = x_degree_cd ;
278:
279: lv_rowid cur_rowid%RowType;
280:

Line 313: FROM igs_ps_faclty_degrs

309: ***************************************************************/
310:
311: CURSOR cur_rowid IS
312: SELECT rowid
313: FROM igs_ps_faclty_degrs
314: WHERE institution_cd = x_institution_cd ;
315:
316: lv_rowid cur_rowid%RowType;
317:

Line 350: FROM igs_ps_faclty_degrs

346: ***************************************************************/
347:
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM igs_ps_faclty_degrs
351: WHERE person_id = x_person_id ;
352:
353: lv_rowid cur_rowid%RowType;
354:

Line 508: cursor C is select ROWID from IGS_PS_FACLTY_DEGRS

504:
505: (reverse chronological order - newest change first)
506: ***************************************************************/
507:
508: cursor C is select ROWID from IGS_PS_FACLTY_DEGRS
509: where FACLTY_DEGRD_ID= X_FACLTY_DEGRD_ID
510: ;
511: X_LAST_UPDATE_DATE DATE ;
512: X_LAST_UPDATED_BY NUMBER ;

Line 551: insert into IGS_PS_FACLTY_DEGRS (

547: x_last_update_login=>X_LAST_UPDATE_LOGIN);
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.set_ctx('R');
550: END IF;
551: insert into IGS_PS_FACLTY_DEGRS (
552: FACLTY_DEGRD_ID
553: ,PERSON_ID
554: ,DEGREE_CD
555: ,PROGRAM

Line 629: from IGS_PS_FACLTY_DEGRS

625: , DEGREE_CD
626: , PROGRAM
627: , INSTITUTION_CD
628: , DEGREE_DATE
629: from IGS_PS_FACLTY_DEGRS
630: where ROWID = X_ROWID
631: for update nowait;
632: tlinfo c1%rowtype;
633: begin

Line 718: update IGS_PS_FACLTY_DEGRS set

714: x_last_update_login=>X_LAST_UPDATE_LOGIN);
715: IF (x_mode = 'S') THEN
716: igs_sc_gen_001.set_ctx('R');
717: END IF;
718: update IGS_PS_FACLTY_DEGRS set
719: PERSON_ID = NEW_REFERENCES.PERSON_ID,
720: DEGREE_CD = NEW_REFERENCES.DEGREE_CD,
721: PROGRAM = NEW_REFERENCES.PROGRAM,
722: INSTITUTION_CD = NEW_REFERENCES.INSTITUTION_CD,

Line 778: cursor c1 is select ROWID from IGS_PS_FACLTY_DEGRS

774:
775: (reverse chronological order - newest change first)
776: ***************************************************************/
777:
778: cursor c1 is select ROWID from IGS_PS_FACLTY_DEGRS
779: where FACLTY_DEGRD_ID= X_FACLTY_DEGRD_ID
780: ;
781: begin
782: open c1;

Line 831: delete from IGS_PS_FACLTY_DEGRS

827: );
828: IF (x_mode = 'S') THEN
829: igs_sc_gen_001.set_ctx('R');
830: END IF;
831: delete from IGS_PS_FACLTY_DEGRS
832: where ROWID = X_ROWID;
833: if (sql%notfound) then
834: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
835: igs_ge_msg_stack.add;

Line 848: END igs_ps_faclty_degrs_pkg;

844: p_action => 'DELETE',
845: x_rowid => X_ROWID
846: );
847: end DELETE_ROW;
848: END igs_ps_faclty_degrs_pkg;