19: l_api_version CONSTANT NUMBER := 1.0;
20: l_valid_inputs VARCHAR2(10);
21: l_return_status VARCHAR2(10);
22: BEGIN
23: -- Standard Start of API savepoint
24: SAVEPOINT QPR_USER_PLAN_INITIALIZE;
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call (l_api_version ,
27: p_api_version ,
21: l_return_status VARCHAR2(10);
22: BEGIN
23: -- Standard Start of API savepoint
24: SAVEPOINT QPR_USER_PLAN_INITIALIZE;
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call (l_api_version ,
27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )
57: Reset_report_flags (p_user_id, p_plan_id, l_return_status);
58: end if;
59:
60:
61: -- Standard check of p_commit.
62: IF FND_API.To_Boolean( p_commit ) THEN
63: COMMIT WORK;
64: END IF;
65: -- Standard call to get message count and if count is 1, get message info.
61: -- Standard check of p_commit.
62: IF FND_API.To_Boolean( p_commit ) THEN
63: COMMIT WORK;
64: END IF;
65: -- Standard call to get message count and if count is 1, get message info.
66: FND_MSG_PUB.Count_And_Get
67: ( p_count => x_msg_count,
68: p_data => x_msg_data
69: );