DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on FND_PROFILE

Line 199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and

195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);
196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
197: if (p_condition_id is not null
198: and
199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
201: OR
202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))

Line 200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))

196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
197: if (p_condition_id is not null
198: and
199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
201: OR
202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
204: OR

Line 202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and

198: and
199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
201: OR
202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
204: OR
205: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
206: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))

Line 203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))

199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
201: OR
202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
204: OR
205: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
206: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
207: )

Line 205: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and

201: OR
202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
204: OR
205: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
206: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
207: )
208: AND
209: p_condition_id <> l_status_id ) then

Line 206: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))

202: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
203: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
204: OR
205: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
206: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
207: )
208: AND
209: p_condition_id <> l_status_id ) then
210: