1269: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1270:
1271: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1272:
1273: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1274: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1275: l_sysdate DATE := SYSDATE;
1276: BEGIN
1277: --Setting initial values
1270:
1271: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1272:
1273: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1274: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1275: l_sysdate DATE := SYSDATE;
1276: BEGIN
1277: --Setting initial values
1278: X_MSG_COUNT := 0;