DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on PQH_ROLES

Line 3148: l_roleType PQH_ROLES.role_type_cd%TYPE := 'HR_REP';

3144: actid IN NUMBER,
3145: funcmode IN VARCHAR2,
3146: result OUT NOCOPY VARCHAR2 ) IS
3147:
3148: l_roleType PQH_ROLES.role_type_cd%TYPE := 'HR_REP';
3149: l_PersonId NUMBER(15);
3150: l_bgId NUMBER(15);
3151: l_flag VARCHAR2(1);
3152: l_roleId NUMBER(15);

Line 3153: l_roleName PQH_ROLES.role_name%TYPE;

3149: l_PersonId NUMBER(15);
3150: l_bgId NUMBER(15);
3151: l_flag VARCHAR2(1);
3152: l_roleId NUMBER(15);
3153: l_roleName PQH_ROLES.role_name%TYPE;
3154:
3155: CURSOR cur_wfrole (p_role_id NUMBER) IS
3156: SELECT name
3157: FROM wf_roles