45: x_return_status OUT varchar2,
46: x_msg_count OUT number,
47: x_msg_data OUT varchar2) is
48: G_LAST_UPDATE_DATE DATE := Sysdate;
49: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
50: G_CREATION_DATE DATE := Sysdate;
51: G_CREATED_BY NUMBER := fnd_global.user_id;
52: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
53: l_api_name CONSTANT VARCHAR2(30) := 'Create_Conversion';
47: x_msg_data OUT varchar2) is
48: G_LAST_UPDATE_DATE DATE := Sysdate;
49: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
50: G_CREATION_DATE DATE := Sysdate;
51: G_CREATED_BY NUMBER := fnd_global.user_id;
52: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
53: l_api_name CONSTANT VARCHAR2(30) := 'Create_Conversion';
54: l_api_version CONSTANT NUMBER := 1.0;
55:
48: G_LAST_UPDATE_DATE DATE := Sysdate;
49: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
50: G_CREATION_DATE DATE := Sysdate;
51: G_CREATED_BY NUMBER := fnd_global.user_id;
52: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
53: l_api_name CONSTANT VARCHAR2(30) := 'Create_Conversion';
54: l_api_version CONSTANT NUMBER := 1.0;
55:
56: l_conv_id number;
219: x_return_status OUT varchar2,
220: x_msg_count OUT number,
221: x_msg_data OUT varchar2) is
222: G_LAST_UPDATE_DATE DATE := Sysdate;
223: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
224: G_CREATION_DATE DATE := Sysdate;
225: G_CREATED_BY NUMBER := fnd_global.user_id;
226: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
227: l_api_name CONSTANT VARCHAR2(30)
221: x_msg_data OUT varchar2) is
222: G_LAST_UPDATE_DATE DATE := Sysdate;
223: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
224: G_CREATION_DATE DATE := Sysdate;
225: G_CREATED_BY NUMBER := fnd_global.user_id;
226: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
227: l_api_name CONSTANT VARCHAR2(30)
228: := 'Update_Conversion';
229: l_api_version CONSTANT NUMBER := 1.0;
222: G_LAST_UPDATE_DATE DATE := Sysdate;
223: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
224: G_CREATION_DATE DATE := Sysdate;
225: G_CREATED_BY NUMBER := fnd_global.user_id;
226: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
227: l_api_name CONSTANT VARCHAR2(30)
228: := 'Update_Conversion';
229: l_api_version CONSTANT NUMBER := 1.0;
230: l_object_version number := 0;
396: x_return_status OUT varchar2,
397: x_msg_count OUT number,
398: x_msg_data OUT varchar2) is
399: G_LAST_UPDATE_DATE DATE := Sysdate;
400: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
401: G_CREATION_DATE DATE := Sysdate;
402: G_CREATED_BY NUMBER := fnd_global.user_id;
403: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
404: l_api_name CONSTANT VARCHAR2(30)
398: x_msg_data OUT varchar2) is
399: G_LAST_UPDATE_DATE DATE := Sysdate;
400: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
401: G_CREATION_DATE DATE := Sysdate;
402: G_CREATED_BY NUMBER := fnd_global.user_id;
403: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
404: l_api_name CONSTANT VARCHAR2(30)
405: := 'Delete_Conversion';
406: l_api_version CONSTANT NUMBER := 1.0;
399: G_LAST_UPDATE_DATE DATE := Sysdate;
400: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
401: G_CREATION_DATE DATE := Sysdate;
402: G_CREATED_BY NUMBER := fnd_global.user_id;
403: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
404: l_api_name CONSTANT VARCHAR2(30)
405: := 'Delete_Conversion';
406: l_api_version CONSTANT NUMBER := 1.0;
407: l_object_version number := 0;