[Home] [Help]
PACKAGE: APPS.HR_DATE_CHK
Source
1 package hr_date_chk AUTHID CURRENT_USER as
2 /* $Header: pehchchk.pkh 115.2 2003/05/26 06:43:58 vramanai ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ****************************************************************** */
22 /*
23 Name : hr_date_chk (HEADER)
24
25 Description : This package declares procedures required to test
26 for the update of either period_of_service DATE_START
27 or application DATE_RECEIVED.
28 If the tests do not error then certain tables can be updated
29 the new values for the fields.
30 */
31 /*
32 Change List
33 -----------
34
35 Version Date Author ER/CR No. Description of Change
36 -------+---------+----------+---------+--------------------------
37 70.0 23-MAY-93 Tmathers Date Created
38 70.4 15-feb-95 TMathers 264072 Added extra checks to check_sp_place
39 ments.
40 70.5 29-APR-95 TMathers 275487 Added check for supervisor/Payroll
41 not existing
42 70.7 15-May-95 RFine Changed 'show errors' from package body
43 to package.
44 70.8 13-Jul-95 TMathers Added check_for_cost_alloc for
45 292807
46 70.9 27-Nov-96 VTreiger 401587 Added check_for_compl_actions.
47 399253 Added check_for_contig_pos.
48 115.2 26-may-03 vramanai 2947287 corrected GSCC errors and warnings
49 */
50 ------------------------- BEGIN: check_for_compl_actions ------------
51 procedure check_for_compl_actions(p_person_id NUMBER
52 ,p_s_start_date DATE
53 ,p_start_date DATE);
54 --
55 ------------------------- BEGIN: check_for_contig_pos --------------------
56 procedure check_for_contig_pos(p_person_id NUMBER
57 ,p_s_start_date DATE
58 ,p_start_date DATE);
59 --
60 ------------------------- BEGIN: check_supe_pay --------------------
61 procedure check_supe_pay(p_period_of_service_id NUMBER
62 ,p_start_date DATE);
63 --
64 ------------------------- BEGIN: check_for_entries --------------------
65 procedure check_for_entries(p_person_id NUMBER
66 ,p_period_of_service_id NUMBER
67 ,p_start_date DATE);
68 --
69 ------------------------- BEGIN: check_for_sp_placements --------------------
70 procedure check_for_sp_placements(p_person_id NUMBER
71 ,p_period_of_service_id NUMBER
72 ,p_start_date DATE);
73 --
74 ------------------------- BEGIN: check_for_cost_alloc --------------------
75 procedure check_for_cost_alloc(p_person_id NUMBER
76 ,p_period_of_service_id NUMBER
77 ,p_start_date DATE);
78 --
79 ------------------------- BEGIN: check_people_changes --------------------
80 procedure check_people_changes(p_person_id NUMBER
81 ,p_earlier_date DATE
82 ,p_later_date DATE
83 ,p_start_date DATE);
84 --
85 ------------------------- BEGIN: check_for_ass_st_chg --------------------
86 procedure check_for_ass_st_chg(p_person_id NUMBER
87 ,p_earlier_date DATE
88 ,p_later_date DATE
89 ,p_assignment_type VARCHAR2
90 ,p_start_date DATE);
91 --
92 ------------------------- BEGIN: check_for_ass_chg --------------------
93 procedure check_for_ass_chg(p_person_id NUMBER
94 ,p_earlier_date DATE
95 ,p_later_date DATE
96 ,p_assignment_type VARCHAR2
97 ,p_s_start_date DATE
98 ,p_start_date DATE);
99 --
100 ------------------------- BEGIN: check_for_prev_emp_ass --------------------
101 procedure check_for_prev_emp_ass(p_person_id NUMBER
102 ,p_assignment_type VARCHAR2
103 ,p_s_start_date DATE
104 ,p_start_date DATE);
105 --
106 ------------------------- BEGIN: check_hire_ref_int --------------------
107 procedure check_hire_ref_int(p_person_id NUMBER
108 ,p_business_group_id NUMBER
109 ,p_period_of_service_id NUMBER
110 ,p_s_start_date DATE
111 ,p_system_person_type VARCHAR2
112 ,p_start_date DATE);
113 --
114 ------------------------- BEGIN: update_hire_records --------------------
115 procedure update_hire_records(p_person_id NUMBER
116 ,p_app_number VARCHAR2
117 ,p_start_date DATE
118 ,p_s_start_date DATE
119 ,p_user_id NUMBER
120 ,p_login_id NUMBER);
121 --
122 ------------------------- BEGIN: check_apl_ref_int --------------------
123 procedure check_apl_ref_int(p_person_id NUMBER
124 ,p_business_group_id NUMBER
125 ,p_system_person_type VARCHAR2
126 ,p_s_start_date DATE
127 ,p_start_date DATE);
128 --
129 ------------------------- BEGIN: update_appl_records --------------------
130 procedure update_appl_records(p_person_id NUMBER
131 ,p_start_date DATE
132 ,p_s_start_date DATE
133 ,p_user_id NUMBER
134 ,p_login_id NUMBER);
135 --
136 end hr_date_chk;