PACKAGE: APPS.ZPB_USER_UPDATE

Source

1 PACKAGE ZPB_USER_UPDATE AS
2 /* $Header: zpbusersynch.pls 120.0.12010.2 2005/12/23 10:28:50 appldev noship $ */
3 
4   MODULE_NAME      CONSTANT VARCHAR2 (17):= 'ZPB_USER_UPDATE';
5   ANALYST          CONSTANT VARCHAR2(16):= 'ZPB_ANALYST_RESP';
6   MANAGER          CONSTANT VARCHAR2(16):= 'ZPB_MANAGER_RESP';
7   CONTROLLER       CONSTANT VARCHAR2(19):= 'ZPB_CONTROLLER_RESP';
8   SCHEMA_ADMIN     CONSTANT VARCHAR2(21):= 'ZPB_SCHEMA_ADMIN_RESP';
9   BIBEANS          CONSTANT VARCHAR2(7):= 'BIBEANS';
10   ZPBUSER          CONSTANT VARCHAR2(4):= 'APPS';
11   CURRENT_USER     CONSTANT number := 0;
12   NEW_USER         CONSTANT number := 1;
13   EXP_USER         CONSTANT number := -1;
14   ADD_ROLE         CONSTANT NUMBER:= 10;
15   RMV_ROLE         CONSTANT NUMBER:= -10;
16   HIDE_ACCOUNT     CONSTANT NUMBER:= -100;
17 
18   PROCEDURE synch_users(p_business_area_id NUMBER);
19 
20   procedure init_user_session (p_user_id in number,
21                                p_resp_id in number,
22                                p_business_area_id in number);
23 
24   --
25   -- Procedure that will insert rows into ZPB_USERS for any security
26   -- administrators who have access to a business area.  Called from
27   -- the business area user's screen
28   --
29   procedure synch_security_users (p_business_area_id in number);
30 
31   procedure update_admin_entries (p_business_area_id in number);
32 
33 END ZPB_USER_UPDATE;