61:
62: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
63:
64: l_last_update_date DATE := SYSDATE;
65: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
66: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
67:
68: CURSOR c IS
69: SELECT rowid
62: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
63:
64: l_last_update_date DATE := SYSDATE;
65: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
66: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
67:
68: CURSOR c IS
69: SELECT rowid
70: FROM igw_awards
283:
284: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
285:
286: l_last_update_date DATE := SYSDATE;
287: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
288: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
289:
290: BEGIN
291:
284: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
285:
286: l_last_update_date DATE := SYSDATE;
287: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
288: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
289:
290: BEGIN
291:
292: x_return_status := Fnd_Api.G_Ret_Sts_Success;