APPS.ZPB_BUSAREA_VAL dependencies on FND_USER

Line 48: p_userid IN FND_USER.USER_ID%type,

44: -- p_statusSqlId -- Status sql id from query
45: */
46: ------------------------------------------------------------------------------
47: PROCEDURE LOCK_OUT_USER(p_baId IN NUMBER,
48: p_userid IN FND_USER.USER_ID%type,
49: p_queryName IN VARCHAR2,
50: p_queryPath IN ZPB_STATUS_SQL.QUERY_PATH%type,
51: p_queryType IN VARCHAR2,
52: p_queryErrorType IN VARCHAR2,

Line 957: FND_USER_RESP_GROUPS B,

953: -------------------------------------------------------------------------
954: select count(*)
955: into l_count
956: from ZPB_BUSAREA_USERS A,
957: FND_USER_RESP_GROUPS B,
958: FND_RESPONSIBILITY C,
959: FND_USER D
960: where A.BUSINESS_AREA_ID = l_ba_id
961: and A.USER_ID = B.USER_ID

Line 959: FND_USER D

955: into l_count
956: from ZPB_BUSAREA_USERS A,
957: FND_USER_RESP_GROUPS B,
958: FND_RESPONSIBILITY C,
959: FND_USER D
960: where A.BUSINESS_AREA_ID = l_ba_id
961: and A.USER_ID = B.USER_ID
962: and B.RESPONSIBILITY_APPLICATION_ID = 210
963: and nvl(B.END_DATE, sysdate) >= sysdate

Line 1834: l_user FND_USER.USER_NAME%type;

1830: l_str VARCHAR2(300);
1831: l_str2 VARCHAR2(256);
1832: l_num NUMBER;
1833: l_taskID NUMBER;
1834: l_user FND_USER.USER_NAME%type;
1835: l_user_id FND_USER.USER_ID%type;
1836: l_xml BISM_OBJECTS.XML%type;
1837: l_line_dim VARCHAR2(150);
1838: l_folder BISM_OBJECTS.FOLDER_ID%type;

Line 1835: l_user_id FND_USER.USER_ID%type;

1831: l_str2 VARCHAR2(256);
1832: l_num NUMBER;
1833: l_taskID NUMBER;
1834: l_user FND_USER.USER_NAME%type;
1835: l_user_id FND_USER.USER_ID%type;
1836: l_xml BISM_OBJECTS.XML%type;
1837: l_line_dim VARCHAR2(150);
1838: l_folder BISM_OBJECTS.FOLDER_ID%type;
1839: l_queryPath ZPB_STATUS_SQL.QUERY_PATH%type;

Line 2155: FROM FND_USER

2151: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2152:
2153: SELECT USER_NAME
2154: INTO l_user
2155: FROM FND_USER
2156: WHERE USER_ID = l_user_id;
2157:
2158: l_num := instr(l_xml, 'Description="')+13;
2159: l_str := substr(l_xml, l_num, instr(l_xml, '"', l_num)-l_num);

Line 2195: FROM FND_USER

2191: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2192:
2193: SELECT USER_NAME
2194: INTO l_user
2195: FROM FND_USER
2196: WHERE USER_ID = l_user_id;
2197:
2198:
2199: l_num := instr(l_xml, 'Description="')+13;

Line 2234: FROM FND_USER

2230: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2231:
2232: SELECT USER_NAME
2233: INTO l_user
2234: FROM FND_USER
2235: WHERE USER_ID = l_user_id;
2236:
2237: l_num := instr(l_xml, 'Description="')+13;
2238: l_str := substr(l_xml, l_num, instr(l_xml, '"', l_num)-l_num);

Line 2345: l_user FND_USER.USER_NAME%type;

2341: l_str VARCHAR2(300);
2342: l_str2 VARCHAR2(256);
2343: l_num NUMBER;
2344: l_taskID NUMBER;
2345: l_user FND_USER.USER_NAME%type;
2346: l_user_id FND_USER.USER_ID%type;
2347: l_xml BISM_OBJECTS.XML%type;
2348: l_line_dim VARCHAR2(150);
2349: l_line_dimID VARCHAR2(30);

Line 2346: l_user_id FND_USER.USER_ID%type;

2342: l_str2 VARCHAR2(256);
2343: l_num NUMBER;
2344: l_taskID NUMBER;
2345: l_user FND_USER.USER_NAME%type;
2346: l_user_id FND_USER.USER_ID%type;
2347: l_xml BISM_OBJECTS.XML%type;
2348: l_line_dim VARCHAR2(150);
2349: l_line_dimID VARCHAR2(30);
2350: l_folder BISM_OBJECTS.FOLDER_ID%type;

Line 2721: FROM FND_USER

2717: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2718:
2719: SELECT USER_NAME
2720: INTO l_user
2721: FROM FND_USER
2722: WHERE USER_ID = l_user_id;
2723:
2724: l_num := instr(l_xml, 'Description="')+13;
2725: l_str := substr(l_xml, l_num, instr(l_xml, '"', l_num)-l_num);

Line 2759: FROM FND_USER

2755: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2756:
2757: SELECT USER_NAME
2758: INTO l_user
2759: FROM FND_USER
2760: WHERE USER_ID = l_user_id;
2761:
2762: l_num := instr(l_xml, 'Description="')+13;
2763: l_str := substr(l_xml, l_num, instr(l_xml, '"', l_num)-l_num);

Line 2797: FROM FND_USER

2793: l_user_id := to_number(substr(l_str, 1, instr(l_str, '_')-1));
2794:
2795: SELECT USER_NAME
2796: INTO l_user
2797: FROM FND_USER
2798: WHERE USER_ID = l_user_id;
2799:
2800: l_num := instr(l_xml, 'Description="')+13;
2801: l_str := substr(l_xml, l_num, instr(l_xml, '"', l_num)-l_num);