APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_PRIV_LEVEL_PKG

Line 125: igs_pe_priv_level_pkg.update_row(

121: IF p_mode='UPDATE' THEN
122: OPEN c_rowid (p_privacy_level_id);
123: FETCH c_rowid INTO l_rowid, l_ref_notes_id;
124: CLOSE c_rowid;
125: igs_pe_priv_level_pkg.update_row(
126: X_ROWID => l_rowid,
127: X_PRIVACY_LEVEL_ID => p_privacy_level_id,
128: X_PERSON_ID => p_person_id ,
129: X_DATA_GROUP => l_data_group ,

Line 138: igs_pe_priv_level_pkg.insert_row(

134: X_REF_NOTES_ID => l_ref_notes_id,
135: X_START_DATE => p_start_date ,
136: X_END_DATE => p_end_date );
137: ELSIF p_mode='INSERT' THEN
138: igs_pe_priv_level_pkg.insert_row(
139: X_ROWID => l_rowid,
140: X_PRIVACY_LEVEL_ID => x_privacy_level_id,
141: X_PERSON_ID => p_person_id ,
142: X_DATA_GROUP => l_data_group ,

Line 156: igs_pe_priv_level_pkg.delete_row(

152: FETCH c_rowid INTO l_rowid, l_ref_notes_id;
153: CLOSE c_rowid;
154: --kumma, 2902713, Added the following IF clause , as row id could be null
155: IF l_rowid IS NOT NULL THEN
156: igs_pe_priv_level_pkg.delete_row(
157: X_ROWID => l_rowid);
158: END IF;
159:
160: ELSIF p_mode='LOCK' THEN

Line 165: Igs_Pe_Priv_Level_Pkg.Lock_Row (

161: OPEN c_rowid(p_privacy_level_id);
162: FETCH c_rowid INTO l_rowid, l_ref_notes_id;
163: CLOSE c_rowid;
164:
165: Igs_Pe_Priv_Level_Pkg.Lock_Row (
166: X_RowId => l_rowid,
167: X_Privacy_Level_Id => p_privacy_level_id,
168: X_Person_Id => p_person_id,
169: X_Data_Group => l_data_group,