DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PVT dependencies on FND_FLEX_EXT

Line 1980: AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;

1976: IS
1977: SELECT CONCATENATED_SEGMENTS
1978: FROM AHL_ROUTES_B_KFV
1979: WHERE ROUTE_ID = p_x_route_rec.route_id
1980: AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;
1981:
1982:
1983: --validate system KFV to ensure that no two routes share the same System KFV.
1984: CURSOR validate_system_kfv(c_route_no VARCHAR2, c_concat_segs VARCHAR2)

Line 1988: WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL

1984: CURSOR validate_system_kfv(c_route_no VARCHAR2, c_concat_segs VARCHAR2)
1985: IS
1986: SELECT 'X'
1987: FROM AHL_ROUTES_B_KFV
1988: WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL
1989: AND CONCATENATED_SEGMENTS = c_concat_segs
1990: AND ROUTE_NO <> c_route_no;
1991: --amsriniv. End
1992: