DBA Data[Home] [Help]

APPS.ZPB_AW_WRITE_BACK dependencies on FND_USER

Line 18: select USER_ID into l_user_id from FND_USER where USER_NAME = p_user_name;

14: is
15: l_msg_count NUMBER;
16: l_user_id NUMBER;
17: begin
18: select USER_ID into l_user_id from FND_USER where USER_NAME = p_user_name;
19:
20: ZPB_AW.INITIALIZE (p_api_version => 1.0,
21: p_init_msg_list => FND_API.G_TRUE,
22: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 116: zpb_user FND_USER.USER_NAME%type;

112: IS
113: req_id NUMBER;
114: req_nm ZPB_REQUESTS.req_name%type;
115: resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%type;
116: zpb_user FND_USER.USER_NAME%type;
117: stmt_ln NUMBER;
118: cmd_str VARCHAR2(32767);
119: spl_stmt ZPB_WRITEBACK_TRANSACTION.QDR%type;
120: str_ptr NUMBER;

Line 140: from FND_USER

136: FROM FND_RESPONSIBILITY_VL
137: WHERE responsibility_id = P_RESP_ID;
138:
139: SELECT distinct(user_name) into zpb_user
140: from FND_USER
141: where user_id = P_USER_ID;
142:
143: select req_name
144: into req_nm

Line 756: l_user_name FND_USER.USER_NAME%type;

752: RETCODE OUT NOCOPY VARCHAR2,
753: P_BUSINESS_AREA IN NUMBER )
754: is
755: l_query_path VARCHAR2(255);
756: l_user_name FND_USER.USER_NAME%type;
757: l_retcode VARCHAR2(2);
758:
759: -- filter out bad queries that are in the ZPB_VALIDATION_TEMP_DATA table.
760: -- This goes for all cursors.

Line 798: from FND_USER

794:
795: begin
796: select USER_NAME
797: into l_user_name
798: from FND_USER
799: where USER_ID = FND_GLOBAL.USER_ID;
800:
801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');
802: