DBA Data[Home] [Help]

APPS.HR_SUPERVISOR_SS dependencies on HR_UTIL_MISC_WEB

Line 583: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,

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:

Line 584: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,

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)

Line 586: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,

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

Line 733: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT

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,

Line 734: 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 )

Line 735: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,

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:

Line 736: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT

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

Line 737: hr_util_misc_web.g_varchar2_tab_default,

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:

Line 828: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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,

Line 829: p_emp_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,

Line 830: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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,

Line 831: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,

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)

Line 832: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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:

Line 1127: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;

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

Line 1128: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;

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 ;

Line 1129: ltt_emp_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:

Line 1130: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;

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;

Line 1132: ltt_emp_sup_asg_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 ;

Line 1134: ltt_reports_supervisor_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 ;
1137: lv_result_code VARCHAR2(250);
1138: lv_single_supervisor_name VARCHAR2(250);

Line 1135: ltt_reports_supervisor_name 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);
1139: ld_single_effective_date DATE ;

Line 1136: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;

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 ;