579: p_passed_assignment_id NUMBER ,
580: p_direct_reports ltt_direct_reports ,
581: p_validate BOOLEAN ,
582: p_from_term BOOLEAN DEFAULT FALSE ,
583: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
584: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
585: -- Assignment Security
586: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
587:
580: p_direct_reports ltt_direct_reports ,
581: p_validate BOOLEAN ,
582: p_from_term BOOLEAN DEFAULT FALSE ,
583: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
584: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
585: -- Assignment Security
586: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
587:
588: p_term_flag VARCHAR2)
582: p_from_term BOOLEAN DEFAULT FALSE ,
583: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
584: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
585: -- Assignment Security
586: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
587:
588: p_term_flag VARCHAR2)
589:
590: IS
729: ||===========================================================================
730: */
731:
732: PROCEDURE validate_emp_assignments (
733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
734: hr_util_misc_web.g_varchar2_tab_default ,
735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
737: hr_util_misc_web.g_varchar2_tab_default,
730: */
731:
732: PROCEDURE validate_emp_assignments (
733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
734: hr_util_misc_web.g_varchar2_tab_default ,
735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
737: hr_util_misc_web.g_varchar2_tab_default,
738: p_error_flag IN OUT NOCOPY BOOLEAN )
731:
732: PROCEDURE validate_emp_assignments (
733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
734: hr_util_misc_web.g_varchar2_tab_default ,
735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
737: hr_util_misc_web.g_varchar2_tab_default,
738: p_error_flag IN OUT NOCOPY BOOLEAN )
739:
732: PROCEDURE validate_emp_assignments (
733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
734: hr_util_misc_web.g_varchar2_tab_default ,
735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
737: hr_util_misc_web.g_varchar2_tab_default,
738: p_error_flag IN OUT NOCOPY BOOLEAN )
739:
740: IS
733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
734: hr_util_misc_web.g_varchar2_tab_default ,
735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
737: hr_util_misc_web.g_varchar2_tab_default,
738: p_error_flag IN OUT NOCOPY BOOLEAN )
739:
740: IS
741:
824: p_sup_name OUT NOCOPY VARCHAR2 ,
825: p_old_sup_name OUT NOCOPY VARCHAR2,
826: p_passed_effective_date OUT NOCOPY DATE ,
827: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
829: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
825: p_old_sup_name OUT NOCOPY VARCHAR2,
826: p_passed_effective_date OUT NOCOPY DATE ,
827: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
829: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
833: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
826: p_passed_effective_date OUT NOCOPY DATE ,
827: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
829: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
833: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
834: p_single_effective_date IN OUT NOCOPY DATE,
827: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
829: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
833: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
834: p_single_effective_date IN OUT NOCOPY DATE,
835: p_term_flag IN OUT NOCOPY VARCHAR2)
828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
829: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
833: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
834: p_single_effective_date IN OUT NOCOPY DATE,
835: p_term_flag IN OUT NOCOPY VARCHAR2)
836:
1123: lv_sup_name VARCHAR2(250);
1124: lv_old_sup_name VARCHAR2(250);
1125: ld_passed_effective_date DATE ;
1126: ltt_reports ltt_direct_reports;
1127: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1129: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1124: lv_old_sup_name VARCHAR2(250);
1125: ld_passed_effective_date DATE ;
1126: ltt_reports ltt_direct_reports;
1127: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1129: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1125: ld_passed_effective_date DATE ;
1126: ltt_reports ltt_direct_reports;
1127: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1129: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1126: ltt_reports ltt_direct_reports;
1127: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1129: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1134: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1129: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1134: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1135: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1136: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1134: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1135: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1136: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1137: lv_result_code VARCHAR2(250);
1138: lv_single_supervisor_name VARCHAR2(250);
1131: -- Assignment Security
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1134: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1135: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1136: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1137: lv_result_code VARCHAR2(250);
1138: lv_single_supervisor_name VARCHAR2(250);
1139: ld_single_effective_date DATE ;
1132: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1133:
1134: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1135: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1136: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1137: lv_result_code VARCHAR2(250);
1138: lv_single_supervisor_name VARCHAR2(250);
1139: ld_single_effective_date DATE ;
1140: ln_selected_emp_id NUMBER ;