DBA Data[Home] [Help]

APPS.HR_SUPERVISOR_SS dependencies on HR_UTIL_MISC_WEB

Line 628: p_emp_asg_id hr_util_misc_web.g_varchar2_tab_type,

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:

Line 629: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type,

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)

Line 631: p_emp_sup_asg_id hr_util_misc_web.g_varchar2_tab_type,

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

Line 778: p_emp_id hr_util_misc_web.g_varchar2_tab_type DEFAULT

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,

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

Line 780: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,

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:

Line 781: p_emp_effective_date hr_util_misc_web.g_varchar2_tab_type DEFAULT

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

Line 782: hr_util_misc_web.g_varchar2_tab_default,

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:

Line 873: p_emp_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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,

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

Line 875: p_emp_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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,

Line 876: p_emp_date IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type ,

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)

Line 877: p_emp_sup_asg_id IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

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:

Line 1172: ltt_emp_name hr_util_misc_web.g_varchar2_tab_type ;

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

Line 1173: ltt_emp_id hr_util_misc_web.g_varchar2_tab_type ;

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 ;

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

Line 1175: ltt_emp_date hr_util_misc_web.g_varchar2_tab_type ;

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;

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

Line 1179: ltt_reports_supervisor_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 ;
1182: lv_result_code VARCHAR2(250);
1183: lv_single_supervisor_name VARCHAR2(250);

Line 1180: ltt_reports_supervisor_name 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);
1184: ld_single_effective_date DATE ;

Line 1181: ltt_reports_effective_date hr_util_misc_web.g_varchar2_tab_type ;

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 ;