24:
25: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
26:
27: l_last_update_date DATE := SYSDATE;
28: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
29: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
30:
31: l_person_sequence NUMBER;
32:
25: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
26:
27: l_last_update_date DATE := SYSDATE;
28: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
29: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
30:
31: l_person_sequence NUMBER;
32:
33: CURSOR c IS
136:
137: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
138:
139: l_last_update_date DATE := SYSDATE;
140: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
141: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
142:
143: BEGIN
144:
137: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
138:
139: l_last_update_date DATE := SYSDATE;
140: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
141: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
142:
143: BEGIN
144:
145: x_return_status := Fnd_Api.G_Ret_Sts_Success;