36:
37: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
38:
39: l_last_update_date DATE := SYSDATE;
40: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
41: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
42:
43: CURSOR c IS
44: SELECT rowid
37: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
38:
39: l_last_update_date DATE := SYSDATE;
40: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
41: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
42:
43: CURSOR c IS
44: SELECT rowid
45: FROM igw_prop_abstracts
182:
183: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
184:
185: l_last_update_date DATE := SYSDATE;
186: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
187: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
188:
189: BEGIN
190:
183: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
184:
185: l_last_update_date DATE := SYSDATE;
186: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
187: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
188:
189: BEGIN
190:
191: x_return_status := Fnd_Api.G_Ret_Sts_Success;