61: l_agr_amount pa_agreements_all.Amount%TYPE;
62:
63: l_new_agr_amount NUMBER;
64:
65: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
66: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
67: l_sysdate DATE := TRUNC(SYSDATE);
68: l_total_amount NUMBER;
69: l_rowid ROWID;
62:
63: l_new_agr_amount NUMBER;
64:
65: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
66: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
67: l_sysdate DATE := TRUNC(SYSDATE);
68: l_total_amount NUMBER;
69: l_rowid ROWID;
70: l_project_funding_id NUMBER;
895: changes. */
896: BEGIN
897: x_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: l_user_id := FND_GLOBAL.USER_ID;
900: l_wbs_update_flag := 'Y';
901:
902: PA_COMP_PROFILE_PUB.GET_USER_INFO
903: (p_user_id => l_user_id,