APPS.IGS_PE_TEACH_PERIODS_PKG dependencies on IGS_PE_TEACH_PERIODS_ALL

Line 5: old_references igs_pe_teach_periods_all%RowType;

1: PACKAGE BODY igs_pe_teach_periods_pkg AS
2: /* $Header: IGSNI49B.pls 120.3 2005/10/17 02:20:50 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_teach_periods_all%RowType;
6: new_references igs_pe_teach_periods_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_teach_periods_all%RowType;

2: /* $Header: IGSNI49B.pls 120.3 2005/10/17 02:20:50 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_teach_periods_all%RowType;
6: new_references igs_pe_teach_periods_all%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,--DEFAULT NULL,

Line 39: FROM igs_pe_teach_periods_all

35: ***************************************************************/
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igs_pe_teach_periods_all
40: WHERE rowid = x_rowid;
41:
42: CURSOR cal_type_cur (cp_sequence_number NUMBER) IS
43: SELECT cal_type

Line 201: FROM igs_pe_teach_periods_all

197: ***************************************************************/
198:
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM igs_pe_teach_periods_all
202: WHERE teaching_period_id = x_teaching_period_id
203: FOR UPDATE NOWAIT;
204:
205: lv_rowid cur_rowid%RowType;

Line 242: FROM igs_pe_teach_periods_all load

238: ****************************************************************/
239:
240: CURSOR cur_rowid (cp_cal_type varchar2,cp_person_id number,cp_seq_number number)IS
241: SELECT load.rowid
242: FROM igs_pe_teach_periods_all load
243: WHERE load.person_id = cp_person_id
244: AND load.cal_type = cp_cal_type
245: AND load.sequence_number = cp_seq_number
246: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 280: FROM igs_pe_teach_periods_all

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

Line 467: cursor C is select ROWID from igs_pe_teach_periods_all

463:
464: (reverse chronological order - newest change first)
465: ***************************************************************/
466:
467: cursor C is select ROWID from igs_pe_teach_periods_all
468: where
469: TEACHING_PERIOD_ID= X_TEACHING_PERIOD_ID;
470: X_LAST_UPDATE_DATE DATE ;
471: X_LAST_UPDATED_BY NUMBER ;

Line 513: INSERT INTO igs_pe_teach_periods_all (

509:
510: IF (x_mode = 'S') THEN
511: igs_sc_gen_001.set_ctx('R');
512: END IF;
513: INSERT INTO igs_pe_teach_periods_all (
514: TEACHING_PERIOD_ID
515: ,PERSON_ID
516: ,TEACH_PERIOD_RESID_STAT_CD
517: ,CAL_TYPE

Line 592: FROM igs_pe_teach_periods_all

588: PERSON_ID,
589: TEACH_PERIOD_RESID_STAT_CD,
590: CAL_TYPE,
591: SEQUENCE_NUMBER
592: FROM igs_pe_teach_periods_all
593: WHERE ROWID = X_ROWID
594: FOR UPDATE NOWAIT;
595: tlinfo c1%rowtype;
596:

Line 688: UPDATE igs_pe_teach_periods_all

684:
685: IF (x_mode = 'S') THEN
686: igs_sc_gen_001.set_ctx('R');
687: END IF;
688: UPDATE igs_pe_teach_periods_all
689: SET PERSON_ID = NEW_REFERENCES.PERSON_ID,
690: TEACH_PERIOD_RESID_STAT_CD = NEW_REFERENCES.TEACH_PERIOD_RESID_STAT_CD,
691: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
692: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,

Line 751: FROM igs_pe_teach_periods_all

747: ***************************************************************/
748:
749: CURSOR c1 IS
750: SELECT ROWID
751: FROM igs_pe_teach_periods_all
752: WHERE TEACHING_PERIOD_ID= X_TEACHING_PERIOD_ID;
753:
754: BEGIN
755: OPEN c1;

Line 803: delete from igs_pe_teach_periods_all

799: );
800: IF (x_mode = 'S') THEN
801: igs_sc_gen_001.set_ctx('R');
802: END IF;
803: delete from igs_pe_teach_periods_all
804: where ROWID = X_ROWID;
805: if (sql%notfound) then
806: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
807: igs_ge_msg_stack.add;