[Home] [Help]
1601: END IF;
1602:
1603: END default_unchanged_attributes;
1604:
1605: -- Procedure to validate individual route attributes
1606: PROCEDURE validate_attributes
1607: (
1608: p_route_rec IN route_rec_type,
1609: x_return_status OUT NOCOPY VARCHAR2
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
2199:
2200: -- Get the Route ID from the Sequence
2201: SELECT AHL_ROUTES_B_S.NEXTVAL
2202: INTO p_x_route_rec.route_id
2203: FROM DUAL;
2204:
2205: --bachandr Enigma Phase I changes -- start
2206: -- Append the model code if any to the route No
2207: IF ( (p_x_route_rec.model_code IS NOT NULL ) AND (p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) ) THEN
3109:
3110: -- Get the Route ID from the Sequence
3111: SELECT AHL_ROUTES_B_S.NEXTVAL
3112: INTO l_route_id
3113: FROM DUAL;
3114:
3115: -- Insert the record
3116: AHL_ROUTES_PKG.insert_row
3117: (
3211: -- Create copies of the route associations
3212: -- 0.Copy Route Effectivities
3213: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3214: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3215: FROM dual;
3216: INSERT INTO ahl_route_effectivities
3217: (
3218: route_effectivity_id
3219: , route_id
3434:
3435: -- 2.Copy Resource Requirements and Alternate Resources
3436: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3437: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3438: FROM dual;
3439: INSERT INTO AHL_RT_OPER_RESOURCES
3440: (
3441: RT_OPER_RESOURCE_ID,
3442: OBJECT_VERSION_NUMBER,
3578: -- 3.Copy Reference Documents
3579: FOR I in get_doc_associations( p_route_id ) LOOP
3580: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
3581: INTO l_doc_title_assos_id
3582: FROM DUAL;
3583:
3584: AHL_DOC_TITLE_ASSOS_PKG.insert_row
3585: (
3586: X_ROWID => l_rowid,