eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on FND_GLOBAL

Line 4352: FND_GLOBAL.LOGIN_ID, systimestamp, systimestamp, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID

4348: EBS_BASE_MODEL_SR_PK, DM_ITEM_SR_PK, DM_ORG_SR_PK,
4349: LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATED_BY, CREATED_BY)
4350: SELECT su.usage_hist_type, su.ebs_base_model_code, su.dm_item_code, su.dm_org_code, mdd.datet, sum(su.quantity), -- Bug#12675064
4351: su.ebs_base_model_sr_pk, su.dm_item_sr_pk, su.dm_org_sr_pk,
4352: FND_GLOBAL.LOGIN_ID, systimestamp, systimestamp, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID
4353: FROM
4354: msd_spf_st_spare_usage su,
4355: msd_dem_dates mdd
4356: WHERE

Line 4858: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

4854: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
4855: ' ''' || x_dest_dblink || ''', ' ||
4856: ' ''CMRO'' ';
4857: execute immediate x_sql using out x_errbuf, out x_retcode,
4858: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
4859: in x_params,
4860: out var_request_id;
4861:
4862: IF (x_retcode = -1) THEN

Line 5660: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

5656: ' ''' || fnd_date.date_to_canonical(x_to_date) || ''', ' ||
5657: ' ''' || x_dest_dblink || ''', ' ||
5658: ' ''FLEET'', ' || '''' || p_sim_plan_name || ''' ';
5659: execute immediate x_sql using out x_errbuf, out x_retcode,
5660: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
5661: in x_params,
5662: out var_request_id;
5663:
5664: IF (x_retcode = -1) THEN

Line 6021: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,

6017: || '''' || var_S2D_dblink || ''','
6018: || ' ''EAM'' ' ;
6019:
6020: EXECUTE IMMEDIATE sql_request USING OUT var_errbuf, OUT var_retcode,
6021: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,
6022: IN x_params,
6023: OUT var_request_id;
6024:
6025: IF (var_retcode = -1) THEN

Line 6681: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,

6677:
6678: x_params := ' ''MSD'', ''MSDDEMPSP'', NULL, NULL, FALSE, ' ||
6679: ' ' || p_sr_instance_id || ', ''' || p_collection_group || ''' ' ;
6680: EXECUTE IMMEDIATE sql_request USING OUT var_errbuf, OUT var_retcode,
6681: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,
6682: IN x_params,
6683: OUT var_request_id;
6684:
6685: IF (var_retcode = -1) THEN

Line 6760: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,

6756: ' ' || G_EAM_MTL_USG_SERIES_ID || ', ''' || x_stg_table || ''', ' ||
6757: ' ' || p_sr_instance_id || ', 0, ' ||
6758: ' ''' || p_from_date || ''', ''' || p_to_date || ''' ';
6759: EXECUTE IMMEDIATE sql_request USING OUT var_errbuf, OUT var_retcode,
6760: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,
6761: IN x_params,
6762: OUT var_request_id ;
6763:
6764: IF (var_retcode = -1) THEN

Line 6807: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,

6803: ' ' || G_EAM_RES_USG_SERIES_ID || ', ''' || x_stg_table || ''', ' ||
6804: ' ' || p_sr_instance_id || ', 0, ' ||
6805: ' ''' || p_from_date || ''', ''' || p_to_date || ''' ';
6806: EXECUTE IMMEDIATE sql_request USING OUT var_errbuf, OUT var_retcode,
6807: IN fnd_global.user_name, IN fnd_global.resp_name, IN fnd_global.application_name,
6808: IN x_params,
6809: OUT var_request_id;
6810:
6811: IF (var_retcode = -1) THEN

Line 6884: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

6880: ' ' || G_CMRO_WO_HIST_SERIES_ID || ', ''' || G_CMRO_WO_HIST_TABLE || ''', ' ||
6881: ' ' || p_sr_instance_id || ', 0, ' ||
6882: ' ''' || p_from_date || ''', ''' || p_to_date || ''' ';
6883: execute immediate sql_request using out var_errbuf, out var_retcode,
6884: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
6885: in x_params,
6886: out var_request_id;
6887:
6888: IF (var_retcode = -1) THEN

Line 6931: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

6927: ' ' || G_CMRO_MTL_USG_SERIES_ID || ', ''' || G_CMRO_MTL_USG_TABLE || ''', ' ||
6928: ' ' || p_sr_instance_id || ', 0, ' ||
6929: ' ''' || p_from_date || ''', ''' || p_to_date || ''' ';
6930: execute immediate sql_request using out var_errbuf, out var_retcode,
6931: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
6932: in x_params,
6933: out var_request_id;
6934:
6935: IF (var_retcode = -1) THEN

Line 6978: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

6974: ' ' || G_CMRO_RES_USG_SERIES_ID || ', ''' || G_CMRO_RES_USG_TABLE || ''', ' ||
6975: ' ' || p_sr_instance_id || ', 0, ' ||
6976: ' ''' || p_from_date || ''', ''' || p_to_date || ''' ';
6977: execute immediate sql_request using out var_errbuf, out var_retcode,
6978: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
6979: in x_params,
6980: out var_request_id;
6981:
6982: IF (var_retcode = -1) THEN

Line 7056: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,

7052: ' ' || p_sr_instance_id || ', 0, ' ||
7053: ' ''' || p_from_date || ''', ''' || p_to_date || ''', ' ||
7054: ' ''' || p_sim_plan_name || ''' ';
7055: execute immediate sql_request using out var_errbuf, out var_retcode,
7056: in fnd_global.user_name, in fnd_global.resp_name, in fnd_global.application_name,
7057: in x_params,
7058: out var_request_id;
7059:
7060: IF (var_retcode = -1) THEN