58: X_Acct_Seq_Num,
59: X_Set_of_Books_Id,
60: X_Business_Group_Id,
61: sysdate,
62: fnd_global.user_id,
63: fnd_global.login_id,
64: fnd_global.user_id,
65: sysdate
66: );
59: X_Set_of_Books_Id,
60: X_Business_Group_Id,
61: sysdate,
62: fnd_global.user_id,
63: fnd_global.login_id,
64: fnd_global.user_id,
65: sysdate
66: );
67: OPEN C;
60: X_Business_Group_Id,
61: sysdate,
62: fnd_global.user_id,
63: fnd_global.login_id,
64: fnd_global.user_id,
65: sysdate
66: );
67: OPEN C;
68: FETCH C INTO X_Rowid;
152: End_Date_Active = X_End_Date_Active,
153: Set_of_books_id = X_Set_of_Books_Id,
154: Business_Group_Id = X_Business_group_id,
155: Last_Update_Date = sysdate,
156: Last_Updated_By = fnd_global.user_id,
157: Last_Update_Login = fnd_global.login_id
158: WHERE ROWID = X_Rowid;
159: if (SQL%NOTFOUND) then
160: Raise NO_DATA_FOUND;
153: Set_of_books_id = X_Set_of_Books_Id,
154: Business_Group_Id = X_Business_group_id,
155: Last_Update_Date = sysdate,
156: Last_Updated_By = fnd_global.user_id,
157: Last_Update_Login = fnd_global.login_id
158: WHERE ROWID = X_Rowid;
159: if (SQL%NOTFOUND) then
160: Raise NO_DATA_FOUND;
161: end if;
245: X_Lookup_Id,
246: X_Operand,
247: X_User_Value,
248: sysdate,
249: fnd_global.user_id,
250: fnd_global.login_id,
251: fnd_global.user_id,
252: sysdate
253: );
246: X_Operand,
247: X_User_Value,
248: sysdate,
249: fnd_global.user_id,
250: fnd_global.login_id,
251: fnd_global.user_id,
252: sysdate
253: );
254: OPEN C;
247: X_User_Value,
248: sysdate,
249: fnd_global.user_id,
250: fnd_global.login_id,
251: fnd_global.user_id,
252: sysdate
253: );
254: OPEN C;
255: FETCH C INTO X_Rowid;
312: Lookup_Id = X_Lookup_Id,
313: Operand = X_Operand,
314: User_Value = X_User_Value,
315: Last_Update_Date = sysdate,
316: Last_Updated_By = fnd_global.user_id,
317: Last_Update_Login = fnd_global.login_id
318: WHERE ROWID = X_Rowid;
319: if (SQL%NOTFOUND) then
320: Raise NO_DATA_FOUND;
313: Operand = X_Operand,
314: User_Value = X_User_Value,
315: Last_Update_Date = sysdate,
316: Last_Updated_By = fnd_global.user_id,
317: Last_Update_Login = fnd_global.login_id
318: WHERE ROWID = X_Rowid;
319: if (SQL%NOTFOUND) then
320: Raise NO_DATA_FOUND;
321: end if;