APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 1911: UPDATE pa_project_customers

1907: l_PROJECT_BIL_RATE_DATE_CODE := 'PA_INVOICE_DATE';
1908: l_FUNDING_RATE_DATE_CODE := 'PA_INVOICE_DATE';
1909: l_BTC_COST_BASE_REV_CODE := 'EXP_TRANS_CURR';
1910:
1911: UPDATE pa_project_customers
1912: SET inv_rate_type = x_default_rate_type
1913: WHERE project_id = p_project_id;
1914: ELSE
1915: l_PROJFUNC_BIL_RATE_TYPE := l_PROJFUNC_BIL_RATE_TYPE;

Line 2024: UPDATE pa_project_customers

2020: BEGIN
2021:
2022: IF l_date_eff_funds_consumption ='Y' THEN
2023:
2024: UPDATE pa_project_customers
2025: SET
2026: CUSTOMER_BILL_SPLIT = NULL
2027: WHERE
2028: PROJECT_ID = p_project_id;

Line 2051: UPDATE pa_project_customers SET customer_bill_split = 100

2047: , x_msg_data => l_msg_data );
2048:
2049: IF hghst_ctr_cust_id IS NOT NULL AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2050:
2051: UPDATE pa_project_customers SET customer_bill_split = 100
2052: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
2053:
2054: UPDATE pa_project_customers SET customer_bill_split = 0
2055: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;

Line 2054: UPDATE pa_project_customers SET customer_bill_split = 0

2050:
2051: UPDATE pa_project_customers SET customer_bill_split = 100
2052: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
2053:
2054: UPDATE pa_project_customers SET customer_bill_split = 0
2055: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;
2056: END IF;
2057: END IF;
2058: