61: P_Use_For_Alloc_Flag,
62: P_Cbs_Enabled, --bug#15834912
63: P_Active_Flag, --bug#15834912
64: SysDate,
65: Fnd_Global.User_Id,
66: SysDate,
67: Fnd_Global.User_Id,
68: Fnd_Global.Login_Id,
69: 1);
63: P_Active_Flag, --bug#15834912
64: SysDate,
65: Fnd_Global.User_Id,
66: SysDate,
67: Fnd_Global.User_Id,
68: Fnd_Global.Login_Id,
69: 1);
70:
71: --MLS changes incorporated.
64: SysDate,
65: Fnd_Global.User_Id,
66: SysDate,
67: Fnd_Global.User_Id,
68: Fnd_Global.Login_Id,
69: 1);
70:
71: --MLS changes incorporated.
72: Insert Into Pa_Rbs_Headers_TL(
86: P_Description,
87: --UserEnv('LANG'),
88: L.Language_Code,
89: SysDate,
90: Fnd_Global.User_Id,
91: SysDate,
92: Fnd_Global.User_Id,
93: Fnd_Global.Login_Id,
94: --L.Language_Code
88: L.Language_Code,
89: SysDate,
90: Fnd_Global.User_Id,
91: SysDate,
92: Fnd_Global.User_Id,
93: Fnd_Global.Login_Id,
94: --L.Language_Code
95: UserEnv('LANG')
96: From
89: SysDate,
90: Fnd_Global.User_Id,
91: SysDate,
92: Fnd_Global.User_Id,
93: Fnd_Global.Login_Id,
94: --L.Language_Code
95: UserEnv('LANG')
96: From
97: Fnd_Languages L
147: Set Effective_From_Date = Nvl(P_EffectiveFrom,Effective_From_Date),
148: Effective_To_Date = P_EffectiveTo,
149: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
150: Last_Update_Date = SysDate,
151: Last_Updated_By = Fnd_Global.User_Id,
152: Last_Update_Login = Fnd_Global.Login_Id,
153: Record_Version_Number = Record_Version_Number + 1,
154: ACTIVE_FLAG = P_ACTIVE_FLAG --15834912
155: Where
148: Effective_To_Date = P_EffectiveTo,
149: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
150: Last_Update_Date = SysDate,
151: Last_Updated_By = Fnd_Global.User_Id,
152: Last_Update_Login = Fnd_Global.Login_Id,
153: Record_Version_Number = Record_Version_Number + 1,
154: ACTIVE_FLAG = P_ACTIVE_FLAG --15834912
155: Where
156: Rbs_Header_Id = P_RbsHeaderId;
160: Set
161: Name = P_Name,
162: Description = P_Description,
163: Last_update_date = SysDate,
164: Last_updated_by = Fnd_Global.User_Id,
165: Last_update_login = Fnd_Global.Login_Id,
166: Source_Lang = UserEnv('LANG')
167: Where
168: Rbs_Header_Id = P_RbsHeaderId
161: Name = P_Name,
162: Description = P_Description,
163: Last_update_date = SysDate,
164: Last_updated_by = Fnd_Global.User_Id,
165: Last_update_login = Fnd_Global.Login_Id,
166: Source_Lang = UserEnv('LANG')
167: Where
168: Rbs_Header_Id = P_RbsHeaderId
169: And UserEnv('LANG') in (Language, Source_Lang);