63: x_msg_data OUT NOCOPY VARCHAR2
64: ) IS
65:
66: G_LAST_UPDATE_DATE DATE := Sysdate;
67: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
68: G_CREATION_DATE DATE := Sysdate;
69: G_CREATED_BY NUMBER := fnd_global.user_id;
70: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
71:
65:
66: G_LAST_UPDATE_DATE DATE := Sysdate;
67: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
68: G_CREATION_DATE DATE := Sysdate;
69: G_CREATED_BY NUMBER := fnd_global.user_id;
70: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
71:
72: l_api_name CONSTANT VARCHAR2(30) := 'Create_Plan_Text';
73: l_api_version CONSTANT NUMBER := 1.0;
66: G_LAST_UPDATE_DATE DATE := Sysdate;
67: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
68: G_CREATION_DATE DATE := Sysdate;
69: G_CREATED_BY NUMBER := fnd_global.user_id;
70: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
71:
72: l_api_name CONSTANT VARCHAR2(30) := 'Create_Plan_Text';
73: l_api_version CONSTANT NUMBER := 1.0;
74:
231: x_msg_data OUT NOCOPY VARCHAR2
232: ) IS
233:
234: G_LAST_UPDATE_DATE DATE := Sysdate;
235: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
236: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
237:
238: l_api_name CONSTANT VARCHAR2(30) := 'Update_Plan_Text';
239: l_api_version CONSTANT NUMBER := 1.0;
232: ) IS
233:
234: G_LAST_UPDATE_DATE DATE := Sysdate;
235: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
236: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
237:
238: l_api_name CONSTANT VARCHAR2(30) := 'Update_Plan_Text';
239: l_api_version CONSTANT NUMBER := 1.0;
240: