113: end if;
114:
115: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
116: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
117: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
118: ( p_approver_source_id => p_approver_source_id
119: ,p_approver_source_type => p_approver_source_type
120: ,p_approver_name => p_approver_name
121: ,p_check_id_flag => 'Y'
135: End If;
136:
137: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
138: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
139: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
140: ( p_lifecycle_id => p_lifecycle_id
141: ,p_lifecycle_name => p_lifecycle_name
142: ,p_check_id_flag => 'Y'
143: ,x_lifecycle_id => l_lifecycle_id
150: end if;
151:
152: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
153: ((p_current_lifecycle_phase <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase is not NULL)) then
154: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
155: ( p_lifecycle_id => l_lifecycle_id
156: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id
157: ,p_current_lifecycle_phase => p_current_lifecycle_phase
158: ,p_check_id_flag => 'Y'
380: end if;
381:
382: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
383: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
384: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
385: ( p_approver_source_id => p_approver_source_id
386: ,p_approver_source_type => p_approver_source_type
387: ,p_approver_name => p_approver_name
388: ,p_check_id_flag => 'Y'
423:
424: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
425: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
426:
427: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
428: ( p_lifecycle_id => p_lifecycle_id
429: ,p_lifecycle_name => p_lifecycle_name
430: ,p_check_id_flag => 'Y'
431: ,x_lifecycle_id => l_lifecycle_id
439:
440: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
441: ((p_current_lifecycle_phase <> FND_API.G_MISS_CHAR) AND (p_current_lifecycle_phase is not NULL)) then
442:
443: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
444: ( p_lifecycle_id => l_lifecycle_id
445: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id
446: ,p_current_lifecycle_phase => p_current_lifecycle_phase
447: ,p_check_id_flag => 'Y'