APPS.PA_PROJECT_PVT dependencies on PA_TASKS_S

Line 2267: SELECT pa_tasks_s.nextval

2263:
2264:
2265: --get the unique task id from the Oracle Sequence
2266:
2267: SELECT pa_tasks_s.nextval
2268: INTO l_task_id
2269: FROM DUAL;
2270: /* dbms_output.put_line('Task ID:'||l_task_id); */
2271:

Line 5696: l_statement := ' UPDATE PA_TASKS SET ';

5692: CLOSE l_check_child_exists_csr;
5693:
5694: -- Building the dynamic SQL statement
5695:
5696: l_statement := ' UPDATE PA_TASKS SET ';
5697:
5698: -- TASK REFERENCE
5699:
5700: IF p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 8633: UPDATE PA_TASKS SET customer_id = p_customer_id

8629: NVL(l_task_rec.customer_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> p_customer_id
8630: THEN
8631: IF l_task_rec.parent_task_id IS NULL THEN
8632: IF l_children_exist ='Y' THEN
8633: UPDATE PA_TASKS SET customer_id = p_customer_id
8634: WHERE top_task_id=l_task_rec.task_id AND not(task_id =l_task_rec.task_id);
8635: END IF;
8636: l_statement := l_statement || ' CUSTOMER_ID = :cust_id ,';
8637: l_cust_id_fg := 'Y';