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.GMS_WF_PKG dependencies on FND_GLOBAL

Line 1715: USER_ID => fnd_global.user_id,

1711:
1712: -- Bug 2386041
1713: l_user_profile_value1 := fnd_profile.value_specific(
1714: NAME => 'PA_SUPER_PROJECT',
1715: USER_ID => fnd_global.user_id,
1716: RESPONSIBILITY_ID => fnd_global.resp_id,
1717: APPLICATION_ID => fnd_global.resp_appl_id);
1718:
1719: if ((l_user_profile_value1 = 'N') OR (l_user_profile_value1 is null)) then

Line 1716: RESPONSIBILITY_ID => fnd_global.resp_id,

1712: -- Bug 2386041
1713: l_user_profile_value1 := fnd_profile.value_specific(
1714: NAME => 'PA_SUPER_PROJECT',
1715: USER_ID => fnd_global.user_id,
1716: RESPONSIBILITY_ID => fnd_global.resp_id,
1717: APPLICATION_ID => fnd_global.resp_appl_id);
1718:
1719: if ((l_user_profile_value1 = 'N') OR (l_user_profile_value1 is null)) then
1720:

Line 1717: APPLICATION_ID => fnd_global.resp_appl_id);

1713: l_user_profile_value1 := fnd_profile.value_specific(
1714: NAME => 'PA_SUPER_PROJECT',
1715: USER_ID => fnd_global.user_id,
1716: RESPONSIBILITY_ID => fnd_global.resp_id,
1717: APPLICATION_ID => fnd_global.resp_appl_id);
1718:
1719: if ((l_user_profile_value1 = 'N') OR (l_user_profile_value1 is null)) then
1720:
1721: BEGIN

Line 1730: AND v.level_value = fnd_global.user_id;

1726: fnd_profile_option_values v
1727: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
1728: AND v.profile_option_id = p.profile_option_id
1729: AND v.level_id = 10004
1730: AND v.level_value = fnd_global.user_id;
1731:
1732: EXCEPTION
1733:
1734: WHEN no_data_found THEN

Line 1746: X_LEVEL_VALUE => fnd_global.user_id);

1742: l_set_profile_success1 := fnd_profile.save(
1743: X_NAME => 'PA_SUPER_PROJECT',
1744: X_VALUE => 'Y',
1745: X_LEVEL_NAME => 'USER',
1746: X_LEVEL_VALUE => fnd_global.user_id);
1747: end if;
1748:
1749: l_user_profile_value2 := fnd_profile.value_specific(
1750: NAME => 'PA_SUPER_PROJECT_VIEW',

Line 1751: USER_ID => fnd_global.user_id,

1747: end if;
1748:
1749: l_user_profile_value2 := fnd_profile.value_specific(
1750: NAME => 'PA_SUPER_PROJECT_VIEW',
1751: USER_ID => fnd_global.user_id,
1752: RESPONSIBILITY_ID => fnd_global.resp_id,
1753: APPLICATION_ID => fnd_global.resp_appl_id);
1754:
1755:

Line 1752: RESPONSIBILITY_ID => fnd_global.resp_id,

1748:
1749: l_user_profile_value2 := fnd_profile.value_specific(
1750: NAME => 'PA_SUPER_PROJECT_VIEW',
1751: USER_ID => fnd_global.user_id,
1752: RESPONSIBILITY_ID => fnd_global.resp_id,
1753: APPLICATION_ID => fnd_global.resp_appl_id);
1754:
1755:
1756: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then

Line 1753: APPLICATION_ID => fnd_global.resp_appl_id);

1749: l_user_profile_value2 := fnd_profile.value_specific(
1750: NAME => 'PA_SUPER_PROJECT_VIEW',
1751: USER_ID => fnd_global.user_id,
1752: RESPONSIBILITY_ID => fnd_global.resp_id,
1753: APPLICATION_ID => fnd_global.resp_appl_id);
1754:
1755:
1756: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then
1757:

Line 1767: AND v.level_value = fnd_global.user_id;

1763: fnd_profile_option_values v
1764: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
1765: AND v.profile_option_id = p.profile_option_id
1766: AND v.level_id = 10004
1767: AND v.level_value = fnd_global.user_id;
1768:
1769: EXCEPTION
1770:
1771: WHEN no_data_found THEN

