624: p_passed_assignment_id NUMBER ,
625: p_direct_reports ltt_direct_reports ,
626: p_validate BOOLEAN ,
627: p_from_term BOOLEAN DEFAULT FALSE ,
628: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
629: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
630: -- Assignment Security
631: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
632:
625: p_direct_reports ltt_direct_reports ,
626: p_validate BOOLEAN ,
627: p_from_term BOOLEAN DEFAULT FALSE ,
628: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
629: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
630: -- Assignment Security
631: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
632:
633: p_term_flag VARCHAR2)
627: p_from_term BOOLEAN DEFAULT FALSE ,
628: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,
629: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,
630: -- Assignment Security
631: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,
632:
633: p_term_flag VARCHAR2)
634:
635: IS
774: ||===========================================================================
775: */
776:
777: PROCEDURE validate_emp_assignments (
778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
779: hr_util_misc_web.g_varchar2_tab_default ,
780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
782: hr_util_misc_web.g_varchar2_tab_default,
775: */
776:
777: PROCEDURE validate_emp_assignments (
778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
779: hr_util_misc_web.g_varchar2_tab_default ,
780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
782: hr_util_misc_web.g_varchar2_tab_default,
783: p_error_flag IN OUT NOCOPY BOOLEAN )
776:
777: PROCEDURE validate_emp_assignments (
778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
779: hr_util_misc_web.g_varchar2_tab_default ,
780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
782: hr_util_misc_web.g_varchar2_tab_default,
783: p_error_flag IN OUT NOCOPY BOOLEAN )
784:
777: PROCEDURE validate_emp_assignments (
778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
779: hr_util_misc_web.g_varchar2_tab_default ,
780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
782: hr_util_misc_web.g_varchar2_tab_default,
783: p_error_flag IN OUT NOCOPY BOOLEAN )
784:
785: IS
778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT
779: hr_util_misc_web.g_varchar2_tab_default ,
780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT
782: hr_util_misc_web.g_varchar2_tab_default,
783: p_error_flag IN OUT NOCOPY BOOLEAN )
784:
785: IS
786:
869: p_sup_name OUT NOCOPY VARCHAR2 ,
870: p_old_sup_name OUT NOCOPY VARCHAR2,
871: p_passed_effective_date OUT NOCOPY DATE ,
872: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
874: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
870: p_old_sup_name OUT NOCOPY VARCHAR2,
871: p_passed_effective_date OUT NOCOPY DATE ,
872: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
874: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
878: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
871: p_passed_effective_date OUT NOCOPY DATE ,
872: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
874: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
878: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
879: p_single_effective_date IN OUT NOCOPY DATE,
872: p_direct_reports IN OUT NOCOPY ltt_direct_reports,
873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
874: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
878: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
879: p_single_effective_date IN OUT NOCOPY DATE,
880: p_term_flag IN OUT NOCOPY VARCHAR2)
873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
874: p_emp_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,
877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
878: p_single_supervisor_name IN OUT NOCOPY VARCHAR2,
879: p_single_effective_date IN OUT NOCOPY DATE,
880: p_term_flag IN OUT NOCOPY VARCHAR2)
881:
1168: lv_sup_name VARCHAR2(250);
1169: lv_old_sup_name VARCHAR2(250);
1170: ld_passed_effective_date DATE ;
1171: ltt_reports ltt_direct_reports;
1172: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1174: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1169: lv_old_sup_name VARCHAR2(250);
1170: ld_passed_effective_date DATE ;
1171: ltt_reports ltt_direct_reports;
1172: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1174: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1170: ld_passed_effective_date DATE ;
1171: ltt_reports ltt_direct_reports;
1172: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1174: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1171: ltt_reports ltt_direct_reports;
1172: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;
1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1174: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1179: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;
1174: ltt_emp_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1179: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1180: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1181: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1179: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1180: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1181: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1182: lv_result_code VARCHAR2(250);
1183: lv_single_supervisor_name VARCHAR2(250);
1176: -- Assignment Security
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1179: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1180: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1181: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1182: lv_result_code VARCHAR2(250);
1183: lv_single_supervisor_name VARCHAR2(250);
1184: ld_single_effective_date DATE ;
1177: ltt_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type ;
1178:
1179: ltt_reports_supervisor_id hr_util_misc_web.g_varchar2_tab_type;
1180: ltt_reports_supervisor_name hr_util_misc_web.g_varchar2_tab_type ;
1181: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;
1182: lv_result_code VARCHAR2(250);
1183: lv_single_supervisor_name VARCHAR2(250);
1184: ld_single_effective_date DATE ;
1185: ln_selected_emp_id NUMBER ;