PACKAGE: APPS.CSM_USER_EVENT_PKG

Source

1 PACKAGE CSM_USER_EVENT_PKG   AS
2 /* $Header: csmeusrs.pls 120.6.12010000.1 2008/07/28 16:15:05 appldev ship $ */
3 
4 -- Generated 6/13/2002 8:01:57 PM from [email protected]
5 
6 --
7 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
8 -- directory of SQL Navigator
9 --
10 -- Purpose: Briefly explain the functionality of the package
11 --
12 -- MODIFICATION HISTORY
13 -- Person      Date       Comments
14 -- saradhak   6-Dec-2005  added spawn_perz_ins and spawn_dashboard_srch_cols_ins
15 -- ---------   ------     ------------------------------------------
16    -- Enter package declarations as shown below
17 
18 FUNCTION is_omfs_palm_responsibility(p_responsibility_id IN NUMBER, p_user_id IN NUMBER) RETURN BOOLEAN;
19 
20 PROCEDURE disable_user_pub_synch(p_user_id IN NUMBER);
21 
22 FUNCTION is_first_omfs_palm_user(p_user_id IN NUMBER) RETURN BOOLEAN;
23 
24 PROCEDURE user_resp_ins_initializer (p_responsibility_id IN NUMBER, p_user_id IN NUMBER);
25 
26 PROCEDURE spawn_task_ins(p_user_id IN NUMBER);
27 
28 PROCEDURE spawn_incident_ins(p_user_id IN NUMBER);
29 
30 PROCEDURE spawn_task_assignment_ins(p_user_id IN NUMBER);
31 
32 PROCEDURE spawn_perz_ins(p_user_id IN NUMBER);
33 
34 PROCEDURE spawn_dashboard_srch_cols_ins(p_user_id IN NUMBER);
35 
36 PROCEDURE items_acc_processor(p_user_id IN NUMBER);
37 
38 PROCEDURE spawn_inv_loc_assignment_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER);
39 
40 PROCEDURE spawn_po_loc_ass_all_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER);
41 
42 PROCEDURE spawn_csp_req_headers_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER);
43 
44 PROCEDURE spawn_csp_req_lines_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER);
45 
46 PROCEDURE enable_user_pub_synch(p_user_id IN NUMBER);
47 
48 PROCEDURE user_del_init(p_user_id IN NUMBER);
49 
50 PROCEDURE purge_all_acc_tables(p_user_id IN NUMBER);
51 
52 --Bug
53 PROCEDURE spawn_mat_txn(p_user_id IN NUMBER);
54 
55 PROCEDURE spawn_mtl_serial_Numbers(p_resource_id IN NUMBER,p_user_id IN NUMBER);
56 
57 --12.1
58 PROCEDURE INSERT_ACC (p_user_id IN NUMBER
59                                     ,x_return_status OUT NOCOPY VARCHAR2
60                                     , x_error_message OUT NOCOPY VARCHAR2);
61 
62 PROCEDURE DELETE_ACC (p_user_id IN NUMBER
63                                     ,x_return_status OUT NOCOPY VARCHAR2
64                                     , x_error_message OUT NOCOPY VARCHAR2);
65 
66 PROCEDURE INSERT_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER);
67 
68 PROCEDURE DELETE_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER);
69 
70 END; -- Package spec
71