1 PACKAGE hr_perinfo_util_web AUTHID CURRENT_USER AS
2 /* $Header: hrpiutlw.pkh 120.3 2005/12/13 13:50:17 svittal noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- Screen/Canvas Names for TIPS
6 -- ----------------------------------------------------------------------------
7 g_bdt_form VARCHAR2(1000) := 'PERINFO_BASIC_DETAILS_FORM';
8 g_bdt_review VARCHAR2(1000) := 'PERINFO_BASIC_DETAILS_REVIEW';
9 g_bdt_toc VARCHAR2(1000) := 'PERINFO_BASIC_DETAILS_TOC';
10
11 g_address_form VARCHAR2(1000) := 'PERINFO_ADDRESS_FORM';
12 g_address_toc VARCHAR2(1000) := 'PERINFO_ADDRESS_TOC';
13 g_address_review VARCHAR2(1000) := 'PERINFO_ADDRESS_REVIEW';
14 g_address_deletion_review VARCHAR2(1000) := 'PERINFO_ADDRESS_DELETION_REVW';
15
16 g_contacts_form VARCHAR2(1000) := 'PERINFO_CONTACTS_FORM';
17 g_add_contacts_form VARCHAR2(1000) := 'PERINFO_ADD_CONTACTS_FORM';
18 g_contacts_toc VARCHAR2(1000) := 'PERINFO_CONTACTS_TOC';
19 g_contacts_review VARCHAR2(1000) := 'PERINFO_CONTACTS_REVIEW';
20
21 g_phones_form VARCHAR2(1000) := 'PERINFO_PHONES_FORM';
22 g_phones_review VARCHAR2(1000) := 'PERINFO_PHONES_REVIEW';
23 -- ----------------------------------------------------------------------------
24 -- End of Screen Names for TIPS
25 -- ----------------------------------------------------------------------------
26
27 -- ----------------------------------------------------------------------------
28 -- Following global variables will hold the Function Attribute
29 -- Internal Name. ( For Workflow )
30 -- ----------------------------------------------------------------------------
31 g_basic_details VARCHAR2(100) := 'BASIC_DETAILS';
32 g_contacts VARCHAR2(100) := 'CONTACTS';
33 g_phone_numbers VARCHAR2(100) := 'PHONE_NUMBERS';
34 g_main_address VARCHAR2(100) := 'MAIN_ADDRESS';
35 g_secondary_address VARCHAR2(100) := 'SECONDARY_ADDRESS';
36 g_national_identifier VARCHAR2(100) := 'NATIONAL_IDENTIFIER';
37 g_date_of_birth VARCHAR2(100) := 'DATE_OF_BIRTH';
38 g_marital_status VARCHAR2(100) := 'MARITAL_STATUS';
39 -- Bug 1835437 fix starts
40 g_perinfo_check_pending constant varchar2(200) := 'HR_PERINFO_CHECK_PENDING';
41 -- ----------------------------------------------------------------------------
42 -- For Tip and Error - Test Mode
43 -- ----------------------------------------------------------------------------
44 g_tiperror_mode BOOLEAN := FALSE;
45
46 -- ----------------------------------------------------------------------------
47 -- User Defined Exception
48 -- ----------------------------------------------------------------------------
49 g_no_changes EXCEPTION;
50 g_past_effective_date EXCEPTION;
51 g_past_current_start_date EXCEPTION;
52 g_invalid_address_style EXCEPTION;
53 -- ----------------------------------------------------------------------------
54 -- Following Global variables are used for Transaction API
55 -- ----------------------------------------------------------------------------
56 TYPE transaction_row IS RECORD
57 (param_name VARCHAR2(200)
58 ,param_value LONG
59 ,param_data_type VARCHAR2(200));
60
61
62 TYPE transaction_table IS TABLE OF transaction_row INDEX BY BINARY_INTEGER;
63
64 TYPE g_number_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
65
66 TYPE validate_field_rec IS RECORD
67 (name VARCHAR2(200)
68 ,prompt VARCHAR2(200)
69 );
70
71 TYPE validate_field_list IS TABLE OF validate_field_rec INDEX BY BINARY_INTEGER;
72 g_number_tab_default g_number_tab_type;
73
74
75 FUNCTION isR11i(p_application_id in number default 800)
76 RETURN BOOLEAN;
77
78
79 /*------------------------------------------------------------------------------
80 |
81 | Name : isDateLessThanCreationDate
82 |
83 | Purpose :
84 |
85 | This function will check if the passed in date is less than the date
86 | on which the person was created.
87 |
88 | In Parameters :
89 |
90 | p_date : The date to be checked.
91 | p_person_id : The ID of person for whom this check is done.
92 |
93 | Returns :
94 |
95 | Boolean :
96 |
97 | TRUE : If the date is less than the creation date.
98 | FALSE : If the date is equal to or greater than the creation
99 | date.
100 +-----------------------------------------------------------------------------*/
101
102 FUNCTION isDateLessThanCreationDate
103 (p_date IN DATE
104 ,p_person_id IN NUMBER) RETURN BOOLEAN;
105 /*------------------------------------------------------------------------------
106 |
107 | Name : isLessThanCurrentStartDate
108 |
109 | Purpose :
110 |
111 | This function will check if the passed in date is less than the
112 | Effective Start Date of the person reocrd which is current for a
113 | given Object Version Number and Person ID.
114 |
115 | In Parameters :
116 |
117 | p_date : The date to be checked.
118 | p_person_id : The ID of person for whom this check is done.
119 | p_ovn : The Object Version of the Person row in question.
120 |
121 | Returns :
122 |
123 | Boolean :
124 |
125 | TRUE : If the date is less than the Effective Start Date.
126 | FALSE : If the date is equal to or greater than the Effective
127 | Start date.
128 +-----------------------------------------------------------------------------*/
129
130 FUNCTION isLessThanCurrentStartDate
131 (p_effective_date IN DATE
132 ,p_person_id IN NUMBER
133 ,p_ovn IN NUMBER) RETURN BOOLEAN ;
134
135 END hr_perinfo_util_web;