APPS.PN_AM_WF dependencies on WF_ROLES

Line 738: CURSOR wf_roles_csr (c_emp_id NUMBER, c_system VARCHAR2)

734: x_name OUT NOCOPY VARCHAR2,
735: x_description OUT NOCOPY VARCHAR2
736: )
737: IS
738: CURSOR wf_roles_csr (c_emp_id NUMBER, c_system VARCHAR2)
739: IS
740: SELECT NAME, display_name
741: FROM wf_roles
742: WHERE orig_system_id = c_emp_id AND orig_system = c_system;

Line 741: FROM wf_roles

737: IS
738: CURSOR wf_roles_csr (c_emp_id NUMBER, c_system VARCHAR2)
739: IS
740: SELECT NAME, display_name
741: FROM wf_roles
742: WHERE orig_system_id = c_emp_id AND orig_system = c_system;
743:
744: CURSOR fnd_users_csr (c_user_id NUMBER)
745: IS

Line 777: OPEN wf_roles_csr (p_user_id, 'PER');

773:
774: IF fnd_users_csr%NOTFOUND
775: THEN
776: -- 2nd check if id passed belongs to an employee rather then fnd user
777: OPEN wf_roles_csr (p_user_id, 'PER');
778:
779: FETCH wf_roles_csr
780: INTO l_user, l_desc;
781:

Line 779: FETCH wf_roles_csr

775: THEN
776: -- 2nd check if id passed belongs to an employee rather then fnd user
777: OPEN wf_roles_csr (p_user_id, 'PER');
778:
779: FETCH wf_roles_csr
780: INTO l_user, l_desc;
781:
782: IF wf_roles_csr%NOTFOUND
783: THEN

Line 782: IF wf_roles_csr%NOTFOUND

778:
779: FETCH wf_roles_csr
780: INTO l_user, l_desc;
781:
782: IF wf_roles_csr%NOTFOUND
783: THEN
784: CLOSE wf_roles_csr;
785:
786: -- Maybe a HR user not attached to FND user

Line 784: CLOSE wf_roles_csr;

780: INTO l_user, l_desc;
781:
782: IF wf_roles_csr%NOTFOUND
783: THEN
784: CLOSE wf_roles_csr;
785:
786: -- Maybe a HR user not attached to FND user
787: OPEN wf_roles_csr (p_user_id, 'HZ_PARTY');
788:

Line 787: OPEN wf_roles_csr (p_user_id, 'HZ_PARTY');

783: THEN
784: CLOSE wf_roles_csr;
785:
786: -- Maybe a HR user not attached to FND user
787: OPEN wf_roles_csr (p_user_id, 'HZ_PARTY');
788:
789: FETCH wf_roles_csr
790: INTO l_user, l_desc;
791:

Line 789: FETCH wf_roles_csr

785:
786: -- Maybe a HR user not attached to FND user
787: OPEN wf_roles_csr (p_user_id, 'HZ_PARTY');
788:
789: FETCH wf_roles_csr
790: INTO l_user, l_desc;
791:
792: CLOSE wf_roles_csr;
793: ELSE

Line 792: CLOSE wf_roles_csr;

788:
789: FETCH wf_roles_csr
790: INTO l_user, l_desc;
791:
792: CLOSE wf_roles_csr;
793: ELSE
794: CLOSE wf_roles_csr;
795: END IF;
796: END IF;

Line 794: CLOSE wf_roles_csr;

790: INTO l_user, l_desc;
791:
792: CLOSE wf_roles_csr;
793: ELSE
794: CLOSE wf_roles_csr;
795: END IF;
796: END IF;
797:
798: CLOSE fnd_users_csr;

Line 803: OPEN wf_roles_csr (l_emp, 'PER');

799:
800: -- if l_emp is not null then the user is attached to an employee
801: IF l_emp IS NOT NULL
802: THEN
803: OPEN wf_roles_csr (l_emp, 'PER');
804:
805: FETCH wf_roles_csr
806: INTO l_user, l_desc;
807:

Line 805: FETCH wf_roles_csr

801: IF l_emp IS NOT NULL
802: THEN
803: OPEN wf_roles_csr (l_emp, 'PER');
804:
805: FETCH wf_roles_csr
806: INTO l_user, l_desc;
807:
808: CLOSE wf_roles_csr;
809: END IF;

Line 808: CLOSE wf_roles_csr;

804:
805: FETCH wf_roles_csr
806: INTO l_user, l_desc;
807:
808: CLOSE wf_roles_csr;
809: END IF;
810:
811: wf_debug ('NOTIFICATION AGENT USER ID' || l_user);
812: