APPS.AHL_RM_ROUTE_UTIL dependencies on CST_ACTIVITIES

Line 2827: p_activity IN CST_ACTIVITIES.activity%TYPE,

2823: PROCEDURE validate_activity
2824: (
2825: x_return_status OUT NOCOPY VARCHAR2,
2826: x_msg_data OUT NOCOPY VARCHAR2,
2827: p_activity IN CST_ACTIVITIES.activity%TYPE,
2828: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2829: )
2830: IS
2831:

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

2824: (
2825: x_return_status OUT NOCOPY VARCHAR2,
2826: x_msg_data OUT NOCOPY VARCHAR2,
2827: p_activity IN CST_ACTIVITIES.activity%TYPE,
2828: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2829: )
2830: IS
2831:
2832: l_activity_id CST_ACTIVITIES.activity_id%TYPE;

Line 2832: l_activity_id CST_ACTIVITIES.activity_id%TYPE;

2828: p_x_activity_id IN OUT NOCOPY CST_ACTIVITIES.activity_id%TYPE
2829: )
2830: IS
2831:
2832: l_activity_id CST_ACTIVITIES.activity_id%TYPE;
2833:
2834: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2835: IS
2836: SELECT DISTINCT activity_id

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

2830: IS
2831:
2832: l_activity_id CST_ACTIVITIES.activity_id%TYPE;
2833:
2834: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2835: IS
2836: SELECT DISTINCT activity_id
2837: FROM CST_ACTIVITIES
2838: WHERE activity = c_activity;

Line 2837: FROM CST_ACTIVITIES

2833:
2834: CURSOR get_rec_from_value ( c_activity CST_ACTIVITIES.activity%TYPE )
2835: IS
2836: SELECT DISTINCT activity_id
2837: FROM CST_ACTIVITIES
2838: WHERE activity = c_activity;
2839:
2840: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2841: IS

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

2836: SELECT DISTINCT activity_id
2837: FROM CST_ACTIVITIES
2838: WHERE activity = c_activity;
2839:
2840: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2841: IS
2842: SELECT DISTINCT activity_id
2843: FROM CST_ACTIVITIES
2844: WHERE activity_id = c_activity_id;

Line 2843: FROM CST_ACTIVITIES

2839:
2840: CURSOR get_rec_from_id ( c_activity_id CST_ACTIVITIES.activity_id%TYPE )
2841: IS
2842: SELECT DISTINCT activity_id
2843: FROM CST_ACTIVITIES
2844: WHERE activity_id = c_activity_id;
2845:
2846: BEGIN
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;