96: -- {End of Comments}
97: --
98: -- ---------------------------------------------------------------------------
99: procedure chk_checklist_id
100: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
101: );
102: --
103:
104: -- ---------------------------------------------------------------------------
128: -- {End of Comments}
129: --
130: -- ---------------------------------------------------------------------------
131: procedure chk_task_name
132: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
133: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
134: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
135: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
136: );
129: --
130: -- ---------------------------------------------------------------------------
131: procedure chk_task_name
132: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
133: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
134: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
135: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
136: );
137: --
130: -- ---------------------------------------------------------------------------
131: procedure chk_task_name
132: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
133: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
134: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
135: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
136: );
137: --
138: -- ---------------------------------------------------------------------------
131: procedure chk_task_name
132: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
133: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
134: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
135: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
136: );
137: --
138: -- ---------------------------------------------------------------------------
139: -- |----------------------------< chk_duration_uom >-------------------------|
165: -- {End of Comments}
166: --
167: --
168: procedure chk_duration_uom
169: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
170: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
171: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
172: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
173: ,p_effective_date in date
166: --
167: --
168: procedure chk_duration_uom
169: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
170: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
171: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
172: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
173: ,p_effective_date in date
174: );
167: --
168: procedure chk_duration_uom
169: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
170: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
171: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
172: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
173: ,p_effective_date in date
174: );
175:
168: procedure chk_duration_uom
169: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
170: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
171: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
172: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
173: ,p_effective_date in date
174: );
175:
176: /*
181: --
182: -- Desciption :
183: --
184: -- Validates that CHECKLIST_ID and TASK_NAME combination not already exists
185: -- in per_tasks_in_checklist table.
186: --
187: --
188: -- Pre-conditions :
189: --
205: -- {End of Comments}
206: --
207: -- ---------------------------------------------------------------------------
208: procedure chk_ckl_tsk_unique
209: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
210: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
211: );
212: --
213:
206: --
207: -- ---------------------------------------------------------------------------
208: procedure chk_ckl_tsk_unique
209: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
210: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
211: );
212: --
213:
214: -- ---------------------------------------------------------------------------
242: -- {End of Comments}
243: --
244: -- ---------------------------------------------------------------------------
245: procedure chk_elig_prfl_id
246: (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE
247: ,p_business_group_id in per_checklists.business_group_id%TYPE
248: ,p_effective_date in date
249: );
250: --