DBA Data[Home] [Help]

APPS.JTF_MSITE_GRP dependencies on FND_GLOBAL

Line 571: FND_GLOBAL.user_id,

567: VALUES (
568: l_msite_id,
569: 1,
570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.user_id,
575: p_msite_rec.start_date_active,

Line 573: FND_GLOBAL.user_id,

569: 1,
570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.user_id,
575: p_msite_rec.start_date_active,
576: p_msite_rec.end_date_active,
577: p_msite_rec.date_format,

Line 574: FND_GLOBAL.user_id,

570: SYSDATE,
571: FND_GLOBAL.user_id,
572: SYSDATE,
573: FND_GLOBAL.user_id,
574: FND_GLOBAL.user_id,
575: p_msite_rec.start_date_active,
576: p_msite_rec.end_date_active,
577: p_msite_rec.date_format,
578: p_msite_rec.profile_id,

Line 606: FND_GLOBAL.user_id,

602: LANGUAGE,
603: SOURCE_LANG ) select
604: l_msite_id,
605: sysdate,
606: FND_GLOBAL.user_id,
607: sysdate,
608: FND_GLOBAL.user_id,
609: FND_GLOBAL.user_id,
610: 1,

Line 608: FND_GLOBAL.user_id,

604: l_msite_id,
605: sysdate,
606: FND_GLOBAL.user_id,
607: sysdate,
608: FND_GLOBAL.user_id,
609: FND_GLOBAL.user_id,
610: 1,
611: p_msite_rec.Display_name,
612: p_msite_rec.description,

Line 609: FND_GLOBAL.user_id,

605: sysdate,
606: FND_GLOBAL.user_id,
607: sysdate,
608: FND_GLOBAL.user_id,
609: FND_GLOBAL.user_id,
610: 1,
611: p_msite_rec.Display_name,
612: p_msite_rec.description,
613: L.LANGUAGE_CODE,

Line 671: LAST_UPDATED_BY = FND_GLOBAL.user_id,

667: END IF;
668:
669: UPDATE JTF_MSITES_B SET
670: LAST_UPDATE_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
673: PROFILE_ID = p_msite_rec.profile_id,
674: DEFAULT_DATE_FORMAT = p_msite_rec.date_format ,
675: MASTER_MSITE_FLAG = l_msite_master_flag,

Line 672: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,

668:
669: UPDATE JTF_MSITES_B SET
670: LAST_UPDATE_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
673: PROFILE_ID = p_msite_rec.profile_id,
674: DEFAULT_DATE_FORMAT = p_msite_rec.date_format ,
675: MASTER_MSITE_FLAG = l_msite_master_flag,
676: WALKIN_ALLOWED_FLAG = walkin_allowed_code,

Line 699: LAST_UPDATED_BY = FND_GLOBAL.user_id,

695: MSITE_NAME, p_msite_rec.Display_name),
696: MSITE_DESCRIPTION = decode( p_msite_rec.description,
697: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),
698: LAST_UPDATE_DATE = SYSDATE,
699: LAST_UPDATED_BY = FND_GLOBAL.user_id,
700: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
701: OBJECT_VERSION_NUMBER= p_msite_rec.object_version_number +1 ,
702: SOURCE_LANG = userenv('LANG')
703: where msite_id = p_msite_rec.msite_id

Line 700: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,

696: MSITE_DESCRIPTION = decode( p_msite_rec.description,
697: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),
698: LAST_UPDATE_DATE = SYSDATE,
699: LAST_UPDATED_BY = FND_GLOBAL.user_id,
700: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
701: OBJECT_VERSION_NUMBER= p_msite_rec.object_version_number +1 ,
702: SOURCE_LANG = userenv('LANG')
703: where msite_id = p_msite_rec.msite_id
704: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 941: FND_GLOBAL.user_id,

937: VALUES (
938: l_msite_languages_id,
939: 1,
940: SYSDATE,
941: FND_GLOBAL.user_id,
942: SYSDATE,
943: FND_GLOBAL.user_id,
944: FND_GLOBAL.user_id,
945: p_msite_id,

Line 943: FND_GLOBAL.user_id,

939: 1,
940: SYSDATE,
941: FND_GLOBAL.user_id,
942: SYSDATE,
943: FND_GLOBAL.user_id,
944: FND_GLOBAL.user_id,
945: p_msite_id,
946: p_msite_languages_tbl(l_index).language_code);
947:

Line 944: FND_GLOBAL.user_id,

940: SYSDATE,
941: FND_GLOBAL.user_id,
942: SYSDATE,
943: FND_GLOBAL.user_id,
944: FND_GLOBAL.user_id,
945: p_msite_id,
946: p_msite_languages_tbl(l_index).language_code);
947:
948: --dbms_output.put_line('inserted language passed ' );

Line 1137: FND_GLOBAL.user_id,

1133: VALUES (
1134: l_msite_currencies_id,
1135: 1,
1136: SYSDATE,
1137: FND_GLOBAL.user_id,
1138: SYSDATE,
1139: FND_GLOBAL.user_id,
1140: FND_GLOBAL.user_id,
1141: p_msite_id,

Line 1139: FND_GLOBAL.user_id,

1135: 1,
1136: SYSDATE,
1137: FND_GLOBAL.user_id,
1138: SYSDATE,
1139: FND_GLOBAL.user_id,
1140: FND_GLOBAL.user_id,
1141: p_msite_id,
1142: p_msite_currencies_tbl(l_index).currency_code,
1143: p_msite_currencies_tbl(l_index).walkin_prc_lst_id,

Line 1140: FND_GLOBAL.user_id,

1136: SYSDATE,
1137: FND_GLOBAL.user_id,
1138: SYSDATE,
1139: FND_GLOBAL.user_id,
1140: FND_GLOBAL.user_id,
1141: p_msite_id,
1142: p_msite_currencies_tbl(l_index).currency_code,
1143: p_msite_currencies_tbl(l_index).walkin_prc_lst_id,
1144: p_msite_currencies_tbl(l_index).registered_prc_lst_id,

Line 1340: FND_GLOBAL.user_id,

1336: VALUES (
1337: l_msite_org_id,
1338: 1,
1339: SYSDATE,
1340: FND_GLOBAL.user_id,
1341: SYSDATE,
1342: FND_GLOBAL.user_id,
1343: FND_GLOBAL.user_id,
1344: p_msite_id,

Line 1342: FND_GLOBAL.user_id,

1338: 1,
1339: SYSDATE,
1340: FND_GLOBAL.user_id,
1341: SYSDATE,
1342: FND_GLOBAL.user_id,
1343: FND_GLOBAL.user_id,
1344: p_msite_id,
1345: p_msite_orgids_tbl(l_index).orgid);
1346: --dbms_output.put_line('inserted into opr org');

Line 1343: FND_GLOBAL.user_id,

1339: SYSDATE,
1340: FND_GLOBAL.user_id,
1341: SYSDATE,
1342: FND_GLOBAL.user_id,
1343: FND_GLOBAL.user_id,
1344: p_msite_id,
1345: p_msite_orgids_tbl(l_index).orgid);
1346: --dbms_output.put_line('inserted into opr org');
1347: l_insert_row := l_insert_row + 1;