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.

APPS.QPR_SPECIAL_ETL dependencies on FND_GLOBAL

Line 20: l_user_id number := FND_GLOBAL.USER_ID;

16: first_time number := 1;
17: l_dummy number;
18: b_data_present boolean := true;
19:
20: l_user_id number := FND_GLOBAL.USER_ID;
21: d_sysdate date := sysdate;
22: l_login_id number := FND_GLOBAL.LOGIN_ID;
23: l_request_id number := FND_GLOBAL.conc_request_id;
24:

Line 22: l_login_id number := FND_GLOBAL.LOGIN_ID;

18: b_data_present boolean := true;
19:
20: l_user_id number := FND_GLOBAL.USER_ID;
21: d_sysdate date := sysdate;
22: l_login_id number := FND_GLOBAL.LOGIN_ID;
23: l_request_id number := FND_GLOBAL.conc_request_id;
24:
25: c_measures SYS_REFCURSOR;
26: c_cost_data COST_REC_TYPE;

Line 23: l_request_id number := FND_GLOBAL.conc_request_id;

19:
20: l_user_id number := FND_GLOBAL.USER_ID;
21: d_sysdate date := sysdate;
22: l_login_id number := FND_GLOBAL.LOGIN_ID;
23: l_request_id number := FND_GLOBAL.conc_request_id;
24:
25: c_measures SYS_REFCURSOR;
26: c_cost_data COST_REC_TYPE;
27: t_meas_id num_type;

Line 758: l_user_id number := FND_GLOBAL.USER_ID;

754: date_to date;
755: date_to_trx date;
756: date_from_trx date;
757: -- who columns ---
758: l_user_id number := FND_GLOBAL.USER_ID;
759: d_sysdate date := sysdate;
760: l_login_id number := FND_GLOBAL.LOGIN_ID;
761: l_request_id number := FND_GLOBAL.conc_request_id;
762:

Line 760: l_login_id number := FND_GLOBAL.LOGIN_ID;

756: date_from_trx date;
757: -- who columns ---
758: l_user_id number := FND_GLOBAL.USER_ID;
759: d_sysdate date := sysdate;
760: l_login_id number := FND_GLOBAL.LOGIN_ID;
761: l_request_id number := FND_GLOBAL.conc_request_id;
762:
763: begin
764:

Line 761: l_request_id number := FND_GLOBAL.conc_request_id;

757: -- who columns ---
758: l_user_id number := FND_GLOBAL.USER_ID;
759: d_sysdate date := sysdate;
760: l_login_id number := FND_GLOBAL.LOGIN_ID;
761: l_request_id number := FND_GLOBAL.conc_request_id;
762:
763: begin
764:
765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));

Line 976: and temp.request_id = fnd_global.conc_request_id

972: om_alloc.measure2_number
973: from qpr_measure_data temp, qpr_measure_data om_alloc
974: where temp.instance_id=-999
975: and temp.measure_type_code = 'OFFADJDATA'
976: and temp.request_id = fnd_global.conc_request_id
977: and om_alloc.instance_id=p_instance_id
978: and om_alloc.measure_type_code = 'SALESDATA'
979: and om_alloc.time_level_value between p_from_date and p_to_date
980: and om_alloc.cus_level_value = temp.cus_level_value

Line 987: l_user_id number := FND_GLOBAL.USER_ID;

983: c_offadj_data OFFADJ_REC_TYPE;
984: l_rows natural :=1000;
985:
986: -- who columns ---
987: l_user_id number := FND_GLOBAL.USER_ID;
988: d_sysdate date := sysdate;
989: l_login_id number:= FND_GLOBAL.LOGIN_ID;
990: l_request_id number:= FND_GLOBAL.conc_request_id;
991:

Line 989: l_login_id number:= FND_GLOBAL.LOGIN_ID;

985:
986: -- who columns ---
987: l_user_id number := FND_GLOBAL.USER_ID;
988: d_sysdate date := sysdate;
989: l_login_id number:= FND_GLOBAL.LOGIN_ID;
990: l_request_id number:= FND_GLOBAL.conc_request_id;
991:
992: begin
993: fnd_file.put_line(fnd_file.log,'Allocation ');

Line 990: l_request_id number:= FND_GLOBAL.conc_request_id;

986: -- who columns ---
987: l_user_id number := FND_GLOBAL.USER_ID;
988: d_sysdate date := sysdate;
989: l_login_id number:= FND_GLOBAL.LOGIN_ID;
990: l_request_id number:= FND_GLOBAL.conc_request_id;
991:
992: begin
993: fnd_file.put_line(fnd_file.log,'Allocation ');
994:

Line 1231: last_updated_by = fnd_global.user_id,

1227: measure14_number = rec_upd_det.measure2(i),
1228: measure17_number = rec_upd_det.measure3(i),
1229: measure20_number = rec_upd_det.measure4(i),
1230: last_update_date = sysdate,
1231: last_updated_by = fnd_global.user_id,
1232: last_update_login = fnd_global.login_id,
1233: request_id = fnd_global.conc_request_id
1234: where measure_value_id = rec_upd_det.measure_value_id(i);
1235:

