APPS.IGS_AD_PS_APLINSTHST_PKG dependencies on IGS_AD_PS_APLINSTHST_ALL

Line 4: old_references IGS_AD_PS_APLINSTHST_ALL%RowType;

1: PACKAGE BODY IGS_AD_PS_APLINSTHST_PKG AS
2: /* $Header: IGSAI19B.pls 120.2 2005/09/21 00:32:55 appldev ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APLINSTHST_ALL%RowType;
5: new_references IGS_AD_PS_APLINSTHST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PS_APLINSTHST_ALL%RowType;

1: PACKAGE BODY IGS_AD_PS_APLINSTHST_PKG AS
2: /* $Header: IGSAI19B.pls 120.2 2005/09/21 00:32:55 appldev ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APLINSTHST_ALL%RowType;
5: new_references IGS_AD_PS_APLINSTHST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 85: FROM IGS_AD_PS_APLINSTHST_ALL

81: ) AS
82:
83: CURSOR cur_old_ref_values IS
84: SELECT *
85: FROM IGS_AD_PS_APLINSTHST_ALL
86: WHERE rowid = x_rowid;
87:
88: BEGIN
89:

Line 760: FROM IGS_AD_PS_APLINSTHST_ALL

756: RETURN BOOLEAN
757: AS
758: CURSOR cur_rowid IS
759: SELECT rowid
760: FROM IGS_AD_PS_APLINSTHST_ALL
761: WHERE person_id = x_person_id
762: AND admission_appl_number = x_admission_appl_number
763: AND nominated_course_cd = x_nominated_course_cd
764: AND sequence_number = x_sequence_number

Line 1050: cursor C is select ROWID from IGS_AD_PS_APLINSTHST_ALL

1046: X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
1047: X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
1048: X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
1049: ) as
1050: cursor C is select ROWID from IGS_AD_PS_APLINSTHST_ALL
1051: where PERSON_ID = X_PERSON_ID
1052: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
1053: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
1054: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 1156: insert into IGS_AD_PS_APLINSTHST_ALL (

1152: x_reconsider_flag => x_reconsider_flag ,
1153: x_decline_ofr_reason => x_decline_ofr_reason -- end apadegal td001 igsm
1154: );
1155:
1156: insert into IGS_AD_PS_APLINSTHST_ALL (
1157: ORG_ID,
1158: APPLICANT_ACPTNCE_CNDTN,
1159: CNDTNL_OFFER_CNDTN,
1160: PERSON_ID,

Line 1461: from IGS_AD_PS_APLINSTHST_ALL

1457: DEF_ACAD_CAL_TYPE ,
1458: DEF_ACAD_CI_SEQUENCE_NUM ,
1459: RECONSIDER_FLAG ,
1460: DECLINE_OFR_REASON -- end APADEGAL adtd001 igs.m
1461: from IGS_AD_PS_APLINSTHST_ALL
1462: where ROWID = X_ROWID for update nowait;
1463: tlinfo c1%rowtype;
1464:
1465: begin

Line 1846: update IGS_AD_PS_APLINSTHST_ALL set

1842: x_reconsider_flag => x_reconsider_flag ,
1843: x_decline_ofr_reason => x_decline_ofr_reason -- end apadegal td001 igsm
1844: );
1845:
1846: update IGS_AD_PS_APLINSTHST_ALL set
1847: APPLICANT_ACPTNCE_CNDTN = NEW_REFERENCES.APPLICANT_ACPTNCE_CNDTN,
1848: CNDTNL_OFFER_CNDTN = NEW_REFERENCES.CNDTNL_OFFER_CNDTN,
1849: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
1850: HIST_WHO = NEW_REFERENCES.HIST_WHO,

Line 2010: cursor c1 is select rowid from IGS_AD_PS_APLINSTHST_ALL

2006: X_DEF_ACAD_CI_SEQUENCE_NUM NUMBER DEFAULT NULL,
2007: X_RECONSIDER_FLAG VARCHAR2 DEFAULT NULL,
2008: X_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
2009: ) as
2010: cursor c1 is select rowid from IGS_AD_PS_APLINSTHST_ALL
2011: where PERSON_ID = X_PERSON_ID
2012: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
2013: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
2014: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 2176: delete from IGS_AD_PS_APLINSTHST_ALL

2172: Before_DML(
2173: p_action =>'DELETE',
2174: x_rowid => X_ROWID
2175: );
2176: delete from IGS_AD_PS_APLINSTHST_ALL
2177: where ROWID = X_ROWID;
2178: if (sql%notfound) then
2179: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2180: IGS_GE_MSG_STACK.ADD;