DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on JTF_TASKS_B

Line 42: FROM jtf_Tasks_b

38: IS
39: -- Hint: Declare cursor and local variables
40: CURSOR C_Get_Task_Id(X_Task_Number VARCHAR2) IS
41: SELECT task_id
42: FROM jtf_Tasks_b
43: WHERE task_number = x_Task_Number;
44: l_any_errors BOOLEAN := FALSE;
45: l_task_id Number;
46: EXCP_USER_DEFINED EXCEPTION;

Line 153: FROM jtf_Tasks_b

149: AND l_pvt_RQH_rec.task_id <> FND_API.G_MISS_NUM) THEN
150: BEGIN
151: SELECT count(task_id)
152: INTO l_count
153: FROM jtf_Tasks_b
154: WHERE task_id = l_pvt_RQH_Rec.task_id;
155: IF (l_count <= 0) THEN
156: FND_MESSAGE.SET_NAME ('JTF', 'JTF_TASK_INVALID_TASK_ID');
157: FND_MESSAGE.SET_TOKEN ('P_TASK_ID', l_pvt_RQH_rec.task_id, FALSE);