21:
22: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
23:
24: l_last_update_date DATE := SYSDATE;
25: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
26: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
27:
28: CURSOR c IS
29: SELECT rowid
22: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
23:
24: l_last_update_date DATE := SYSDATE;
25: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
26: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
27:
28: CURSOR c IS
29: SELECT rowid
30: FROM igw_prop_questions
121:
122: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
123:
124: l_last_update_date DATE := SYSDATE;
125: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
126: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
127:
128: BEGIN
129:
122: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
123:
124: l_last_update_date DATE := SYSDATE;
125: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
126: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
127:
128: BEGIN
129:
130: x_return_status := Fnd_Api.G_Ret_Sts_Success;