[Home] [Help]
40: CLOSE_CI_ACTION and KEEP_OPEN with action assignee and not by fnd_global.user_id.
41: 01-12-04 sukhanna Bug 3974641. Replacing PA_CI_CI_REVIEW_LAYOUT AK region name with the xml file name CiCiReviewPG.
42: 10-Dec-04 rasinha Bug 4049901. Modified the procedure to set the role_display_name for
43: Action Assignee notification to the full name of the action assignee.
44: 03-Aug-05 raluthra Bug 4527617. Replaced the usage of fnd_user.
45: customer_id with fnd_user.person_party_id
46: for R12 ATG Mandate.
47: 10-Aug-05 rasinha Bug# 4527911:
48: 1)Added the procedure close_notification to close an open action notification.
41: 01-12-04 sukhanna Bug 3974641. Replacing PA_CI_CI_REVIEW_LAYOUT AK region name with the xml file name CiCiReviewPG.
42: 10-Dec-04 rasinha Bug 4049901. Modified the procedure to set the role_display_name for
43: Action Assignee notification to the full name of the action assignee.
44: 03-Aug-05 raluthra Bug 4527617. Replaced the usage of fnd_user.
45: customer_id with fnd_user.person_party_id
46: for R12 ATG Mandate.
47: 10-Aug-05 rasinha Bug# 4527911:
48: 1)Added the procedure close_notification to close an open action notification.
49: 2)Modified the KEEP_OPEN procedure to avoid adding comments if it is already being done.
475: and ps.enable_wf_flag = 'Y'
476: and ps.wf_success_status_code is NOT NULL;
477:
478: -- Added for Bug 6053648
479: cursor c_user_id(p_user_name fnd_user.user_name%type) is
480: select user_id
481: from fnd_user
482: where user_name = p_user_name;
483:
477:
478: -- Added for Bug 6053648
479: cursor c_user_id(p_user_name fnd_user.user_name%type) is
480: select user_id
481: from fnd_user
482: where user_name = p_user_name;
483:
484: l_user_id fnd_user.user_id%type;
485: -- End for Bug 6053648
480: select user_id
481: from fnd_user
482: where user_name = p_user_name;
483:
484: l_user_id fnd_user.user_id%type;
485: -- End for Bug 6053648
486:
487:
488: BEGIN
610:
611: CURSOR get_user_name
612: IS
613: SELECT user_name
614: FROM fnd_user
615: WHERE user_id = FND_GLOBAL.user_id;
616:
617: BEGIN
618:
757:
758: CURSOR is_user_valid
759: IS
760: SELECT user_id FROM
761: fnd_user
762: WHERE user_name = l_forward_to
763: and trunc(sysdate) between start_date and nvl(end_date, sysdate); /* Bug#3838957 */
764:
765:
767: IS
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.
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 */
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 */
1409: IS
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))
2069:
2070: -- Added the cursor for bug# 3877985 Issue# 2
2071: CURSOR get_fnd_usr( p_party_id NUMBER) IS
2072: select user_id
2073: from fnd_user
2074: where person_party_id = p_party_id
2075: and sysdate between trunc(start_date) and nvl(trunc(end_date),sysdate)
2076: and rownum = 1;
2077:
2150: l_user_sign_off := 'N';
2151: end if;
2152:
2153: --Added for bug# 3877985.
2154: --Fetching the fnd user_id for the action asignee to update who columns
2155: OPEN get_fnd_usr( l_assign_party_id);
2156: FETCH get_fnd_usr INTO l_fnd_usr_id;
2157: CLOSE get_fnd_usr;
2158: PA_CI_ACTIONS_PKG.UPDATE_ROW(
2256:
2257: -- Added the cursor for bug# 3877985 Issue# 2
2258: CURSOR get_fnd_usr( p_party_id NUMBER) IS
2259: select user_id
2260: from fnd_user
2261: where person_party_id = p_party_id
2262: and sysdate between trunc(start_date) and nvl(trunc(end_date),sysdate)
2263: and rownum = 1;
2264:
2353: if (l_comment_text IS NULL) THEN
2354: l_comment_text := ' ';
2355: end if;
2356:
2357: --Fetching the fnd user_id for the action asignee to update who columns
2358: OPEN get_fnd_usr( l_assign_party_id);
2359: FETCH get_fnd_usr INTO l_fnd_usr_id;
2360: CLOSE get_fnd_usr;
2361: