1282: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1283:
1284: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1285:
1286: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1287: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1288: l_sysdate DATE := SYSDATE;
1289: BEGIN
1290: --Setting initial values
1283:
1284: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.update_total_plan_amts';
1285:
1286: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1287: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1288: l_sysdate DATE := SYSDATE;
1289: BEGIN
1290: --Setting initial values
1291: X_MSG_COUNT := 0;