35: x_msg_data OUT NOCOPY VARCHAR2
36: ) IS
37:
38: G_LAST_UPDATE_DATE DATE := Sysdate;
39: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
40: G_CREATION_DATE DATE := Sysdate;
41: G_CREATED_BY NUMBER := fnd_global.user_id;
42: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
43: G_ROWID VARCHAR2(30);
37:
38: G_LAST_UPDATE_DATE DATE := Sysdate;
39: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
40: G_CREATION_DATE DATE := Sysdate;
41: G_CREATED_BY NUMBER := fnd_global.user_id;
42: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
43: G_ROWID VARCHAR2(30);
44:
45: l_api_name CONSTANT VARCHAR2(30) := 'Create_Attain_Tier';
38: G_LAST_UPDATE_DATE DATE := Sysdate;
39: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
40: G_CREATION_DATE DATE := Sysdate;
41: G_CREATED_BY NUMBER := fnd_global.user_id;
42: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
43: G_ROWID VARCHAR2(30);
44:
45: l_api_name CONSTANT VARCHAR2(30) := 'Create_Attain_Tier';
46: l_api_version CONSTANT NUMBER := 1.0;
214: x_msg_data OUT NOCOPY VARCHAR2
215: ) IS
216:
217: G_LAST_UPDATE_DATE DATE := Sysdate;
218: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
219: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
220: G_ROWID VARCHAR2(30);
221:
222: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attain_Tier';
215: ) IS
216:
217: G_LAST_UPDATE_DATE DATE := Sysdate;
218: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
219: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
220: G_ROWID VARCHAR2(30);
221:
222: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attain_Tier';
223: l_api_version CONSTANT NUMBER := 1.0;