APPS.IGS_AD_APPL_HIST_PKG dependencies on IGS_AD_APPL_HIST_ALL

Line 4: old_references IGS_AD_APPL_HIST_ALL%RowType;

1: PACKAGE BODY IGS_AD_APPL_HIST_PKG AS
2: /* $Header: IGSAI05B.pls 120.0 2005/06/03 15:52:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_HIST_ALL%RowType;
5: new_references IGS_AD_APPL_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_APPL_HIST_ALL%RowType;

1: PACKAGE BODY IGS_AD_APPL_HIST_PKG AS
2: /* $Header: IGSAI05B.pls 120.0 2005/06/03 15:52:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_HIST_ALL%RowType;
5: new_references IGS_AD_APPL_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_AD_APPL_HIST_ALL

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

Line 192: FROM IGS_AD_APPL_HIST_ALL

188: RETURN BOOLEAN AS
189:
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM IGS_AD_APPL_HIST_ALL
193: WHERE person_id = x_person_id
194: AND admission_appl_number = x_admission_appl_number
195: AND hist_start_dt = x_hist_start_dt
196: FOR UPDATE NOWAIT;

Line 361: cursor C is select ROWID from IGS_AD_APPL_HIST_ALL

357: X_ADM_FEE_STATUS in VARCHAR2,
358: X_TAC_APPL_IND in VARCHAR2,
359: X_MODE in VARCHAR2
360: ) as
361: cursor C is select ROWID from IGS_AD_APPL_HIST_ALL
362: where PERSON_ID = X_PERSON_ID
363: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
364: and HIST_START_DT = X_HIST_START_DT;
365: X_LAST_UPDATE_DATE DATE;

Line 414: insert into IGS_AD_APPL_HIST_ALL (

410: x_last_update_login=> X_LAST_UPDATE_LOGIN
411: );
412:
413:
414: insert into IGS_AD_APPL_HIST_ALL (
415: PERSON_ID,
416: ORG_ID,
417: ADMISSION_APPL_NUMBER,
418: HIST_START_DT,

Line 520: from IGS_AD_APPL_HIST_ALL

516: S_ADMISSION_PROCESS_TYPE,
517: ADM_APPL_STATUS,
518: ADM_FEE_STATUS,
519: TAC_APPL_IND
520: from IGS_AD_APPL_HIST_ALL
521: where ROWID = X_ROWID
522: for update nowait;
523: tlinfo c1%rowtype;
524:

Line 646: update IGS_AD_APPL_HIST_ALL set

642: x_last_update_login=> X_LAST_UPDATE_LOGIN
643: );
644:
645:
646: update IGS_AD_APPL_HIST_ALL set
647: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
648: HIST_WHO = NEW_REFERENCES.HIST_WHO,
649: APPL_DT = NEW_REFERENCES.APPL_DT,
650: ACAD_CAL_TYPE = NEW_REFERENCES.ACAD_CAL_TYPE,

Line 711: cursor c1 is select rowid from IGS_AD_APPL_HIST_ALL

707: X_ADM_FEE_STATUS in VARCHAR2,
708: X_TAC_APPL_IND in VARCHAR2,
709: X_MODE in VARCHAR2
710: ) as
711: cursor c1 is select rowid from IGS_AD_APPL_HIST_ALL
712: where PERSON_ID = X_PERSON_ID
713: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
714: and HIST_START_DT = X_HIST_START_DT
715: ;

Line 772: delete from IGS_AD_APPL_HIST_ALL

768: p_action => 'DELETE',
769: x_rowid => X_ROWID
770: );
771:
772: delete from IGS_AD_APPL_HIST_ALL
773: where ROWID = X_ROWID;
774: if (sql%notfound) then
775: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
776: IGS_GE_MSG_STACK.ADD;