DBA Data[Home] [Help]

APPS.MSD_DEM_PUSH_SETUP_PARAMETERS dependencies on FND_GLOBAL

Line 896: g_user_id := fnd_global.user_id;

892: msd_dem_common_utilities.log_message (' Source Instance ID : ' || p_sr_instance_id);
893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:
896: g_user_id := fnd_global.user_id;
897: g_login_id := fnd_global.login_id;
898:
899: /* Set the profile MSD_DEM_CUSTOMER_ATTRIBUTE to 'NONE' if collecting for the first time
900: check_customer_attribute (

Line 897: g_login_id := fnd_global.login_id;

893: msd_dem_common_utilities.log_message (' DB Link: ' || g_dblink);
894: msd_dem_common_utilities.log_message (' ');
895:
896: g_user_id := fnd_global.user_id;
897: g_login_id := fnd_global.login_id;
898:
899: /* Set the profile MSD_DEM_CUSTOMER_ATTRIBUTE to 'NONE' if collecting for the first time
900: check_customer_attribute (
901: x_errbuf,

Line 1022: g_user_id := fnd_global.user_id;

1018: msd_dem_common_utilities.log_message ('Deleting records from msd_dem_legacy_setup_params, for instance_id : ' || p_legacy_instance_id );
1019: x_sql := 'DELETE FROM msd_dem_legacy_setup_params where instance_id = ' || p_legacy_instance_id;
1020: EXECUTE IMMEDIATE x_sql;
1021:
1022: g_user_id := fnd_global.user_id;
1023: g_login_id := fnd_global.login_id;
1024:
1025: /* Insert values for the two parameters
1026: * MSD_DEM_MASTER_ORG and MSD_DEM_CATEGORY_SET_NAME

Line 1023: g_login_id := fnd_global.login_id;

1019: x_sql := 'DELETE FROM msd_dem_legacy_setup_params where instance_id = ' || p_legacy_instance_id;
1020: EXECUTE IMMEDIATE x_sql;
1021:
1022: g_user_id := fnd_global.user_id;
1023: g_login_id := fnd_global.login_id;
1024:
1025: /* Insert values for the two parameters
1026: * MSD_DEM_MASTER_ORG and MSD_DEM_CATEGORY_SET_NAME
1027: * into MSD_DEM_LEGACY_SETUP_PARAMS table

Line 1079: g_user_id := fnd_global.user_id;

1075: msd_dem_common_utilities.log_message (' ------------------------------------');
1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:
1079: g_user_id := fnd_global.user_id;
1080: g_login_id := fnd_global.login_id;
1081:
1082: -- Bug#12931039 mpmurali
1083: /* Push the time data to the source instance */

Line 1080: g_login_id := fnd_global.login_id;

1076: msd_dem_common_utilities.log_message (' Legacy Instance ID : ' || p_legacy_instance_id);
1077: msd_dem_common_utilities.log_message (' ');
1078:
1079: g_user_id := fnd_global.user_id;
1080: g_login_id := fnd_global.login_id;
1081:
1082: -- Bug#12931039 mpmurali
1083: /* Push the time data to the source instance */
1084: msd_dem_common_utilities.log_message ('Pushing time data for Legacy Instance');

Line 1126: g_user_id := fnd_global.user_id;

1122: msd_dem_common_utilities.log_message ('Deleting records for profiles ' || g_master_org || ' and ' || g_sr_category_set || ' from msd_dem_setup_parameters in the destination instance');
1123: x_sql := 'DELETE FROM msd_dem_setup_parameters where parameter_name in (''' || g_master_org || ''', ''' || g_sr_category_set || ''')';
1124: EXECUTE IMMEDIATE x_sql;
1125:
1126: g_user_id := fnd_global.user_id;
1127: g_login_id := fnd_global.login_id;
1128:
1129: /* Insert values for the two profiles
1130: * MSD_DEM_MASTER_ORG and MSD_DEM_CATEGORY_SET_NAME

Line 1127: g_login_id := fnd_global.login_id;

1123: x_sql := 'DELETE FROM msd_dem_setup_parameters where parameter_name in (''' || g_master_org || ''', ''' || g_sr_category_set || ''')';
1124: EXECUTE IMMEDIATE x_sql;
1125:
1126: g_user_id := fnd_global.user_id;
1127: g_login_id := fnd_global.login_id;
1128:
1129: /* Insert values for the two profiles
1130: * MSD_DEM_MASTER_ORG and MSD_DEM_CATEGORY_SET_NAME
1131: * into MSD_DEM_SETUP_PARAMETERS table