APPS.IGS_PE_ACAD_HONORS_PKG dependencies on IGS_PE_ACAD_HONORS

Line 1: PACKAGE BODY IGS_PE_ACAD_HONORS_PKG AS

1: PACKAGE BODY IGS_PE_ACAD_HONORS_PKG AS
2: /* $Header: IGSNI99B.pls 120.2 2005/10/17 02:22:26 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_acad_honors%RowType;
5: new_references igs_pe_acad_honors%RowType;

Line 4: old_references igs_pe_acad_honors%RowType;

1: PACKAGE BODY IGS_PE_ACAD_HONORS_PKG AS
2: /* $Header: IGSNI99B.pls 120.2 2005/10/17 02:22:26 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_acad_honors%RowType;
5: new_references igs_pe_acad_honors%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_acad_honors%RowType;

1: PACKAGE BODY IGS_PE_ACAD_HONORS_PKG AS
2: /* $Header: IGSNI99B.pls 120.2 2005/10/17 02:22:26 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_acad_honors%RowType;
5: new_references igs_pe_acad_honors%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 37: FROM igs_pe_acad_honors

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

Line 115: FROM igs_pe_acad_honors

111: ***************************************************************/
112:
113: CURSOR cur_rowid IS
114: SELECT rowid
115: FROM igs_pe_acad_honors
116: WHERE acad_honor_type = x_acad_honor_type
117: AND nvl(honor_date,sysdate) = nvl(x_honor_date,sysdate)
118: AND person_id = x_person_id
119: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 206: FROM igs_pe_acad_honors

202: ***************************************************************/
203:
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_pe_acad_honors
207: WHERE acad_honor_id = x_acad_honor_id
208: FOR UPDATE NOWAIT;
209:
210: lv_rowid cur_rowid%RowType;

Line 359: cursor C is select ROWID from igs_pe_acad_honors

355:
356: (reverse chronological order - newest change first)
357: ***************************************************************/
358:
359: cursor C is select ROWID from igs_pe_acad_honors
360: where ACAD_HONOR_ID= X_ACAD_HONOR_ID;
361:
362: X_LAST_UPDATE_DATE DATE ;
363: X_LAST_UPDATED_BY NUMBER ;

Line 403: SELECT igs_pe_acad_honors_s.nextval

399: end if;
400:
401:
402:
403: SELECT igs_pe_acad_honors_s.nextval
404: INTO X_ACAD_HONOR_ID
405: FROM dual;
406:
407: Before_DML(

Line 426: insert into igs_pe_acad_honors (

422:
423: IF (x_mode = 'S') THEN
424: igs_sc_gen_001.set_ctx('R');
425: END IF;
426: insert into igs_pe_acad_honors (
427: ACAD_HONOR_ID
428: ,PERSON_ID
429: ,COMMENTS
430: ,HONOR_DATE

Line 511: from igs_pe_acad_honors

507: PERSON_ID
508: , ACAD_HONOR_TYPE --changed type_id to cd
509: , COMMENTS
510: , HONOR_DATE
511: from igs_pe_acad_honors
512: where ROWID = X_ROWID
513: for update nowait;
514: tlinfo c1%rowtype;
515: begin

Line 620: update igs_pe_acad_honors set

616:
617: IF (x_mode = 'S') THEN
618: igs_sc_gen_001.set_ctx('R');
619: END IF;
620: update igs_pe_acad_honors set
621: PERSON_ID = NEW_REFERENCES.PERSON_ID,
622: ACAD_HONOR_TYPE = NEW_REFERENCES.ACAD_HONOR_TYPE,--CHANGED HERE
623: COMMENTS = NEW_REFERENCES.COMMENTS,
624: HONOR_DATE = NEW_REFERENCES.HONOR_DATE,

Line 682: cursor c1 is select ROWID from igs_pe_acad_honors

678:
679: (reverse chronological order - newest change first)
680: ***************************************************************/
681:
682: cursor c1 is select ROWID from igs_pe_acad_honors
683: where ACAD_HONOR_ID= X_ACAD_HONOR_ID;
684: begin
685: open c1;
686: fetch c1 into X_ROWID;

Line 733: delete from igs_pe_acad_honors

729: );*/
730: IF (x_mode = 'S') THEN
731: igs_sc_gen_001.set_ctx('R');
732: END IF;
733: delete from igs_pe_acad_honors
734: where ROWID = X_ROWID;
735: if (sql%notfound) then
736: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
737: igs_ge_msg_stack.add;

Line 751: END IGS_PE_ACAD_HONORS_PKG;

747: x_rowid => X_ROWID
748: );
749: end DELETE_ROW;
750:
751: END IGS_PE_ACAD_HONORS_PKG;