DBA Data[Home] [Help]

APPS.BIS_BUCKET_PVT dependencies on FND_GLOBAL

Line 355: last_updated_by = FND_GLOBAL.USER_ID,

351: range10_low = p_range10_low,
352: range10_high = p_range10_high,
353: CUSTOMIZED = p_customized,
354: last_update_date = SYSDATE,
355: last_updated_by = FND_GLOBAL.USER_ID,
356: last_update_login = FND_GLOBAL.LOGIN_ID
357: WHERE id = p_id;
358:
359: UPDATE bis_bucket_customizations_tl SET

Line 356: last_update_login = FND_GLOBAL.LOGIN_ID

352: range10_high = p_range10_high,
353: CUSTOMIZED = p_customized,
354: last_update_date = SYSDATE,
355: last_updated_by = FND_GLOBAL.USER_ID,
356: last_update_login = FND_GLOBAL.LOGIN_ID
357: WHERE id = p_id;
358:
359: UPDATE bis_bucket_customizations_tl SET
360: range1_name = p_range1_name,

Line 371: last_updated_by = FND_GLOBAL.USER_ID,

367: range8_name = p_range8_name,
368: range9_name = p_range9_name,
369: range10_name = p_range10_name,
370: last_update_date = SYSDATE,
371: last_updated_by = FND_GLOBAL.USER_ID,
372: last_update_login = FND_GLOBAL.LOGIN_ID,
373: source_lang = userenv('LANG')
374: where id = p_id
375: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 372: last_update_login = FND_GLOBAL.LOGIN_ID,

368: range9_name = p_range9_name,
369: range10_name = p_range10_name,
370: last_update_date = SYSDATE,
371: last_updated_by = FND_GLOBAL.USER_ID,
372: last_update_login = FND_GLOBAL.LOGIN_ID,
373: source_lang = userenv('LANG')
374: where id = p_id
375: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
376:

Line 673: last_updated_by = FND_GLOBAL.USER_ID,

669: range10_low = l_base_bucket_rec.range10_low,
670: range10_high = l_base_bucket_rec.range10_high,
671: CUSTOMIZED = 'F',
672: last_update_date = SYSDATE,
673: last_updated_by = FND_GLOBAL.USER_ID,
674: last_update_login = FND_GLOBAL.LOGIN_ID
675: WHERE bucket_id = p_bucket_id;
676: END IF;
677:

Line 674: last_update_login = FND_GLOBAL.LOGIN_ID

670: range10_high = l_base_bucket_rec.range10_high,
671: CUSTOMIZED = 'F',
672: last_update_date = SYSDATE,
673: last_updated_by = FND_GLOBAL.USER_ID,
674: last_update_login = FND_GLOBAL.LOGIN_ID
675: WHERE bucket_id = p_bucket_id;
676: END IF;
677:
678: CLOSE c_base_bucket;

Line 701: last_updated_by = FND_GLOBAL.USER_ID,

697: range8_name = l_base_bucket_tl_rec.range8_name,
698: range9_name = l_base_bucket_tl_rec.range9_name,
699: range10_name = l_base_bucket_tl_rec.range10_name,
700: last_update_date = SYSDATE,
701: last_updated_by = FND_GLOBAL.USER_ID,
702: last_update_login = FND_GLOBAL.LOGIN_ID
703: WHERE id IN (SELECT id FROM bis_bucket_customizations WHERE bucket_id = p_bucket_id)
704: AND language = l_lang_rec.language_code;
705:

Line 702: last_update_login = FND_GLOBAL.LOGIN_ID

698: range9_name = l_base_bucket_tl_rec.range9_name,
699: range10_name = l_base_bucket_tl_rec.range10_name,
700: last_update_date = SYSDATE,
701: last_updated_by = FND_GLOBAL.USER_ID,
702: last_update_login = FND_GLOBAL.LOGIN_ID
703: WHERE id IN (SELECT id FROM bis_bucket_customizations WHERE bucket_id = p_bucket_id)
704: AND language = l_lang_rec.language_code;
705:
706: END IF;

Line 912: l_user_id := fnd_global.user_id;

908:
909: BEGIN
910: SAVEPOINT SP_CREATE_BUCKET;
911:
912: l_user_id := fnd_global.user_id;
913: l_login_id := fnd_global.LOGIN_ID;
914: l_bis_bucket_rec := p_bis_bucket_rec;
915:
916: BIS_BUCKET_PVT.Validate_Bucket (

Line 913: l_login_id := fnd_global.LOGIN_ID;

909: BEGIN
910: SAVEPOINT SP_CREATE_BUCKET;
911:
912: l_user_id := fnd_global.user_id;
913: l_login_id := fnd_global.LOGIN_ID;
914: l_bis_bucket_rec := p_bis_bucket_rec;
915:
916: BIS_BUCKET_PVT.Validate_Bucket (
917: p_bis_bucket_rec => l_bis_bucket_rec

Line 1236: l_user_id := fnd_global.USER_ID;

1232:
1233: BEGIN
1234: SAVEPOINT SP_UPDATE_BUCKET;
1235:
1236: l_user_id := fnd_global.USER_ID;
1237: l_login_id := fnd_global.LOGIN_ID;
1238:
1239: l_short_name := p_bis_bucket_rec.short_name;
1240:

Line 1237: l_login_id := fnd_global.LOGIN_ID;

1233: BEGIN
1234: SAVEPOINT SP_UPDATE_BUCKET;
1235:
1236: l_user_id := fnd_global.USER_ID;
1237: l_login_id := fnd_global.LOGIN_ID;
1238:
1239: l_short_name := p_bis_bucket_rec.short_name;
1240:
1241: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.short_name);

Line 1774: l_user_id := fnd_global.user_id;

1770:
1771: IF (p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER) THEN
1772: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
1773: ELSE
1774: l_user_id := fnd_global.user_id;
1775: END IF;
1776:
1777: l_login_id := fnd_global.LOGIN_ID;
1778:

Line 1777: l_login_id := fnd_global.LOGIN_ID;

1773: ELSE
1774: l_user_id := fnd_global.user_id;
1775: END IF;
1776:
1777: l_login_id := fnd_global.LOGIN_ID;
1778:
1779: UPDATE BIS_BUCKET_TL
1780: SET
1781: NAME = l_bis_bucket_rec.name