DBA Data[Home] [Help]

APPS.PER_CTK_BUS dependencies on PER_TASKS_IN_CHECKLIST

Line 100: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

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: -- ---------------------------------------------------------------------------

Line 132: (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE

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: );

Line 133: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE

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: --

Line 134: ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

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: -- ---------------------------------------------------------------------------

Line 135: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type

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 >-------------------------|

Line 169: (p_target_duration in per_tasks_in_checklist.target_duration%TYPE

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

Line 170: ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE

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: );

Line 171: ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE

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:

Line 172: ,p_object_version_number in per_tasks_in_checklist.object_version_number%type

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: /*

Line 185: -- in per_tasks_in_checklist table.

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: --

Line 209: (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE

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:

Line 210: ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE

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: -- ---------------------------------------------------------------------------

Line 246: (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE

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: --