Line 1232: last_update_login = fnd_global.login_id,

1228: measure17_number = rec_upd_det.measure3(i),
1229: measure20_number = rec_upd_det.measure4(i),
1230: last_update_date = sysdate,
1231: last_updated_by = fnd_global.user_id,
1232: last_update_login = fnd_global.login_id,
1233: request_id = fnd_global.conc_request_id
1234: where measure_value_id = rec_upd_det.measure_value_id(i);
1235:
1236: rec_upd_det.measure_value_id.delete;

Line 1233: request_id = fnd_global.conc_request_id

1229: measure20_number = rec_upd_det.measure4(i),
1230: last_update_date = sysdate,
1231: last_updated_by = fnd_global.user_id,
1232: last_update_login = fnd_global.login_id,
1233: request_id = fnd_global.conc_request_id
1234: where measure_value_id = rec_upd_det.measure_value_id(i);
1235:
1236: rec_upd_det.measure_value_id.delete;
1237: rec_upd_det.measure1.delete;

Line 1384: fnd_global.user_id,

1380: 'PR_SEGMENT',
1381: l_pr_segment_id,
1382: l_pr_segment_desc,
1383: sysdate,
1384: fnd_global.user_id,
1385: sysdate,
1386: fnd_global.user_id,
1387: fnd_global.login_id);
1388: end;

Line 1386: fnd_global.user_id,

1382: l_pr_segment_desc,
1383: sysdate,
1384: fnd_global.user_id,
1385: sysdate,
1386: fnd_global.user_id,
1387: fnd_global.login_id);
1388: end;
1389: end if; */
1390:

Line 1387: fnd_global.login_id);

1383: sysdate,
1384: fnd_global.user_id,
1385: sysdate,
1386: fnd_global.user_id,
1387: fnd_global.login_id);
1388: end;
1389: end if; */
1390:
1391: end if;

Line 1406: last_updated_by = fnd_global.user_id,

1402: 'updating pricing segments for measuretype:salesdata');
1403: forall i in t_meas_val_id.first..t_meas_val_id.last
1404: update qpr_measure_data set psg_level_value = t_psg_val(i),
1405: last_update_date = sysdate,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_login = fnd_global.login_id,
1408: request_id = fnd_global.conc_request_id
1409: where measure_value_id = t_meas_val_id(i);
1410:

Line 1407: last_update_login = fnd_global.login_id,

1403: forall i in t_meas_val_id.first..t_meas_val_id.last
1404: update qpr_measure_data set psg_level_value = t_psg_val(i),
1405: last_update_date = sysdate,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_login = fnd_global.login_id,
1408: request_id = fnd_global.conc_request_id
1409: where measure_value_id = t_meas_val_id(i);
1410:
1411: fnd_file.put_line(fnd_file.log,'Updating measuretypes:ADJUSTMENT,OFFADJDATA');

Line 1408: request_id = fnd_global.conc_request_id

1404: update qpr_measure_data set psg_level_value = t_psg_val(i),
1405: last_update_date = sysdate,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_login = fnd_global.login_id,
1408: request_id = fnd_global.conc_request_id
1409: where measure_value_id = t_meas_val_id(i);
1410:
1411: fnd_file.put_line(fnd_file.log,'Updating measuretypes:ADJUSTMENT,OFFADJDATA');
1412: forall i in t_meas_val_id.first..t_meas_val_id.last

Line 1415: last_updated_by = fnd_global.user_id,

1411: fnd_file.put_line(fnd_file.log,'Updating measuretypes:ADJUSTMENT,OFFADJDATA');
1412: forall i in t_meas_val_id.first..t_meas_val_id.last
1413: update qpr_measure_data set psg_level_value = t_psg_val(i),
1414: last_update_date = sysdate,
1415: last_updated_by = fnd_global.user_id,
1416: last_update_login = fnd_global.login_id,
1417: request_id = fnd_global.conc_request_id
1418: where instance_id = p_instance_id
1419: and measure_type_code in ('ADJUSTMENT', 'OFFADJDATA')

Line 1416: last_update_login = fnd_global.login_id,

1412: forall i in t_meas_val_id.first..t_meas_val_id.last
1413: update qpr_measure_data set psg_level_value = t_psg_val(i),
1414: last_update_date = sysdate,
1415: last_updated_by = fnd_global.user_id,
1416: last_update_login = fnd_global.login_id,
1417: request_id = fnd_global.conc_request_id
1418: where instance_id = p_instance_id
1419: and measure_type_code in ('ADJUSTMENT', 'OFFADJDATA')
1420: and ord_level_value = t_ord(i)

Line 1417: request_id = fnd_global.conc_request_id

1413: update qpr_measure_data set psg_level_value = t_psg_val(i),
1414: last_update_date = sysdate,
1415: last_updated_by = fnd_global.user_id,
1416: last_update_login = fnd_global.login_id,
1417: request_id = fnd_global.conc_request_id
1418: where instance_id = p_instance_id
1419: and measure_type_code in ('ADJUSTMENT', 'OFFADJDATA')
1420: and ord_level_value = t_ord(i)
1421: and time_level_value = t_time(i);