DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP dependencies on FND_GLOBAL

Line 609: FND_GLOBAL.user_id,

605: VALUES (
606: l_msite_id,
607: 1,
608: SYSDATE,
609: FND_GLOBAL.user_id,
610: SYSDATE,
611: FND_GLOBAL.user_id,
612: FND_GLOBAL.user_id,
613: p_msite_rec.start_date_active,

Line 611: FND_GLOBAL.user_id,

607: 1,
608: SYSDATE,
609: FND_GLOBAL.user_id,
610: SYSDATE,
611: FND_GLOBAL.user_id,
612: FND_GLOBAL.user_id,
613: p_msite_rec.start_date_active,
614: p_msite_rec.end_date_active,
615: p_msite_rec.date_format,

Line 612: FND_GLOBAL.user_id,

608: SYSDATE,
609: FND_GLOBAL.user_id,
610: SYSDATE,
611: FND_GLOBAL.user_id,
612: FND_GLOBAL.user_id,
613: p_msite_rec.start_date_active,
614: p_msite_rec.end_date_active,
615: p_msite_rec.date_format,
616: p_msite_rec.profile_id,

Line 654: FND_GLOBAL.user_id,

650: LANGUAGE,
651: SOURCE_LANG ) select
652: l_msite_id,
653: sysdate,
654: FND_GLOBAL.user_id,
655: sysdate,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.user_id,
658: 1,

Line 656: FND_GLOBAL.user_id,

652: l_msite_id,
653: sysdate,
654: FND_GLOBAL.user_id,
655: sysdate,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.user_id,
658: 1,
659: p_msite_rec.Display_name,
660: p_msite_rec.description,

Line 657: FND_GLOBAL.user_id,

653: sysdate,
654: FND_GLOBAL.user_id,
655: sysdate,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.user_id,
658: 1,
659: p_msite_rec.Display_name,
660: p_msite_rec.description,
661: L.LANGUAGE_CODE,

Line 744: LAST_UPDATED_BY = FND_GLOBAL.user_id,

740: END IF;
741:
742: UPDATE IBE_MSITES_B SET
743: LAST_UPDATE_DATE = SYSDATE,
744: LAST_UPDATED_BY = FND_GLOBAL.user_id,
745: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
746: PROFILE_ID = p_msite_rec.profile_id,
747: DEFAULT_DATE_FORMAT = p_msite_rec.date_format ,
748: MASTER_MSITE_FLAG = l_msite_master_flag,

Line 745: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,

741:
742: UPDATE IBE_MSITES_B SET
743: LAST_UPDATE_DATE = SYSDATE,
744: LAST_UPDATED_BY = FND_GLOBAL.user_id,
745: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
746: PROFILE_ID = p_msite_rec.profile_id,
747: DEFAULT_DATE_FORMAT = p_msite_rec.date_format ,
748: MASTER_MSITE_FLAG = l_msite_master_flag,
749: WALKIN_ALLOWED_FLAG = walkin_allowed_code,

Line 782: LAST_UPDATED_BY = FND_GLOBAL.user_id,

778: MSITE_NAME, p_msite_rec.Display_name),
779: MSITE_DESCRIPTION = decode( p_msite_rec.description,
780: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),
781: LAST_UPDATE_DATE = SYSDATE,
782: LAST_UPDATED_BY = FND_GLOBAL.user_id,
783: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
784: OBJECT_VERSION_NUMBER= p_msite_rec.object_version_number +1 ,
785: SOURCE_LANG = userenv('LANG')
786: where msite_id = p_msite_rec.msite_id

Line 783: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,

779: MSITE_DESCRIPTION = decode( p_msite_rec.description,
780: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),
781: LAST_UPDATE_DATE = SYSDATE,
782: LAST_UPDATED_BY = FND_GLOBAL.user_id,
783: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
784: OBJECT_VERSION_NUMBER= p_msite_rec.object_version_number +1 ,
785: SOURCE_LANG = userenv('LANG')
786: where msite_id = p_msite_rec.msite_id
787: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 1620: FND_GLOBAL.user_id,

1616: VALUES (
1617: l_msite_languages_id,
1618: 1,
1619: SYSDATE,
1620: FND_GLOBAL.user_id,
1621: SYSDATE,
1622: FND_GLOBAL.user_id,
1623: FND_GLOBAL.user_id,
1624: p_msite_id,

Line 1622: FND_GLOBAL.user_id,

1618: 1,
1619: SYSDATE,
1620: FND_GLOBAL.user_id,
1621: SYSDATE,
1622: FND_GLOBAL.user_id,
1623: FND_GLOBAL.user_id,
1624: p_msite_id,
1625: p_msite_languages_tbl(l_index).language_code,
1626: p_msite_languages_tbl(l_index).enable_flag);

Line 1623: FND_GLOBAL.user_id,

1619: SYSDATE,
1620: FND_GLOBAL.user_id,
1621: SYSDATE,
1622: FND_GLOBAL.user_id,
1623: FND_GLOBAL.user_id,
1624: p_msite_id,
1625: p_msite_languages_tbl(l_index).language_code,
1626: p_msite_languages_tbl(l_index).enable_flag);
1627:

Line 1880: FND_GLOBAL.user_id,

1876: VALUES (
1877: l_msite_currencies_id,
1878: 1,
1879: SYSDATE,
1880: FND_GLOBAL.user_id,
1881: SYSDATE,
1882: FND_GLOBAL.user_id,
1883: FND_GLOBAL.user_id,
1884: p_msite_id,

Line 1882: FND_GLOBAL.user_id,

1878: 1,
1879: SYSDATE,
1880: FND_GLOBAL.user_id,
1881: SYSDATE,
1882: FND_GLOBAL.user_id,
1883: FND_GLOBAL.user_id,
1884: p_msite_id,
1885: p_msite_currencies_tbl(l_index).currency_code,
1886: p_msite_currencies_tbl(l_index).walkin_prc_lst_id,

Line 1883: FND_GLOBAL.user_id,

1879: SYSDATE,
1880: FND_GLOBAL.user_id,
1881: SYSDATE,
1882: FND_GLOBAL.user_id,
1883: FND_GLOBAL.user_id,
1884: p_msite_id,
1885: p_msite_currencies_tbl(l_index).currency_code,
1886: p_msite_currencies_tbl(l_index).walkin_prc_lst_id,
1887: p_msite_currencies_tbl(l_index).registered_prc_lst_id,

Line 2090: FND_GLOBAL.user_id,

2086: VALUES (
2087: l_msite_org_id,
2088: 1,
2089: SYSDATE,
2090: FND_GLOBAL.user_id,
2091: SYSDATE,
2092: FND_GLOBAL.user_id,
2093: FND_GLOBAL.user_id,
2094: p_msite_id,

Line 2092: FND_GLOBAL.user_id,

2088: 1,
2089: SYSDATE,
2090: FND_GLOBAL.user_id,
2091: SYSDATE,
2092: FND_GLOBAL.user_id,
2093: FND_GLOBAL.user_id,
2094: p_msite_id,
2095: p_msite_orgids_tbl(l_index).orgid);
2096: --dbms_output.put_line('inserted into opr org');

Line 2093: FND_GLOBAL.user_id,

2089: SYSDATE,
2090: FND_GLOBAL.user_id,
2091: SYSDATE,
2092: FND_GLOBAL.user_id,
2093: FND_GLOBAL.user_id,
2094: p_msite_id,
2095: p_msite_orgids_tbl(l_index).orgid);
2096: --dbms_output.put_line('inserted into opr org');
2097: l_insert_row := l_insert_row + 1;