APPS.PA_PROJECT_PVT dependencies on PA_TASKS_S

Line 2436: SELECT pa_tasks_s.nextval

2432:
2433:
2434: --get the unique task id from the Oracle Sequence
2435:
2436: SELECT pa_tasks_s.nextval
2437: INTO l_task_id
2438: FROM DUAL;
2439: /* dbms_output.put_line('Task ID:'||l_task_id); */
2440:

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

5984: END IF; -- end changes for bug 13923366
5985:
5986: -- Building the dynamic SQL statement
5987:
5988: l_statement := ' UPDATE PA_TASKS SET ';
5989:
5990: -- TASK REFERENCE
5991:
5992: IF p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 8973: UPDATE PA_TASKS SET customer_id = p_customer_id

8969: NVL(l_task_rec.customer_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> p_customer_id
8970: THEN
8971: IF l_task_rec.parent_task_id IS NULL THEN
8972: IF l_children_exist ='Y' THEN
8973: UPDATE PA_TASKS SET customer_id = p_customer_id
8974: WHERE top_task_id=l_task_rec.task_id AND not(task_id =l_task_rec.task_id);
8975: END IF;
8976: l_statement := l_statement || ' CUSTOMER_ID = :cust_id ,';
8977: l_cust_id_fg := 'Y';