APPS.AHL_RM_ROUTE_UTIL dependencies on CST_ACTIVITIES

Line 2695: p_activity IN CST_ACTIVITIES.activity%TYPE,

2691: PROCEDURE validate_activity
2692: (
2693: x_return_status OUT NOCOPY VARCHAR2,
2694: x_msg_data OUT NOCOPY VARCHAR2,
2695: p_activity IN CST_ACTIVITIES.activity%TYPE,
2696: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2697: )
2698: IS
2699:

Line 2696: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE

2692: (
2693: x_return_status OUT NOCOPY VARCHAR2,
2694: x_msg_data OUT NOCOPY VARCHAR2,
2695: p_activity IN CST_ACTIVITIES.activity%TYPE,
2696: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2697: )
2698: IS
2699:
2700: l_activity_id CST_ACTIVITIES.activity_id%TYPE;

Line 2700: l_activity_id CST_ACTIVITIES.activity_id%TYPE;

2696: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2697: )
2698: IS
2699:
2700: l_activity_id CST_ACTIVITIES.activity_id%TYPE;
2701:
2702: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2703: IS
2704: SELECT DISTINCT activity_id

Line 2702: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )

2698: IS
2699:
2700: l_activity_id CST_ACTIVITIES.activity_id%TYPE;
2701:
2702: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2703: IS
2704: SELECT DISTINCT activity_id
2705: FROM CST_ACTIVITIES
2706: WHERE activity = c_activity;

Line 2705: FROM CST_ACTIVITIES

2701:
2702: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2703: IS
2704: SELECT DISTINCT activity_id
2705: FROM CST_ACTIVITIES
2706: WHERE activity = c_activity;
2707:
2708: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2709: IS

Line 2708: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )

2704: SELECT DISTINCT activity_id
2705: FROM CST_ACTIVITIES
2706: WHERE activity = c_activity;
2707:
2708: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2709: IS
2710: SELECT DISTINCT activity_id
2711: FROM CST_ACTIVITIES
2712: WHERE activity_id = c_activity_id;

Line 2711: FROM CST_ACTIVITIES

2707:
2708: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2709: IS
2710: SELECT DISTINCT activity_id
2711: FROM CST_ACTIVITIES
2712: WHERE activity_id = c_activity_id;
2713:
2714: BEGIN
2715: x_return_status := FND_API.G_RET_STS_SUCCESS;