APPS.PA_TOP_TASK_CUST_INVOICE_PVT dependencies on PA_TASKS

Line 126: UPDATE pa_tasks SET customer_id = null

122: ) THEN
123: IF p_mode = 'DISABLE' THEN
124:
125:
126: UPDATE pa_tasks SET customer_id = null
127: WHERE project_id = p_project_id;
128:
129: UPDATE pa_project_customers SET default_top_task_cust_flag = 'N'
130: WHERE customer_id = p_def_top_task_cust AND project_id = p_project_id;

Line 153: UPDATE pa_tasks SET customer_id = p_def_top_task_cust

149:
150: END IF;
151:
152: ELSIF p_mode = 'ENABLE' THEN
153: UPDATE pa_tasks SET customer_id = p_def_top_task_cust
154: WHERE project_id = p_project_id;
155:
156: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'
157: WHERE customer_id = p_def_top_task_cust AND project_id = p_project_id;

Line 523: -- Purpose : To set the revenue accrual method in PA_TASKS table

519:
520:
521: -- Procedure : Set_Rev_Acc_At_Top_Task
522: -- Type : PRIVATE
523: -- Purpose : To set the revenue accrual method in PA_TASKS table
524: -- Note :
525: -- Assumptions :
526: -- Parameters Type Required Description and Purpose
527: -- --------------------------- ------ -------- --------------------------------------------------------

Line 610: UPDATE pa_tasks SET revenue_accrual_method = p_rev_acc

606: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) AND
607: (p_rev_acc IS NOT NULL AND p_rev_acc <> FND_API.G_MISS_CHAR)
608: ) THEN
609:
610: UPDATE pa_tasks SET revenue_accrual_method = p_rev_acc
611: WHERE project_id = p_project_id;
612:
613: ELSE
614: IF l_debug_mode = 'Y' THEN

Line 707: -- Purpose : To set the invoice method in PA_TASKS table

703:
704:
705: -- Procedure : Set_Inv_Mth_At_Top_Task
706: -- Type : PRIVATE
707: -- Purpose : To set the invoice method in PA_TASKS table
708: -- Note :
709: -- Assumptions :
710: -- Parameters Type Required Description and Purpose
711: -- --------------------------- ------ -------- --------------------------------------------------------

Line 794: UPDATE pa_tasks SET invoice_method = p_inv_mth

790: IF ( (p_project_id IS NOT NULL AND p_project_id <> FND_API.G_MISS_NUM) AND
791: (p_inv_mth IS NOT NULL AND p_inv_mth <> FND_API.G_MISS_CHAR)
792: ) THEN
793:
794: UPDATE pa_tasks SET invoice_method = p_inv_mth
795: WHERE project_id = p_project_id;
796: ELSE
797: IF l_debug_mode = 'Y' THEN
798: Pa_Debug.g_err_stage:= 'PA_TOP_TASK_CUST_INVOICE_PVT : Set_Inv_Mth_At_Top_Task :

Line 1108: FROM PA_TASKS

1104: , x_msg_data OUT NOCOPY VARCHAR2 -- 4537865
1105: ) IS
1106: CURSOR task_assoc_exists IS
1107: SELECT 'Y'
1108: FROM PA_TASKS
1109: WHERE project_id = p_project_id
1110: AND customer_id = p_customer_id;
1111:
1112: /* Changes for TCA

Line 1218: UPDATE pa_tasks SET customer_id = l_def_top_task_cust_id

1214: x_cust_id := l_def_top_task_cust_id;
1215: x_cust_name := l_def_top_task_cust_name;
1216: x_cust_num := l_def_top_task_cust_num;
1217:
1218: UPDATE pa_tasks SET customer_id = l_def_top_task_cust_id
1219: WHERE project_id = p_project_id
1220: AND customer_id = p_customer_id ;
1221: ELSIF 'Y' = l_task_assoc_exists AND l_def_top_task_cust_id = p_customer_id THEN
1222: pa_top_task_cust_invoice_pvt.Get_Highest_Contr_Cust( P_API_VERSION => 1.0

Line 1238: UPDATE pa_tasks SET customer_id = x_cust_id

1234: , x_msg_count => x_msg_count
1235: , x_msg_data => x_msg_data );
1236: IF 'S' = x_return_status THEN
1237:
1238: UPDATE pa_tasks SET customer_id = x_cust_id
1239: WHERE project_id = p_project_id
1240: AND customer_id = p_customer_id ;
1241:
1242: IF x_cust_id IS NOT NULL THEN