DBA Data[Home] [Help]

APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGS_PE_PERSID_GROUP_V

Line 718: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

714:
715: -- Get all Active persons from the given person_id_group.
716: /* Variables for the dynamic person id group */
717: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
718: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
719:
720: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);
721:
722: TYPE c_person_id_grpCurTyp IS REF CURSOR ;

Line 1193: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

1189: ln_stdnt_count NUMBER := 0;
1190:
1191: /* Variables for the dynamic person id group */
1192: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
1193: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1194: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);
1195:
1196: BEGIN
1197: igf_aw_gen.set_org_id(NULL);