eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APL_BUS dependencies on PER_APPLICATIONS

Line 38: (p_termination_reason in per_applications.termination_reason%TYPE

34: --
35: -- {End Of Comments}
36: -- ----------------------------------------------------------------------------
37: Procedure chk_termination_reason
38: (p_termination_reason in per_applications.termination_reason%TYPE
39: ,p_application_id in per_applications.application_id%TYPE
40: ,p_effective_date in date
41: ,p_object_version_number in per_applications.object_version_number%TYPE);
42: --

Line 39: ,p_application_id in per_applications.application_id%TYPE

35: -- {End Of Comments}
36: -- ----------------------------------------------------------------------------
37: Procedure chk_termination_reason
38: (p_termination_reason in per_applications.termination_reason%TYPE
39: ,p_application_id in per_applications.application_id%TYPE
40: ,p_effective_date in date
41: ,p_object_version_number in per_applications.object_version_number%TYPE);
42: --
43: -- ----------------------------------------------------------------------------

Line 41: ,p_object_version_number in per_applications.object_version_number%TYPE);

37: Procedure chk_termination_reason
38: (p_termination_reason in per_applications.termination_reason%TYPE
39: ,p_application_id in per_applications.application_id%TYPE
40: ,p_effective_date in date
41: ,p_object_version_number in per_applications.object_version_number%TYPE);
42: --
43: -- ----------------------------------------------------------------------------
44: -- |---------------------< chk_date_received_person_id >----------------------|
45: -- ----------------------------------------------------------------------------

Line 76: -- - date_received,person_id combination not exists in per_applications

72: -- - system_person_type must be 'APL','EMP_APL','APL_EX_APL','EX_EMP_APL'
73: -- - date_received is mandatory
74: -- - date_received <= date_end
75: -- - If set date_received <= projected_hire_date
76: -- - date_received,person_id combination not exists in per_applications
77: -- - person_id,date_received foreign key check into per_people_f table
78: --
79: -- Developer Implementation Notes:
80: -- Update validation is covered by check_non_updateable_args.

Line 88: (p_person_id in per_applications.person_id%TYPE

84: --
85: -- {End Of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure chk_date_received_person_id
88: (p_person_id in per_applications.person_id%TYPE
89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

Line 89: ,p_business_group_id in per_applications.business_group_id%TYPE

85: -- {End Of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure chk_date_received_person_id
88: (p_person_id in per_applications.person_id%TYPE
89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE

Line 90: ,p_date_received in per_applications.date_received%TYPE

86: -- ----------------------------------------------------------------------------
87: Procedure chk_date_received_person_id
88: (p_person_id in per_applications.person_id%TYPE
89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE
94: ,p_object_version_number in per_applications.object_version_number%TYPE

Line 91: ,p_date_end in per_applications.date_end%TYPE

87: Procedure chk_date_received_person_id
88: (p_person_id in per_applications.person_id%TYPE
89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE
94: ,p_object_version_number in per_applications.object_version_number%TYPE
95: );

Line 92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

88: (p_person_id in per_applications.person_id%TYPE
89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE
94: ,p_object_version_number in per_applications.object_version_number%TYPE
95: );
96: --

Line 93: ,p_application_id in per_applications.application_id%TYPE

89: ,p_business_group_id in per_applications.business_group_id%TYPE
90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE
94: ,p_object_version_number in per_applications.object_version_number%TYPE
95: );
96: --
97: -- ----------------------------------------------------------------------------

Line 94: ,p_object_version_number in per_applications.object_version_number%TYPE

90: ,p_date_received in per_applications.date_received%TYPE
91: ,p_date_end in per_applications.date_end%TYPE
92: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
93: ,p_application_id in per_applications.application_id%TYPE
94: ,p_object_version_number in per_applications.object_version_number%TYPE
95: );
96: --
97: -- ----------------------------------------------------------------------------
98: -- |----------------< chk_projected_hire_date >-----------------|

Line 130: (p_date_received in per_applications.date_received%TYPE

126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure chk_projected_hire_date
130: (p_date_received in per_applications.date_received%TYPE
131: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
132: ,p_application_id in per_applications.application_id%TYPE
133: ,p_object_version_number in per_applications.object_version_number%TYPE
134: );

Line 131: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure chk_projected_hire_date
130: (p_date_received in per_applications.date_received%TYPE
131: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
132: ,p_application_id in per_applications.application_id%TYPE
133: ,p_object_version_number in per_applications.object_version_number%TYPE
134: );
135: --

Line 132: ,p_application_id in per_applications.application_id%TYPE

128: -- ----------------------------------------------------------------------------
129: Procedure chk_projected_hire_date
130: (p_date_received in per_applications.date_received%TYPE
131: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
132: ,p_application_id in per_applications.application_id%TYPE
133: ,p_object_version_number in per_applications.object_version_number%TYPE
134: );
135: --
136: -- ----------------------------------------------------------------------------

Line 133: ,p_object_version_number in per_applications.object_version_number%TYPE

129: Procedure chk_projected_hire_date
130: (p_date_received in per_applications.date_received%TYPE
131: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
132: ,p_application_id in per_applications.application_id%TYPE
133: ,p_object_version_number in per_applications.object_version_number%TYPE
134: );
135: --
136: -- ----------------------------------------------------------------------------
137: -- |---------------------------< chk_date_end >-------------------------------|

Line 172: (p_date_end in per_applications.date_end%TYPE

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure chk_date_end
172: (p_date_end in per_applications.date_end%TYPE
173: ,p_date_received in per_applications.date_received%TYPE
174: ,p_application_id in per_applications.application_id%TYPE
175: ,p_object_version_number in per_applications.object_version_number%TYPE
176: );

Line 173: ,p_date_received in per_applications.date_received%TYPE

169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure chk_date_end
172: (p_date_end in per_applications.date_end%TYPE
173: ,p_date_received in per_applications.date_received%TYPE
174: ,p_application_id in per_applications.application_id%TYPE
175: ,p_object_version_number in per_applications.object_version_number%TYPE
176: );
177: --

Line 174: ,p_application_id in per_applications.application_id%TYPE

170: -- ----------------------------------------------------------------------------
171: Procedure chk_date_end
172: (p_date_end in per_applications.date_end%TYPE
173: ,p_date_received in per_applications.date_received%TYPE
174: ,p_application_id in per_applications.application_id%TYPE
175: ,p_object_version_number in per_applications.object_version_number%TYPE
176: );
177: --
178: -- ----------------------------------------------------------------------------

Line 175: ,p_object_version_number in per_applications.object_version_number%TYPE

171: Procedure chk_date_end
172: (p_date_end in per_applications.date_end%TYPE
173: ,p_date_received in per_applications.date_received%TYPE
174: ,p_application_id in per_applications.application_id%TYPE
175: ,p_object_version_number in per_applications.object_version_number%TYPE
176: );
177: --
178: -- ----------------------------------------------------------------------------
179: -- |---------------------------< insert_validate >----------------------------|