DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on FND_PROFILE

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

182: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);
183: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
184: if (p_condition_id is not null
185: and
186: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
187: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
188: OR
189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))

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

183: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
184: if (p_condition_id is not null
185: and
186: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
187: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
188: OR
189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
191: OR

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

185: and
186: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
187: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
188: OR
189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
191: OR
192: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
193: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))

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

186: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
187: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))
188: OR
189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
191: OR
192: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
193: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
194: )

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

188: OR
189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
191: OR
192: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
193: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
194: )
195: AND
196: p_condition_id <> l_status_id ) then

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

189: ( FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE') is not null and
190: p_condition_id=FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'))
191: OR
192: (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB')is not null and
193: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB'))
194: )
195: AND
196: p_condition_id <> l_status_id ) then
197: