DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on HR_MISC_WEB

Line 1: PACKAGE BODY hr_misc_web AS

1: PACKAGE BODY hr_misc_web AS
2: /* $Header: hrmscmnw.pkb 120.1 2005/09/23 15:05:51 svittal noship $*/
3:
4:
5: --------------------------------------------------------------------------------

Line 8: gv_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'hr_misc_web';

4:
5: --------------------------------------------------------------------------------
6: -- Private Global Variables
7: --------------------------------------------------------------------------------
8: gv_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'hr_misc_web';
9:
10:
11:
12:

Line 128: hr_utility.trace(' Exception in hr_misc_web.get_language_code ' || SQLERRM);

124: RETURN (icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: hr_utility.trace(' Exception in hr_misc_web.get_language_code ' || SQLERRM);
129: END get_language_code;
130:
131:
132: /*

Line 156: hr_utility.trace(' Exception in hr_misc_web.get_image_directory ' || SQLERRM);

152: RETURN hr_util_misc_web.get_image_directory;
153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: hr_utility.trace(' Exception in hr_misc_web.get_image_directory ' || SQLERRM);
157: END get_image_directory;
158:
159:
160: /*

Line 252: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM);

248: WHEN OTHERS THEN
249: IF get_org_column_name%isopen then
250: close get_org_column_name;
251: end if;
252: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM);
253: END get_sshr_segment_value;
254:
255:
256: /*

Line 349: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM );

345:
346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: hr_utility.trace(' Exception in hr_misc_web.get_target ' || SQLERRM );
350: raise;
351: END get_user_defined_job_segments;
352:
353:

Line 396: sshr_segment := hr_misc_web.get_sshr_segment_value

392: sshr_segment VARCHAR2(500) DEFAULT NULL;
393: job_segments VARCHAR2(500) DEFAULT '';
394: BEGIN
395:
396: sshr_segment := hr_misc_web.get_sshr_segment_value
397: ( p_bg_id,
398: p_user_column_name => 'Display MEE Job Segments');
399:
400: IF ( (length(sshr_segment)>0) OR sshr_segment is not NULL) THEN

Line 401: job_segments := hr_misc_web.get_user_defined_job_segments

397: ( p_bg_id,
398: p_user_column_name => 'Display MEE Job Segments');
399:
400: IF ( (length(sshr_segment)>0) OR sshr_segment is not NULL) THEN
401: job_segments := hr_misc_web.get_user_defined_job_segments
402: ( p_job_segments => sshr_segment,
403: p_job_id => p_job_id,
404: p_job_name => p_job_name);
405:

Line 440: RETURN hr_misc_web.grt_person_details

436: */
437: FUNCTION get_person_details (
438: p_person_id IN per_people_f.person_id%TYPE
439: )
440: RETURN hr_misc_web.grt_person_details
441: IS
442:
443: -- Local Variables.
444: lrt_person_details hr_misc_web.grt_person_details;

Line 444: lrt_person_details hr_misc_web.grt_person_details;

440: RETURN hr_misc_web.grt_person_details
441: IS
442:
443: -- Local Variables.
444: lrt_person_details hr_misc_web.grt_person_details;
445: --
446: --1839081
447: --
448: CURSOR lc_person_details (

Line 473: hr_utility.trace(' hr_misc_web.get_person_details ' || SQLERRM );

469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: CLOSE lc_person_details;
473: hr_utility.trace(' hr_misc_web.get_person_details ' || SQLERRM );
474:
475: END get_person_details;
476:
477:

Line 496: RETURN hr_misc_web.grt_assignment_details

492: FUNCTION get_assignment_details (
493: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
494: p_effective_date IN DATE
495: )
496: RETURN hr_misc_web.grt_assignment_details
497: IS
498:
499: -- Local Variables.
500: lrt_assignment_details hr_misc_web.grt_assignment_details;

Line 500: lrt_assignment_details hr_misc_web.grt_assignment_details;

496: RETURN hr_misc_web.grt_assignment_details
497: IS
498:
499: -- Local Variables.
500: lrt_assignment_details hr_misc_web.grt_assignment_details;
501: lrt_empty hr_misc_web.grt_assignment_details;
502:
503: CURSOR lc_assignment_details (
504: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

Line 501: lrt_empty hr_misc_web.grt_assignment_details;

497: IS
498:
499: -- Local Variables.
500: lrt_assignment_details hr_misc_web.grt_assignment_details;
501: lrt_empty hr_misc_web.grt_assignment_details;
502:
503: CURSOR lc_assignment_details (
504: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
505: p_effective_date IN DATE

Line 673: hr_utility.trace( ' hr_misc_web.get_assignment_details ' || SQLERRM );

669: CLOSE lc_assignment_details;
670: CLOSE lc_supervisor_details;
671: CLOSE lc_job_details;
672: CLOSE lc_organization_details;
673: hr_utility.trace( ' hr_misc_web.get_assignment_details ' || SQLERRM );
674:
675: END get_assignment_details;
676:
677:

Line 695: RETURN hr_misc_web.grt_assignment_details

691: */
692: FUNCTION get_assignment_id (
693: p_person_id IN per_people_f.person_id%TYPE
694: )
695: RETURN hr_misc_web.grt_assignment_details
696: IS
697:
698: -- Local Variables.
699: lrt_assignment_details hr_misc_web.grt_assignment_details;

Line 699: lrt_assignment_details hr_misc_web.grt_assignment_details;

695: RETURN hr_misc_web.grt_assignment_details
696: IS
697:
698: -- Local Variables.
699: lrt_assignment_details hr_misc_web.grt_assignment_details;
700:
701: --
702: --1839081
703: --

Line 737: hr_utility.trace(' hr_misc_web.get_assignment_id ' || SQLERRM );

733:
734: EXCEPTION
735: WHEN OTHERS THEN
736: CLOSE lc_get_assignment;
737: hr_utility.trace(' hr_misc_web.get_assignment_id ' || SQLERRM );
738:
739: END get_assignment_id;
740:
741:

Line 798: p_enter_process_checks IN hr_misc_web.grt_enter_process_checks DEFAULT NULL

794: */
795: FUNCTION get_enter_process_checks (
796: p_assignment_id IN NUMBER DEFAULT NULL,
797: p_effective_date IN DATE DEFAULT NULL,
798: p_enter_process_checks IN hr_misc_web.grt_enter_process_checks DEFAULT NULL
799: )
800: RETURN hr_misc_web.grt_enter_process_checks
801: IS
802:

Line 800: RETURN hr_misc_web.grt_enter_process_checks

796: p_assignment_id IN NUMBER DEFAULT NULL,
797: p_effective_date IN DATE DEFAULT NULL,
798: p_enter_process_checks IN hr_misc_web.grt_enter_process_checks DEFAULT NULL
799: )
800: RETURN hr_misc_web.grt_enter_process_checks
801: IS
802:
803: -- Local variables.
804: -- Hire date

Line 858: lrt_enter_process_checks hr_misc_web.grt_enter_process_checks;

854:
855: ld_hire_date DATE;
856: ld_termination_date DATE;
857: ld_future_assg_date DATE;
858: lrt_enter_process_checks hr_misc_web.grt_enter_process_checks;
859:
860: BEGIN
861:
862: -- Assign all the checks to be done to the returning structure.

Line 979: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );

975: RETURN (l_person_rec.business_group_id);
976:
977: EXCEPTION
978: WHEN OTHERS THEN
979: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );
980:
981: END get_business_group_id;
982:
983:

Line 1002: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );

998: RETURN (ln_business_group_id);
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: hr_utility.trace(' Exception in hr_misc_web.get_business_group_id ' || SQLERRM );
1003:
1004: END get_business_group_id;
1005:
1006: /*

Line 1125: hr_utility.trace(' Exception in hr_misc_web.get_legislation_code ' || SQLERRM );

1121: RETURN l_legislation_code;
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: hr_utility.trace(' Exception in hr_misc_web.get_legislation_code ' || SQLERRM );
1126:
1127: END get_legislation_code;
1128:
1129:

Line 1131: END hr_misc_web;

1127: END get_legislation_code;
1128:
1129:
1130:
1131: END hr_misc_web;