APPS.IGS_AD_CAL_CONF_PKG dependencies on IGS_AD_CAL_CONF

Line 1: package body IGS_AD_CAL_CONF_PKG as

1: package body IGS_AD_CAL_CONF_PKG as
2: /* $Header: IGSAI70B.pls 115.7 2002/11/28 22:13:48 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAL_CONF%RowType;

Line 5: old_references IGS_AD_CAL_CONF%RowType;

1: package body IGS_AD_CAL_CONF_PKG as
2: /* $Header: IGSAI70B.pls 115.7 2002/11/28 22:13:48 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAL_CONF%RowType;
6: new_references IGS_AD_CAL_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_CAL_CONF%RowType;

2: /* $Header: IGSAI70B.pls 115.7 2002/11/28 22:13:48 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CAL_CONF%RowType;
6: new_references IGS_AD_CAL_CONF%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_AD_CAL_CONF

31: ) AS
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_AD_CAL_CONF
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 569: FROM IGS_AD_CAL_CONF

565: )return BOOLEAN AS
566:
567: CURSOR cur_rowid IS
568: SELECT rowid
569: FROM IGS_AD_CAL_CONF
570: WHERE s_control_num = x_s_control_num
571: FOR UPDATE NOWAIT;
572: lv_rowid cur_rowid%RowType;
573:

Line 594: FROM IGS_AD_CAL_CONF

590: ) AS
591:
592: CURSOR cur_rowid IS
593: SELECT rowid
594: FROM IGS_AD_CAL_CONF
595: WHERE adm_appl_course_strt_dt_alias = x_dt_alias
596: OR adm_appl_final_dt_alias = x_dt_alias
597: OR adm_appl_due_dt_alias = x_dt_alias
598: OR adm_appl_encmb_chk_dt_alias = x_dt_alias

Line 632: FROM IGS_AD_CAL_CONF

628: ) AS
629:
630: CURSOR cur_rowid IS
631: SELECT rowid
632: FROM IGS_AD_CAL_CONF
633: WHERE inq_cal_type = x_cal_type;
634:
635: lv_rowid cur_rowid%RowType;
636:

Line 765: cursor C is select ROWID from IGS_AD_CAL_CONF

761: X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
762: X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
763: X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
764: ) AS
765: cursor C is select ROWID from IGS_AD_CAL_CONF
766: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
767: X_LAST_UPDATE_DATE DATE;
768: X_LAST_UPDATED_BY NUMBER;
769: X_LAST_UPDATE_LOGIN NUMBER;

Line 815: insert into IGS_AD_CAL_CONF (

811: X_POST_ADM_TRK_DT_ALIAS => X_POST_ADM_TRK_DT_ALIAS,
812: X_INQ_CAL_TYPE => X_INQ_CAL_TYPE
813: );
814:
815: insert into IGS_AD_CAL_CONF (
816: S_CONTROL_NUM,
817: INITIALISE_ADM_PERD_DT_ALIAS,
818: ADM_APPL_ENCMB_CHK_DT_ALIAS,
819: ADM_APPL_COURSE_STRT_DT_ALIAS,

Line 906: from IGS_AD_CAL_CONF

902: ADM_APPL_S_COMP_PERD_DT_ALIAS,
903: ADM_PRC_TRK_DT_ALIAS,
904: POST_ADM_TRK_DT_ALIAS,
905: INQ_CAL_TYPE
906: from IGS_AD_CAL_CONF
907: where ROWID = X_ROWID for update nowait;
908: tlinfo c1%rowtype;
909:
910: begin

Line 1041: update IGS_AD_CAL_CONF set

1037: X_POST_ADM_TRK_DT_ALIAS => X_POST_ADM_TRK_DT_ALIAS,
1038: X_INQ_CAL_TYPE => X_INQ_CAL_TYPE
1039: );
1040:
1041: update IGS_AD_CAL_CONF set
1042: INITIALISE_ADM_PERD_DT_ALIAS = NEW_REFERENCES.INITIALISE_ADM_PERD_DT_ALIAS,
1043: ADM_APPL_ENCMB_CHK_DT_ALIAS = NEW_REFERENCES.ADM_APPL_ENCMB_CHK_DT_ALIAS,
1044: ADM_APPL_COURSE_STRT_DT_ALIAS = NEW_REFERENCES.ADM_APPL_COURSE_STRT_DT_ALIAS,
1045: ADM_APPL_SHORT_STRT_DT_ALIAS = NEW_REFERENCES.ADM_APPL_SHORT_STRT_DT_ALIAS,

Line 1090: cursor c1 is select rowid from IGS_AD_CAL_CONF

1086: X_ADM_PRC_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
1087: X_POST_ADM_TRK_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
1088: X_INQ_CAL_TYPE IN VARCHAR2 DEFAULT NULL
1089: ) AS
1090: cursor c1 is select rowid from IGS_AD_CAL_CONF
1091: where S_CONTROL_NUM = NVL(X_S_CONTROL_NUM,1);
1092:
1093: begin
1094: open c1;

Line 1149: delete from IGS_AD_CAL_CONF

1145: Before_DML (
1146: p_action => 'DELETE',
1147: x_rowid => X_ROWID);
1148:
1149: delete from IGS_AD_CAL_CONF
1150: where ROWID = X_ROWID;
1151: if (sql%notfound) then
1152: raise no_data_found;
1153: end if;

Line 1161: end IGS_AD_CAL_CONF_PKG;

1157: x_rowid => X_ROWID);
1158:
1159: end DELETE_ROW;
1160:
1161: end IGS_AD_CAL_CONF_PKG;