APPS.IGS_AD_PS_APINTUNTHS_PKG dependencies on IGS_AD_PS_APINTUNTHS_ALL

Line 4: old_references IGS_AD_PS_APINTUNTHS_ALL%RowType;

1: package body IGS_AD_PS_APINTUNTHS_PKG as
2: /* $Header: IGSAI22B.pls 120.0 2005/06/01 17:43:36 appldev noship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APINTUNTHS_ALL%RowType;
5: new_references IGS_AD_PS_APINTUNTHS_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AD_PS_APINTUNTHS_ALL%RowType;

1: package body IGS_AD_PS_APINTUNTHS_PKG as
2: /* $Header: IGSAI22B.pls 120.0 2005/06/01 17:43:36 appldev noship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APINTUNTHS_ALL%RowType;
5: new_references IGS_AD_PS_APINTUNTHS_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_org_id IN NUMBER,

Line 41: FROM IGS_AD_PS_APINTUNTHS_ALL

37: ) AS
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGS_AD_PS_APINTUNTHS_ALL
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 196: FROM IGS_AD_PS_APINTUNTHS_ALL

192: RETURN BOOLEAN
193: AS
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM IGS_AD_PS_APINTUNTHS_ALL
197: WHERE adm_ps_appl_inst_unit_hist_id = x_adm_ps_appl_inst_unithist_id
198: FOR UPDATE NOWAIT;
199:
200: lv_rowid cur_rowid%RowType;

Line 224: FROM IGS_AD_PS_APINTUNTHS_ALL

220: RETURN BOOLEAN
221: AS
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM IGS_AD_PS_APINTUNTHS_ALL
225: WHERE adm_ps_appl_inst_unit_id = x_adm_ps_appl_inst_unit_id
226: AND hist_start_dt = x_hist_start_dt
227: AND (l_rowid IS NULL OR rowid <> l_rowid)
228: FOR UPDATE NOWAIT;

Line 397: cursor C is select ROWID, ADM_PS_APPL_INST_UNIT_HIST_ID from IGS_AD_PS_APINTUNTHS_ALL

393: X_MODE in VARCHAR2,
394: x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
395: x_adm_ps_appl_inst_unithist_id IN OUT NOCOPY NUMBER
396: ) AS
397: cursor C is select ROWID, ADM_PS_APPL_INST_UNIT_HIST_ID from IGS_AD_PS_APINTUNTHS_ALL
398: where ADM_PS_APPL_INST_UNIT_ID = X_ADM_PS_APPL_INST_UNIT_ID
399: and HIST_START_DT = X_HIST_START_DT;
400: X_LAST_UPDATE_DATE DATE;
401: X_LAST_UPDATED_BY NUMBER;

Line 454: insert into IGS_AD_PS_APINTUNTHS_ALL (

450: x_adm_ps_appl_inst_unit_id => X_ADM_PS_APPL_INST_UNIT_ID,
451: x_adm_ps_appl_inst_unithist_id => X_ADM_PS_APPL_INST_UNITHIST_ID
452: );
453:
454: insert into IGS_AD_PS_APINTUNTHS_ALL (
455: ORG_ID,
456: PERSON_ID,
457: ADMISSION_APPL_NUMBER,
458: NOMINATED_COURSE_CD,

Line 582: from IGS_AD_PS_APINTUNTHS_ALL

578: RULE_WAIVED_DT,
579: RULE_WAIVED_PERSON_ID,
580: SUP_UNIT_CD,
581: SUP_UV_VERSION_NUMBER
582: from IGS_AD_PS_APINTUNTHS_ALL
583: where ROWID = X_ROWID for update nowait;
584: tlinfo c1%rowtype;
585:
586: begin

Line 725: update IGS_AD_PS_APINTUNTHS_ALL set

721: x_adm_ps_appl_inst_unit_id => X_ADM_PS_APPL_INST_UNIT_ID,
722: x_adm_ps_appl_inst_unithist_id => X_ADM_PS_APPL_INST_UNITHIST_ID
723: );
724:
725: update IGS_AD_PS_APINTUNTHS_ALL set
726: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
727: HIST_WHO = NEW_REFERENCES.HIST_WHO,
728: UV_VERSION_NUMBER = NEW_REFERENCES.UV_VERSION_NUMBER,
729: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

Line 799: cursor c1 is select rowid from IGS_AD_PS_APINTUNTHS_ALL

795: X_MODE in VARCHAR2,
796: x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
797: x_adm_ps_appl_inst_unithist_id IN OUT NOCOPY NUMBER
798: ) AS
799: cursor c1 is select rowid from IGS_AD_PS_APINTUNTHS_ALL
800: where adm_ps_appl_inst_unit_hist_id = x_adm_ps_appl_inst_unithist_id
801: ;
802:
803: begin

Line 880: delete from IGS_AD_PS_APINTUNTHS_ALL

876: x_rowid => X_ROWID
877: );
878: -- set default value
879: v_message_name := null;
880: delete from IGS_AD_PS_APINTUNTHS_ALL
881: where ROWID = X_ROWID;
882: if (sql%notfound) then
883: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
884: IGS_GE_MSG_STACK.ADD;