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