66: l_Dataset_Rec.Bsc_Meas_Type := 0;
67: end if;
68:
69: if l_Dataset_Rec.Bsc_Measure_Created_By is null then
70: l_Dataset_Rec.Bsc_Measure_Created_By := fnd_global.USER_ID;
71: end if;
72: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
73: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
74: end if;
69: if l_Dataset_Rec.Bsc_Measure_Created_By is null then
70: l_Dataset_Rec.Bsc_Measure_Created_By := fnd_global.USER_ID;
71: end if;
72: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
73: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
74: end if;
75: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
76: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
77: end if;
72: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
73: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
74: end if;
75: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
76: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
77: end if;
78:
79:
80: -- If Measure does not exist then create it.
214: l_Dataset_Rec.Bsc_Meas_Type := 0;
215: end if;
216:
217: if l_Dataset_Rec.Bsc_Measure_Created_By is null then
218: l_Dataset_Rec.Bsc_Measure_Created_By := fnd_global.USER_ID;
219: end if;
220: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
221: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
222: end if;
217: if l_Dataset_Rec.Bsc_Measure_Created_By is null then
218: l_Dataset_Rec.Bsc_Measure_Created_By := fnd_global.USER_ID;
219: end if;
220: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
221: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
222: end if;
223: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
224: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
225: end if;
220: if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
221: l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;
222: end if;
223: if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
224: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
225: end if;
226:
227:
228: -- If Measure does not exist then create it.
684: end if;
685:
686: -- 16-JUN-2003 ADRAO added for who columns
687: if l_Dataset_Rec.Bsc_Dataset_Created_By is null then
688: l_Dataset_Rec.Bsc_Dataset_Created_By := fnd_global.USER_ID;
689: end if;
690: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
691: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
692: end if;
687: if l_Dataset_Rec.Bsc_Dataset_Created_By is null then
688: l_Dataset_Rec.Bsc_Dataset_Created_By := fnd_global.USER_ID;
689: end if;
690: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
691: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
692: end if;
693: if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
694: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
695: end if;
690: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
691: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
692: end if;
693: if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
694: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
695: end if;
696:
697:
698: /* Remove following validation, in case there are measures with the same name.
803: end if;
804:
805: -- 16-JUN-2003 ADRAO added for who columns
806: if l_Dataset_Rec.Bsc_Dataset_Created_By is null then
807: l_Dataset_Rec.Bsc_Dataset_Created_By := fnd_global.USER_ID;
808: end if;
809: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
810: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
811: end if;
806: if l_Dataset_Rec.Bsc_Dataset_Created_By is null then
807: l_Dataset_Rec.Bsc_Dataset_Created_By := fnd_global.USER_ID;
808: end if;
809: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
810: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
811: end if;
812: if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
813: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
814: end if;
809: if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
810: l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;
811: end if;
812: if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
813: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
814: end if;
815:
816:
817: /* Remove following validation, in case there are measures with the same name.