DBA Data[Home] [Help]

APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_PE_DYNAMIC_PERSID_GROUP

Line 396: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status, l_group_type);

392: -- and implemented new associated logic.
393:
394: IF p_person_id_grp IS NOT NULL THEN
395:
396: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status, l_group_type);
397:
398: IF l_prs_grp_status <> 'S' THEN
399: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');
400: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);

Line 943: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status, l_group_type);

939: END IF;
940:
941: -- Person ID Group filtering
942: IF p_person_id_grp IS NOT NULL THEN
943: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status, l_group_type);
944:
945: IF l_prs_grp_status <> 'S' THEN
946: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');
947: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);