APPS.IGS_AZ_GEN_001 dependencies on IGS_PE_DYNAMIC_PERSID_GROUP

Line 55: -- Declare the out param for the funtion IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL

51: cur_adv_to_add ref_cur;
52: cur_std_to_del ref_cur;
53: cur_adv_to_del ref_cur;
54: --
55: -- Declare the out param for the funtion IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL
56: --
57: l_status VARCHAR2 (2000);
58: --
59: -- Cursor to check whether dynamic person_id_group has to be used or not based on the value

Line 343: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

339: -- Loop through all the students who are suggested to be added to the group..
340: --
341: IF l_std_is_filename_null = 'N' THEN
342: l_dyn_std_to_add :=
343: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
344: grp_rec.student_group_id,
345: l_status
346: )
347: || l_dyn_std_to_add;

Line 414: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

410:
411:
412: IF l_std_is_filename_null = 'N' THEN
413: l_dyn_std_to_upd :=
414: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
415: grp_rec.student_group_id,
416: l_status
417: )
418: || l_dyn_std_to_upd;

Line 492: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

488: -- Loop through all the Advisors who are suggested to be added
489: --
490: IF l_adv_is_filename_null = 'N' THEN
491: l_dyn_adv_to_add :=
492: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
493: grp_rec.advisor_group_id,
494: l_status
495: )
496: || l_dyn_adv_to_add;

Line 558: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

554: IF lnAddedAdvisors = 0 and lvAutoAdvAddInd = 'Y' THEN
555:
556: IF l_adv_is_filename_null = 'N' THEN
557: l_dyn_adv_to_upd :=
558: igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
559: grp_rec.advisor_group_id,
560: l_status
561: )
562: || l_dyn_adv_to_upd;

Line 637: || igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

633: --
634: IF l_std_is_filename_null = 'N' THEN
635: l_dyn_std_to_del :=
636: l_dyn_std_to_del
637: || igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
638: grp_rec.student_group_id,
639: l_status
640: );
641: IF l_status <> fnd_api.g_ret_sts_success THEN

Line 680: || igs_pe_dynamic_persid_group.igs_get_dynamic_sql (

676: --
677: IF l_adv_is_filename_null = 'N' THEN
678: l_dyn_adv_to_del :=
679: l_dyn_adv_to_del
680: || igs_pe_dynamic_persid_group.igs_get_dynamic_sql (
681: grp_rec.advisor_group_id,
682: l_status
683: );
684: IF l_status <> fnd_api.g_ret_sts_success THEN