100: end if;
101:
102: -- PMD WHO Columns for Granular Locking
103: if l_Dim_Grp_Rec.Bsc_Created_By is null then
104: l_Dim_Grp_Rec.Bsc_Created_By := FND_GLOBAL.USER_ID;
105: end if;
106: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
107: if l_Dim_Grp_Rec.Bsc_Creation_Date is null then
108: l_Dim_Grp_Rec.Bsc_Creation_Date := l_Dim_Grp_Rec.Bsc_Last_Update_Date;
107: if l_Dim_Grp_Rec.Bsc_Creation_Date is null then
108: l_Dim_Grp_Rec.Bsc_Creation_Date := l_Dim_Grp_Rec.Bsc_Last_Update_Date;
109: end if;
110: if l_Dim_Grp_Rec.Bsc_Last_Updated_By is null then
111: l_Dim_Grp_Rec.Bsc_Last_Updated_By := FND_GLOBAL.USER_ID;
112: end if;
113: if l_Dim_Grp_Rec.Bsc_Last_Update_Login is null then
114: l_Dim_Grp_Rec.Bsc_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
115: end if;
110: if l_Dim_Grp_Rec.Bsc_Last_Updated_By is null then
111: l_Dim_Grp_Rec.Bsc_Last_Updated_By := FND_GLOBAL.USER_ID;
112: end if;
113: if l_Dim_Grp_Rec.Bsc_Last_Update_Login is null then
114: l_Dim_Grp_Rec.Bsc_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
115: end if;
116:
117:
118: -- Check that a group name has been entered.