18:
19: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
20:
21: l_last_update_date DATE := SYSDATE;
22: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid
19: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
20:
21: l_last_update_date DATE := SYSDATE;
22: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid
27: FROM igw_prop_science_codes
109:
110: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
111:
112: l_last_update_date DATE := SYSDATE;
113: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
115:
116: BEGIN
117:
110: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
111:
112: l_last_update_date DATE := SYSDATE;
113: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
115:
116: BEGIN
117:
118: x_return_status := Fnd_Api.G_Ret_Sts_Success;