Line 1783: X_LEVEL_VALUE => fnd_global.user_id);

1779: l_set_profile_success2 := fnd_profile.save(
1780: X_NAME => 'PA_SUPER_PROJECT_VIEW',
1781: X_VALUE => 'Y',
1782: X_LEVEL_NAME => 'USER',
1783: X_LEVEL_VALUE => fnd_global.user_id);
1784:
1785:
1786: end if;
1787: -- Bug 2386041

Line 1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);

1795:
1796: -- Bug 2386041
1797:
1798: if (l_set_profile_success1 = TRUE) then
1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
1800: end if;
1801:
1802: if (l_set_profile_success2 = TRUE) then
1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);

Line 1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);

1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
1800: end if;
1801:
1802: if (l_set_profile_success2 = TRUE) then
1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
1804: end if;
1805: -- Bug 2386041
1806:
1807: if l_return_status <> 'S'

Line 2072: x_workflow_started_by_id number := FND_GLOBAL.User_Id;

2068: ,x_err_stage OUT NOCOPY VARCHAR2)
2069: IS
2070: ItemType varchar2(30) := 'GMSWF';
2071: ItemKey number;
2072: x_workflow_started_by_id number := FND_GLOBAL.User_Id;
2073: x_user_name varchar2(100) := FND_GLOBAL.User_Name;
2074: x_full_name varchar2(65);
2075: x_wf_started_date date := SYSDATE;
2076:

Line 2073: x_user_name varchar2(100) := FND_GLOBAL.User_Name;

2069: IS
2070: ItemType varchar2(30) := 'GMSWF';
2071: ItemKey number;
2072: x_workflow_started_by_id number := FND_GLOBAL.User_Id;
2073: x_user_name varchar2(100) := FND_GLOBAL.User_Name;
2074: x_full_name varchar2(65);
2075: x_wf_started_date date := SYSDATE;
2076:
2077: cursor l_starter_full_name_csr

Line 2086: and user_id = FND_GLOBAL.User_Id

2082: from per_all_people_f pp
2083: where pp.person_id = p.person_id
2084: and pp.effective_end_date >=trunc(sysdate))
2085: and ((p.employee_number is not null) OR (p.npw_number is not null))
2086: and user_id = FND_GLOBAL.User_Id
2087: and f.employee_id = p.person_id;
2088:
2089:
2090:

Line 2590: l_workflow_started_by_id number := FND_GLOBAL.User_Id;

2586: l_install_indirect_cost number;
2587: l_install_total_amount number;
2588: l_install_description varchar(250);
2589:
2590: l_workflow_started_by_id number := FND_GLOBAL.User_Id;
2591: l_user_name varchar2(100) := FND_GLOBAL.User_Name;
2592: l_full_name varchar2(65);
2593: l_wf_started_date date := SYSDATE;
2594:

Line 2591: l_user_name varchar2(100) := FND_GLOBAL.User_Name;

2587: l_install_total_amount number;
2588: l_install_description varchar(250);
2589:
2590: l_workflow_started_by_id number := FND_GLOBAL.User_Id;
2591: l_user_name varchar2(100) := FND_GLOBAL.User_Name;
2592: l_full_name varchar2(65);
2593: l_wf_started_date date := SYSDATE;
2594:
2595: cursor l_starter_full_name_csr

Line 2604: and user_id = FND_GLOBAL.User_Id

2600: from per_all_people_f pp
2601: where pp.person_id = p.person_id
2602: and pp.effective_end_date >=trunc(sysdate))
2603: and ((p.employee_number is not null) OR (p.npw_number is not null))
2604: and user_id = FND_GLOBAL.User_Id
2605: and f.employee_id = p.person_id;
2606:
2607: cursor l_installment_detail_csr
2608: is

Line 2825: NL VARCHAR2(1) := fnd_global.newline;

2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;
2823: l_installment_number gms_installments.installment_num%TYPE;
2824: -- Declare a variable to create a new line.
2825: NL VARCHAR2(1) := fnd_global.newline;
2826: -- Cursor to fetch all the open commitments attached associated with the award ,project and task combination
2827:
2828: CURSOR lookups_cursor (type VARCHAR2) IS
2829: SELECT meaning