DBA Data[Home] [Help]

APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGF_AP_SS_PKG

Line 710: || ridas 07-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid

706: || Purpose :
707: || Known limitations, enhancements or remarks :
708: || Change History :
709: || Who When What
710: || ridas 07-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
711: || bvisvana 21-Jun-2005 Signature of assign_todo is changed to include status from 1 to 15
712: || (reverse chronological order - newest change first)
713: */
714:

Line 720: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);

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 ;
723: c_person_id_grp c_person_id_grpCurTyp ;
724: TYPE c_person_id_grp_recTyp IS RECORD ( person_id igs_pe_person_base_v.person_id%TYPE, person_number igs_pe_person_base_v.person_number%TYPE, full_name igs_pe_person_base_v.full_name%TYPE );

Line 1179: || ridas 07-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid

1175: || Purpose : Main process, does the main processing.
1176: || Known limitations, enhancements or remarks :
1177: || Change History :
1178: || Who When What
1179: || ridas 07-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
1180: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1181: || bvisvana 21-Jun-2005 Signature of main is changed to include status from 1 to 15
1182: || log_input_params and assign_todo signature changed
1183: || (reverse chronological order - newest change first)

Line 1194: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);

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);
1198: retcode := 0;