[Home] [Help]
1890: --bachandr Enigma Phase I changes -- start
1891: -- Time Span is no longer a mandatory field during create/update of Routes from Enigma
1892: -- Moving the validation to approval flow when it is a Enigma Route
1893: -- Check if the Time Span does not column contains a null value.
1894: SELECT trim(fnd_profile.value('AHL_ENIGMA_3C_URL')) INTO l_enigma_avail FROM dual;
1895: IF l_enigma_avail = 'N' THEN
1896: IF ( ( p_route_rec.dml_operation = 'C' AND
1897: p_route_rec.time_span IS NULL ) OR
1898: p_route_rec.time_span = FND_API.G_MISS_NUM ) THEN
2520: X_ROWID => l_rowid ,
2521: X_ROUTE_ID => p_x_route_rec.route_id ,
2522: X_OBJECT_VERSION_NUMBER => 1 ,
2523: X_ROUTE_NO => p_x_route_rec.route_no ,
2524: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
2525: X_REVISION_NUMBER => 1 ,
2526: X_REVISION_STATUS_CODE => 'DRAFT' ,
2527: X_UNIT_RECEIPT_UPDATE_FLAG => p_x_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
2528: X_START_DATE_ACTIVE => p_x_route_rec.active_start_date ,
3526: X_ROWID => l_rowid ,
3527: X_ROUTE_ID => l_route_id ,
3528: X_OBJECT_VERSION_NUMBER => 1 ,
3529: X_ROUTE_NO => l_old_route_rec.route_no ,
3530: X_APPLICATION_USG_CODE => rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
3531: X_REVISION_NUMBER => l_revision_number ,
3532: X_REVISION_STATUS_CODE => 'DRAFT' ,
3533: X_UNIT_RECEIPT_UPDATE_FLAG => l_old_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
3534: X_START_DATE_ACTIVE => l_old_route_rec.active_start_date ,