765:
766: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
768: ELSE
769: l_user_id := fnd_global.user_id;
770: END IF;
771: l_login_id := fnd_global.LOGIN_ID;
772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
768: ELSE
769: l_user_id := fnd_global.user_id;
770: END IF;
771: l_login_id := fnd_global.LOGIN_ID;
772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
774: = FND_API.G_TRUE)
775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)
2078:
2079: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2080: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2081: ELSE
2082: l_user_id := fnd_global.user_id;
2083: END IF;
2084: l_login_id := fnd_global.LOGIN_ID;
2085: --
2086: /*
2080: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2081: ELSE
2082: l_user_id := fnd_global.user_id;
2083: END IF;
2084: l_login_id := fnd_global.LOGIN_ID;
2085: --
2086: /*
2087: ----------------
2088: --Adding this for the source column
2289: --
2290: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2291: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2292: ELSE
2293: l_user_id := fnd_global.user_id;
2294: END IF;
2295:
2296: l_login_id := fnd_global.LOGIN_ID;
2297: --
2292: ELSE
2293: l_user_id := fnd_global.user_id;
2294: END IF;
2295:
2296: l_login_id := fnd_global.LOGIN_ID;
2297: --
2298:
2299: Update BIS_TARGET_LEVELS_TL
2300: set