55: P_EffectiveTo,
56: P_BusinessGroupId,
57: P_Use_For_Alloc_Flag,
58: SysDate,
59: Fnd_Global.User_Id,
60: SysDate,
61: Fnd_Global.User_Id,
62: Fnd_Global.Login_Id,
63: 1);
57: P_Use_For_Alloc_Flag,
58: SysDate,
59: Fnd_Global.User_Id,
60: SysDate,
61: Fnd_Global.User_Id,
62: Fnd_Global.Login_Id,
63: 1);
64:
65: --MLS changes incorporated.
58: SysDate,
59: Fnd_Global.User_Id,
60: SysDate,
61: Fnd_Global.User_Id,
62: Fnd_Global.Login_Id,
63: 1);
64:
65: --MLS changes incorporated.
66: Insert Into Pa_Rbs_Headers_TL(
80: P_Description,
81: --UserEnv('LANG'),
82: L.Language_Code,
83: SysDate,
84: Fnd_Global.User_Id,
85: SysDate,
86: Fnd_Global.User_Id,
87: Fnd_Global.Login_Id,
88: --L.Language_Code
82: L.Language_Code,
83: SysDate,
84: Fnd_Global.User_Id,
85: SysDate,
86: Fnd_Global.User_Id,
87: Fnd_Global.Login_Id,
88: --L.Language_Code
89: UserEnv('LANG')
90: From
83: SysDate,
84: Fnd_Global.User_Id,
85: SysDate,
86: Fnd_Global.User_Id,
87: Fnd_Global.Login_Id,
88: --L.Language_Code
89: UserEnv('LANG')
90: From
91: Fnd_Languages L
140: Set Effective_From_Date = Nvl(P_EffectiveFrom,Effective_From_Date),
141: Effective_To_Date = P_EffectiveTo,
142: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
143: Last_Update_Date = SysDate,
144: Last_Updated_By = Fnd_Global.User_Id,
145: Last_Update_Login = Fnd_Global.Login_Id,
146: Record_Version_Number = Record_Version_Number + 1
147: Where
148: Rbs_Header_Id = P_RbsHeaderId;
141: Effective_To_Date = P_EffectiveTo,
142: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
143: Last_Update_Date = SysDate,
144: Last_Updated_By = Fnd_Global.User_Id,
145: Last_Update_Login = Fnd_Global.Login_Id,
146: Record_Version_Number = Record_Version_Number + 1
147: Where
148: Rbs_Header_Id = P_RbsHeaderId;
149:
152: Set
153: Name = P_Name,
154: Description = P_Description,
155: Last_update_date = SysDate,
156: Last_updated_by = Fnd_Global.User_Id,
157: Last_update_login = Fnd_Global.Login_Id,
158: Source_Lang = UserEnv('LANG')
159: Where
160: Rbs_Header_Id = P_RbsHeaderId
153: Name = P_Name,
154: Description = P_Description,
155: Last_update_date = SysDate,
156: Last_updated_by = Fnd_Global.User_Id,
157: Last_update_login = Fnd_Global.Login_Id,
158: Source_Lang = UserEnv('LANG')
159: Where
160: Rbs_Header_Id = P_RbsHeaderId
161: And UserEnv('LANG') in (Language, Source_Lang);