[Home] [Help]
52: 08-Sep-05 raluthra Bug 4565156. Added code for Manual NOCOPY Changes
53: for usage of same variable for In and Out parameter.
54: 01-Feb-06 vgottimu Bug 4923945. Changed the cursor cur_ci_status_n_owner query,
55: pa_ci_list_v is replaced with the base table pa_control_items and
56: included table hz_parties to get the owner name.
57: 26-Apr-07 vvjoshi Bug#5962401:Modified set_workflow_attributes procedure to set expiration date for adhoc role.
58: 25-Jun-07 rballamu Bug#6053648:Modified change_status_approved to initialize the application context.
59: =============================================================================*/
60:
768: -- select party_name from
769: --(
770: select hp.party_name
771: from fnd_user fu,
772: hz_parties hp
773: where fu.user_name = l_forward_to --fnd_global.user_id
774: and fu.employee_id is null
775: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
776: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
776: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
777: union
778: select hp.party_name
779: from fnd_user fu,
780: hz_parties hp
781: where fu.user_name = l_forward_to--fnd_global.user_id
782: and fu.employee_id is not null
783: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
784: and 'PER:' || fu.employee_id = hp.orig_system_reference;
1393: pci.owner_id,
1394: hzp.party_name
1395: from pa_control_items pci,
1396: pa_project_statuses pps,
1397: hz_parties hzp
1398: where pci.ci_id = p_ci_id AND
1399: pci.status_code=pps.project_status_code AND
1400: hzp.party_id = pci.owner_id;
1401:
1410: --select user_name, party_name, email_address
1411: --from (
1412: select fu.user_name, hp.party_name, hp.email_address
1413: from fnd_user fu,
1414: hz_parties hp
1415: where
1416: fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
1417: and hp.party_id = c_owner_id
1418: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
1419: union
1420: select fu.user_name, hp.party_name, hp.email_address
1421: from
1422: fnd_user fu,
1423: hz_parties hp,
1424: per_all_people_f papf
1425: where
1426: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
1427: AND 'PER:' = Substr(hp.orig_system_reference,1,4)