DBA Data[Home] [Help]

APPS.IGS_DA_UTILS_PKG dependencies on IGS_PE_DYNAMIC_PERSID_GROUP

Line 127: -- declare the out param for the funtion IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL

123: --
124: c_stud_grp_mem REF_CUR;
125:
126: --
127: -- declare the out param for the funtion IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL
128: --
129: l_status VARCHAR2(2000);
130:
131: --

Line 218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

214: x_error_code => NULL
215: );
216: ELSE
217: IF l_is_filename_null = 'N' THEN
218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
220: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
221: FND_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;

Line 273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

269: x_error_code => NULL
270: );
271: ELSE
272: IF l_is_filename_null = 'N' THEN
273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
276: FND_MSG_PUB.ADD;
277: RAISE FND_API.G_EXC_ERROR;

Line 332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

328: );
329: END LOOP;
330: ELSE
331: IF l_is_filename_null = 'N' THEN
332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;