APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 964: UPDATE PA_PROJECT_CUSTOMERS

960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962:
963: -- Add the new project party ID to the customers row
964: UPDATE PA_PROJECT_CUSTOMERS
965: SET project_party_id = l_project_party_id
966: WHERE project_id = p_project_id
967: AND customer_id = p_customer_id;
968: end if;

Line 4655: UPDATE pa_project_customers

4651: l_PROJECT_BIL_RATE_DATE_CODE := 'PA_INVOICE_DATE';
4652: l_FUNDING_RATE_DATE_CODE := 'PA_INVOICE_DATE';
4653: l_BTC_COST_BASE_REV_CODE := 'EXP_TRANS_CURR';
4654:
4655: UPDATE pa_project_customers
4656: SET inv_rate_type = x_default_rate_type
4657: WHERE project_id = p_project_id;
4658: ELSE
4659: l_PROJFUNC_BIL_RATE_TYPE := l_project_old_rec.PROJFUNC_BIL_RATE_TYPE;

Line 4808: UPDATE pa_project_customers

4804: BEGIN
4805:
4806: IF l_project_type_rec.date_eff_funds_consumption ='Y' THEN
4807:
4808: UPDATE pa_project_customers
4809: SET
4810: CUSTOMER_BILL_SPLIT = NULL
4811: WHERE
4812: PROJECT_ID = p_project_id;

Line 4832: UPDATE pa_project_customers SET customer_bill_split = 100

4828: , x_msg_data => l_msg_data );
4829:
4830: IF hghst_ctr_cust_id IS NOT NULL AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4831:
4832: UPDATE pa_project_customers SET customer_bill_split = 100
4833: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
4834:
4835: UPDATE pa_project_customers SET customer_bill_split = 0
4836: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;

Line 4835: UPDATE pa_project_customers SET customer_bill_split = 0

4831:
4832: UPDATE pa_project_customers SET customer_bill_split = 100
4833: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
4834:
4835: UPDATE pa_project_customers SET customer_bill_split = 0
4836: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;
4837: END IF;
4838: END IF;
4839: