[Home] [Help]
1820: END IF;
1821:
1822: END default_unchanged_attributes;
1823:
1824: -- Procedure to validate individual route attributes
1825: PROCEDURE validate_attributes
1826: (
1827: p_route_rec IN route_rec_type,
1828: x_return_status OUT NOCOPY VARCHAR2
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
2499:
2500: -- Get the Route ID from the Sequence
2501: SELECT AHL_ROUTES_B_S.NEXTVAL
2502: INTO p_x_route_rec.route_id
2503: FROM DUAL;
2504:
2505: --bachandr Enigma Phase I changes -- start
2506: -- Append the model code if any to the route No
2507: IF ( (p_x_route_rec.model_code IS NOT NULL ) AND (p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) ) THEN
3517:
3518: -- Get the Route ID from the Sequence
3519: SELECT AHL_ROUTES_B_S.NEXTVAL
3520: INTO l_route_id
3521: FROM DUAL;
3522:
3523: -- Insert the record
3524: AHL_ROUTES_PKG.insert_row
3525: (
3628: -- Create copies of the route associations
3629: -- 0.Copy Route Effectivities
3630: FOR l_get_route_efcts IN get_route_efcts(p_route_id) LOOP
3631: SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
3632: FROM dual;
3633: INSERT INTO ahl_route_effectivities
3634: (
3635: route_effectivity_id
3636: , route_id
3858:
3859: -- 2.Copy Resource Requirements and Alternate Resources
3860: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3861: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3862: FROM dual;
3863: INSERT INTO AHL_RT_OPER_RESOURCES
3864: (
3865: RT_OPER_RESOURCE_ID,
3866: OBJECT_VERSION_NUMBER,
4002: -- 3.Copy Reference Documents
4003: FOR I in get_doc_associations( p_route_id ) LOOP
4004: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
4005: INTO l_doc_title_assos_id
4006: FROM DUAL;
4007: -- pekambar changes for bug # 9342005 -- start
4008: -- Passing wrong values to attribute1 to attribute15 are corrected
4009: AHL_DOC_TITLE_ASSOS_PKG.insert_row
4010: (