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.PA_PROGRESS_REPORT_WORKFLOW dependencies on FND_USER

Line 29: 08/05/05 raluthra Bug 4527617. Replaced fnd_user.customer_id with

25: 28/09/04 smekala Bug 3905748 Closing the cursors.
26: 09/02/05 rvelusam Bug 4165780 Changed attribute 'FORWARD_TO' to
27: FORWARD_TO_USERNAME_RESPONSE and changed the value set
28: for REPORT_APPROVER_USER_NAME.
29: 08/05/05 raluthra Bug 4527617. Replaced fnd_user.customer_id with
30: fnd_user.person_party_id for R12 ATG Mandate fix.
31: 08/05/05 raluthra Bug 4358517: Changed the definition of
32: l_org local variable from VARCHAR2(60) to
33: pa_project_lists_v.carrying_out_organization_name%TYPE

Line 30: fnd_user.person_party_id for R12 ATG Mandate fix.

26: 09/02/05 rvelusam Bug 4165780 Changed attribute 'FORWARD_TO' to
27: FORWARD_TO_USERNAME_RESPONSE and changed the value set
28: for REPORT_APPROVER_USER_NAME.
29: 08/05/05 raluthra Bug 4527617. Replaced fnd_user.customer_id with
30: fnd_user.person_party_id for R12 ATG Mandate fix.
31: 08/05/05 raluthra Bug 4358517: Changed the definition of
32: l_org local variable from VARCHAR2(60) to
33: pa_project_lists_v.carrying_out_organization_name%TYPE
34: 08/09/05 raluthra Bug 4565156. Added code for Manual NOCOPY Changes

Line 285: l_name fnd_user.user_name%type; -- Added for bug 5027098

281:
282: l_version_id NUMBER := 0;
283: l_status VARCHAR2(30);
284: l_ret VARCHAR2(240);
285: l_name fnd_user.user_name%type; -- Added for bug 5027098
286:
287: CURSOR get_progress_status IS
288: SELECT report_status_code
289: FROM pa_progress_report_vers

Line 630: FROM fnd_user

626: --l_reported_emp_id NUMBER;
627:
628: CURSOR get_submitter_emp_id IS
629: SELECT employee_id
630: FROM fnd_user
631: WHERE user_id = l_submitter_id;
632:
633:
634: CURSOR get_reporter_emp_id IS

Line 636: FROM fnd_user

632:
633:
634: CURSOR get_reporter_emp_id IS
635: SELECT employee_id
636: FROM fnd_user
637: WHERE user_id = l_reported_by_id;
638:
639:
640: BEGIN

Line 1046: fnd_user fu,per_all_people_f papf

1042: IS
1043: SELECT papf.full_name person_name,
1044: papf.email_address
1045: FROM
1046: fnd_user fu,per_all_people_f papf
1047: where fu.employee_id = papf.person_id
1048: AND fu.user_name = l_user_name
1049: AND trunc(sysdate) between papf.EFFECTIVE_START_DATE
1050: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 1260: fnd_user fu,per_all_people_f papf

1256: fu.user_name,
1257: papf.email_address,
1258: papf.full_name person_name
1259: from
1260: fnd_user fu,per_all_people_f papf
1261: where
1262: fu.employee_id = l_approver_id
1263: and papf.person_id = fu.employee_id
1264: and trunc(sysdate)

Line 1277: fnd_user fu,per_all_people_f papf

1273: fu.user_name,
1274: papf.email_address,
1275: papf.full_name person_name
1276: from
1277: fnd_user fu,per_all_people_f papf
1278: where
1279: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
1280: and papf.person_id = fu.employee_id
1281: and trunc(sysdate)

Line 1296: fnd_user fu,per_all_people_f papf

1292: papf.full_name person_name,
1293: ppp.resource_source_id
1294: from
1295: pa_project_parties ppp,
1296: fnd_user fu,per_all_people_f papf
1297: where ppp.project_id = l_project_id
1298: and ppp.project_role_id = To_number(l_role_id)
1299: and ppp.project_id = ppp.object_id
1300: AND fu.employee_id = ppp.resource_source_id

Line 1321: fnd_user fu,per_all_people_f p2,

1317: p2.email_address,
1318: p2.full_name person_name
1319: from
1320: pa_proj_parties_prog_ev_v ppp,
1321: fnd_user fu,per_all_people_f p2,
1322: per_assignments_f p1
1323: where ppp.project_id = l_project_id
1324: and ppp.project_role_id = 1
1325: and ppp.resource_source_id = p1.person_id

Line 1830: fnd_user

1826:
1827: CURSOR is_user_valid
1828: IS
1829: SELECT user_id FROM
1830: fnd_user
1831: WHERE user_name = l_forward_to
1832: and trunc(sysdate) between start_date and nvl(end_date, sysdate); /* Bug#3848024 */
1833:
1834:

Line 1840: from fnd_user fu,

1836: IS
1837: -- select party_name from
1838: --(
1839: select hp.party_name
1840: from fnd_user fu,
1841: hz_parties hp
1842: where fu.user_name = l_forward_to --fnd_global.user_id
1843: and fu.employee_id is null
1844: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.

Line 1847: from fnd_user fu,

1843: and fu.employee_id is null
1844: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
1845: union
1846: select hp.party_name
1847: from fnd_user fu,
1848: hz_parties hp
1849: where fu.user_name = l_forward_to--fnd_global.user_id
1850: and fu.employee_id is not null
1851: and 'PER:' || fu.employee_id = hp.orig_system_reference;

Line 2081: fnd_user usr

2077:
2078: CURSOR c_reporter_list IS
2079: select usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
2080: from per_all_people_f papf,
2081: fnd_user usr
2082: WHERE
2083: papf.person_id = usr.employee_id
2084: and trunc(sysdate)
2085: between papf.EFFECTIVE_START_DATE

Line 2219: fnd_user usr

2215:
2216: /* CURSOR c_reporter_list IS
2217: select usr.user_id, usr.customer_id, usr.user_name,papf.email_address,papf.full_name person_name
2218: from per_all_people_f papf,
2219: fnd_user usr
2220: WHERE
2221: papf.person_id = usr.employee_id
2222: and trunc(sysdate)
2223: between papf.EFFECTIVE_START_DATE

Line 2381: fnd_user usr

2377: /*
2378: CURSOR c_reporter_list IS
2379: select usr.user_id, usr.customer_id, usr.user_name,papf.email_address,papf.full_name person_name
2380: from per_all_people_f papf,
2381: fnd_user usr
2382: WHERE
2383: papf.person_id = usr.employee_id
2384: and trunc(sysdate)
2385: between papf.EFFECTIVE_START_DATE