eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_CDT_ATT_HIST_PKG dependencies on IGS_RE_CDT_ATT_HIST

Line 1: package body IGS_RE_CDT_ATT_HIST_PKG as

1: package body IGS_RE_CDT_ATT_HIST_PKG as
2: /* $Header: IGSRI03B.pls 120.1 2005/07/04 00:41:15 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 14: old_references IGS_RE_CDT_ATT_HIST_ALL%RowType;

10: --svanukur 13-APR-2004 removed the call to resp_val_cah_strt_dt since this procedure was modified
11: -- to return true in all cases. as part of bug 3544986
12: -------------------------------------------------------------------------------------------
13: l_rowid VARCHAR2(25);
14: old_references IGS_RE_CDT_ATT_HIST_ALL%RowType;
15: new_references IGS_RE_CDT_ATT_HIST_ALL%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,

Line 15: new_references IGS_RE_CDT_ATT_HIST_ALL%RowType;

11: -- to return true in all cases. as part of bug 3544986
12: -------------------------------------------------------------------------------------------
13: l_rowid VARCHAR2(25);
14: old_references IGS_RE_CDT_ATT_HIST_ALL%RowType;
15: new_references IGS_RE_CDT_ATT_HIST_ALL%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_RE_CDT_ATT_HIST_ALL

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

Line 86: v_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE;

82: ) AS
83: v_message_name VARCHAR2(30);
84: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
85: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
86: v_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE;
87: v_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE;
88: BEGIN
89: -- Turn off trigger validation when performing insert of IGS_RE_CANDIDATURE details
90: -- as a result of IGS_PS_COURSE transfer

Line 87: v_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE;

83: v_message_name VARCHAR2(30);
84: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
85: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
86: v_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE;
87: v_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE;
88: BEGIN
89: -- Turn off trigger validation when performing insert of IGS_RE_CANDIDATURE details
90: -- as a result of IGS_PS_COURSE transfer
91: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN

Line 262: FROM IGS_RE_CDT_ATT_HIST_ALL

258: RETURN BOOLEAN
259: AS
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_RE_CDT_ATT_HIST_ALL
263: WHERE person_id = x_person_id
264: AND ca_sequence_number = x_ca_sequence_number
265: AND sequence_number = x_sequence_number
266: FOR UPDATE NOWAIT;

Line 289: FROM IGS_RE_CDT_ATT_HIST_ALL

285: ) AS
286:
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM IGS_RE_CDT_ATT_HIST_ALL
290: WHERE attendance_type = x_attendance_type ;
291:
292: lv_rowid cur_rowid%RowType;
293:

Line 316: FROM IGS_RE_CDT_ATT_HIST_ALL

312: ) AS
313:
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM IGS_RE_CDT_ATT_HIST_ALL
317: WHERE person_id = x_person_id
318: AND ca_sequence_number = x_sequence_number ;
319:
320: lv_rowid cur_rowid%RowType;

Line 427: cursor C is select ROWID from IGS_RE_CDT_ATT_HIST_ALL

423: X_ATTENDANCE_PERCENTAGE in NUMBER,
424: X_MODE in VARCHAR2 default 'R',
425: X_ORG_ID in NUMBER
426: ) as
427: cursor C is select ROWID from IGS_RE_CDT_ATT_HIST_ALL
428: where PERSON_ID = X_PERSON_ID
429: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
430: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
431: X_LAST_UPDATE_DATE DATE;

Line 475: insert into IGS_RE_CDT_ATT_HIST_ALL (

471:
472: IF (x_mode = 'S') THEN
473: igs_sc_gen_001.set_ctx('R');
474: END IF;
475: insert into IGS_RE_CDT_ATT_HIST_ALL (
476: PERSON_ID,
477: CA_SEQUENCE_NUMBER,
478: SEQUENCE_NUMBER,
479: HIST_START_DT,

Line 547: from IGS_RE_CDT_ATT_HIST_ALL

543: HIST_START_DT,
544: HIST_END_DT,
545: ATTENDANCE_TYPE,
546: ATTENDANCE_PERCENTAGE
547: from IGS_RE_CDT_ATT_HIST_ALL
548: where ROWID = X_ROWID
549: for update nowait;
550: tlinfo c1%rowtype;
551:

Line 630: update IGS_RE_CDT_ATT_HIST_ALL set

626:
627: IF (x_mode = 'S') THEN
628: igs_sc_gen_001.set_ctx('R');
629: END IF;
630: update IGS_RE_CDT_ATT_HIST_ALL set
631: HIST_START_DT = NEW_REFERENCES.HIST_START_DT,
632: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
633: ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
634: ATTENDANCE_PERCENTAGE = NEW_REFERENCES.ATTENDANCE_PERCENTAGE,

Line 679: cursor c1 is select rowid from IGS_RE_CDT_ATT_HIST_ALL

675: X_ATTENDANCE_PERCENTAGE in NUMBER,
676: X_MODE in VARCHAR2 default 'R',
677: X_ORG_ID in NUMBER
678: ) as
679: cursor c1 is select rowid from IGS_RE_CDT_ATT_HIST_ALL
680: where PERSON_ID = X_PERSON_ID
681: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
682: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
683: ;

Line 728: delete from IGS_RE_CDT_ATT_HIST_ALL

724:
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.set_ctx('R');
727: END IF;
728: delete from IGS_RE_CDT_ATT_HIST_ALL
729: where ROWID = X_ROWID;
730: if (sql%notfound) then
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;

Line 743: end IGS_RE_CDT_ATT_HIST_PKG;

739:
740:
741: end DELETE_ROW;
742:
743: end IGS_RE_CDT_ATT_HIST_PKG;