APPS.AHL_RM_ROUTE_PVT dependencies on FND_PROFILE

Line 1675: SELECT trim(fnd_profile.value('AHL_ENIGMA_3C_URL')) INTO l_enigma_avail FROM dual;

1671: --bachandr Enigma Phase I changes -- start
1672: -- Time Span is no longer a mandatory field during creat/update of Routes from Enigma
1673: -- Moving the validation to approval flow when it is a Enigma Route
1674: -- Check if the Time Span does not column contains a null value.
1675: SELECT trim(fnd_profile.value('AHL_ENIGMA_3C_URL')) INTO l_enigma_avail FROM dual;
1676: IF l_enigma_avail = 'N' THEN
1677: IF ( ( p_route_rec.dml_operation = 'C' AND
1678: p_route_rec.time_span IS NULL ) OR
1679: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN

Line 2224: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),

2220: X_ROWID => l_rowid ,
2221: X_ROUTE_ID => p_x_route_rec.route_id ,
2222: X_OBJECT_VERSION_NUMBER => 1 ,
2223: X_ROUTE_NO => p_x_route_rec.route_no ,
2224: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
2225: X_REVISION_NUMBER => 1 ,
2226: X_REVISION_STATUS_CODE => 'DRAFT' ,
2227: X_UNIT_RECEIPT_UPDATE_FLAG => p_x_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
2228: X_START_DATE_ACTIVE => p_x_route_rec.active_start_date ,

Line 3122: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),

3118: X_ROWID => l_rowid ,
3119: X_ROUTE_ID => l_route_id ,
3120: X_OBJECT_VERSION_NUMBER => 1 ,
3121: X_ROUTE_NO => l_old_route_rec.route_no ,
3122: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
3123: X_REVISION_NUMBER => l_revision_number ,
3124: X_REVISION_STATUS_CODE => 'DRAFT' ,
3125: X_UNIT_RECEIPT_UPDATE_FLAG => l_old_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
3126: X_START_DATE_ACTIVE => l_old_route_rec.active_start_date ,