APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_AD_PS_APLINSTUNT

Line 21: -- This module updates IGS_AD_PS_APLINSTUNT when

17: p_s_log_type IN VARCHAR2 ,
18: p_creation_dt IN DATE )
19: IS
20: BEGIN -- admp_upd_acaiu_init
21: -- This module updates IGS_AD_PS_APLINSTUNT when
22: -- IGS_AD_PS_APPL_INST are updated when
23: -- initialising an admission period as a result of reconsideration or deferment
24: -- This module is called from IGS_AD_GEN_012.ADMP_UPD_ACAI_RECON and IGS_AD_GEN_012.ADMP_UPD_ACAI_DEFER.
25: DECLARE

Line 34: FROM IGS_AD_PS_APLINSTUNT acaiu,

30: v_log_message_name Varchar2(30);
31: v_message_name VARCHAR2(30);
32: CURSOR c_acaiu_auos IS
33: SELECT acaiu.ROWID, acaiu.*
34: FROM IGS_AD_PS_APLINSTUNT acaiu,
35: IGS_AD_UNIT_OU_STAT auos
36: WHERE
37: acaiu.person_id = p_person_id AND
38: acaiu.admission_appl_number = p_admission_appl_number AND

Line 66: IGS_AD_PS_APLINSTUNT_Pkg.Delete_Row (

62: v_message_name) = FALSE THEN
63: -- UNIT cannot remain, it is no longer valid
64: v_log_message_name := v_message_name;
65:
66: IGS_AD_PS_APLINSTUNT_Pkg.Delete_Row (
67: v_acaiu_rec.RowId
68: );
69:
70: ELSE

Line 88: -- Update this record (IGS_AD_PS_APLINSTUNT)

84: p_offered_ind,
85: v_message_name) = FALSE THEN
86: -- UNIT options must be cleared
87: v_log_message_name := v_message_name;
88: -- Update this record (IGS_AD_PS_APLINSTUNT)
89:
90: IGS_AD_PS_APLINSTUNT_Pkg.Update_Row (
91: X_Mode => 'R',
92: X_RowId => v_acaiu_rec.RowId,

Line 90: IGS_AD_PS_APLINSTUNT_Pkg.Update_Row (

86: -- UNIT options must be cleared
87: v_log_message_name := v_message_name;
88: -- Update this record (IGS_AD_PS_APLINSTUNT)
89:
90: IGS_AD_PS_APLINSTUNT_Pkg.Update_Row (
91: X_Mode => 'R',
92: X_RowId => v_acaiu_rec.RowId,
93: X_Person_Id => v_acaiu_rec.Person_Id,
94: X_Admission_Appl_Number => v_acaiu_rec.Admission_Appl_Number,