APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 1916: UPDATE pa_project_customers

1912: l_PROJECT_BIL_RATE_DATE_CODE := 'PA_INVOICE_DATE';
1913: l_FUNDING_RATE_DATE_CODE := 'PA_INVOICE_DATE';
1914: l_BTC_COST_BASE_REV_CODE := 'EXP_TRANS_CURR';
1915:
1916: UPDATE pa_project_customers
1917: SET inv_rate_type = x_default_rate_type
1918: WHERE project_id = p_project_id;
1919: ELSE
1920: l_PROJFUNC_BIL_RATE_TYPE := l_PROJFUNC_BIL_RATE_TYPE;

Line 2029: UPDATE pa_project_customers

2025: BEGIN
2026:
2027: IF l_date_eff_funds_consumption ='Y' THEN
2028:
2029: UPDATE pa_project_customers
2030: SET
2031: CUSTOMER_BILL_SPLIT = NULL
2032: WHERE
2033: PROJECT_ID = p_project_id;

Line 2056: UPDATE pa_project_customers SET customer_bill_split = 100

2052: , x_msg_data => l_msg_data );
2053:
2054: IF hghst_ctr_cust_id IS NOT NULL AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2055:
2056: UPDATE pa_project_customers SET customer_bill_split = 100
2057: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
2058:
2059: UPDATE pa_project_customers SET customer_bill_split = 0
2060: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;

Line 2059: UPDATE pa_project_customers SET customer_bill_split = 0

2055:
2056: UPDATE pa_project_customers SET customer_bill_split = 100
2057: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
2058:
2059: UPDATE pa_project_customers SET customer_bill_split = 0
2060: WHERE customer_id <> hghst_ctr_cust_id AND project_id = p_project_id;
2061: END IF;
2062: END IF;
2063: