APPS.AMW_VIOLATION_PVT dependencies on WF_ROLE_HIERARCHY

Line 1861: p_superiors WF_ROLE_HIERARCHY.RELTAB;

1857:
1858: L_API_NAME CONSTANT VARCHAR2(30) := 'BUILD_ROLE_AND_RESP_HIER';
1859: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1860:
1861: p_superiors WF_ROLE_HIERARCHY.RELTAB;
1862: p_subordinates WF_ROLE_HIERARCHY.RELTAB;
1863:
1864: BEGIN
1865:

Line 1862: p_subordinates WF_ROLE_HIERARCHY.RELTAB;

1858: L_API_NAME CONSTANT VARCHAR2(30) := 'BUILD_ROLE_AND_RESP_HIER';
1859: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1860:
1861: p_superiors WF_ROLE_HIERARCHY.RELTAB;
1862: p_subordinates WF_ROLE_HIERARCHY.RELTAB;
1863:
1864: BEGIN
1865:
1866: G_ROLE_NAME_LIST_HIER := P_ROLE_NAME_LIST_HIER;

Line 1877: wf_role_hierarchy.getrelationships(P_ROLE_NAME_LIST_HIER(i),p_superiors,p_subordinates,'SUBORDINATES');

1873: G_PV_COUNT_HIER := P_FUNCTION_ID_LIST_HIER.COUNT;
1874:
1875:
1876: FOR i IN 1 .. P_FUNCTION_ID_LIST_HIER.COUNT LOOP
1877: wf_role_hierarchy.getrelationships(P_ROLE_NAME_LIST_HIER(i),p_superiors,p_subordinates,'SUBORDINATES');
1878:
1879: IF p_subordinates.count > 0 THEN
1880: FOR k IN p_subordinates.first..p_subordinates.last LOOP
1881: IF p_subordinates.exists(k) THEN

Line 1936: p_superiors WF_ROLE_HIERARCHY.RELTAB;

1932: TYPE respCurTyp IS REF CURSOR;
1933: role_c respCurTyp;
1934: resp_c respCurTyp;
1935:
1936: p_superiors WF_ROLE_HIERARCHY.RELTAB;
1937: p_subordinates WF_ROLE_HIERARCHY.RELTAB;
1938:
1939: l_g_role_name VARCHAR2(320);
1940: l_g_responsibility_id NUMBER;

Line 1937: p_subordinates WF_ROLE_HIERARCHY.RELTAB;

1933: role_c respCurTyp;
1934: resp_c respCurTyp;
1935:
1936: p_superiors WF_ROLE_HIERARCHY.RELTAB;
1937: p_subordinates WF_ROLE_HIERARCHY.RELTAB;
1938:
1939: l_g_role_name VARCHAR2(320);
1940: l_g_responsibility_id NUMBER;
1941: l_g_menu_id NUMBER;