DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on PQH_ROLES

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

3112: actid IN NUMBER,
3113: funcmode IN VARCHAR2,
3114: result OUT NOCOPY VARCHAR2 ) IS
3115:
3116: l_roleType PQH_ROLES.role_type_cd%TYPE := 'HR_REP';
3117: l_PersonId NUMBER(15);
3118: l_bgId NUMBER(15);
3119: l_flag VARCHAR2(1);
3120: l_roleId NUMBER(15);

Line 3121: l_roleName PQH_ROLES.role_name%TYPE;

3117: l_PersonId NUMBER(15);
3118: l_bgId NUMBER(15);
3119: l_flag VARCHAR2(1);
3120: l_roleId NUMBER(15);
3121: l_roleName PQH_ROLES.role_name%TYPE;
3122:
3123: CURSOR cur_wfrole (p_role_id NUMBER) IS
3124: SELECT name
3125: FROM wf_roles