PACKAGE: APPS.HZ_WF_SYNCH

Source

1 PACKAGE HZ_WF_SYNCH AUTHID CURRENT_USER AS
2 /* $Header: ARHWFSNS.pls 120.5 2005/10/06 21:33:58 smattegu noship $ */
3 
4    TYPE SYNC_REC_TYPE IS RECORD
5    (
6 	USER_NAME	 WF_LOCAL_USER_ROLES.USER_NAME%TYPE,
7 	DISPLAY_NAME      WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8 	DESCRIPTION       WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9 	NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10 	LANGUAGE          WF_LOCAL_ROLES.LANGUAGE%TYPE,
11 	TERRITORY         WF_LOCAL_ROLES.TERRITORY%TYPE,
12 	EMAIL_ADDRESS     WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13 	FAX               WF_LOCAL_ROLES.FAX%TYPE,
14 	STATUS            WF_LOCAL_ROLES.STATUS%TYPE,
15 	START_DATE        WF_LOCAL_ROLES.START_DATE%TYPE,
16 	EXPIRATION_DATE   WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17 	SYSTEM_ID         WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
18    );
19   TYPE SYNC_TBL_TYPE IS TABLE OF SYNC_REC_TYPE INDEX BY PLS_INTEGER;
20 
21 --------------------------------------
22 -- declaration of public procedures and functions
23 --------------------------------------
24 
25 /*===========================================================================+
26  | PROCEDURE
27  |              propogate_user_role
28  |
29  | DESCRIPTION
30  |              Propogates user information to WF tables
31  |
32  | SCOPE - Public
33  |
34  | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
35  |		WF_LOCAL_SYNCH
36  |
37  | ARGUMENTS  : IN:
38  |                 p_subscription_guid      in raw,
39  |
40  |              OUT:
41  |
42  |          IN/ OUT:
43  |                 p_event                  in out NOCOPY wf_event_t |
44  |
45  |
46  | RETURNS    : VARCHAR2
47  |
48  | NOTES
49  |
50  | MODIFICATION HISTORY
51  |
52  +===========================================================================*/
53 
54 FUNCTION propagate_user_role(
55               p_subscription_guid      in raw,
56               p_event                  in out NOCOPY wf_event_t)
57 return varchar2
58 ;
59 
60 
61 /*===========================================================================+
62  | PROCEDURE
63  |              propogate_role
64  |
65  | DESCRIPTION
66  |              Propogates user information to WF tables
67  |
68  | SCOPE - Public
69  |
70  | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
71  |		WF_LOCAL_SYNCH
72  |
73  | ARGUMENTS  : IN:
74  |                p_subscription_guid      in raw,
75  |
76  |              OUT:
77  |
78  |          IN/ OUT:
79  |                p_event                  in out NOCOPY wf_event_t
80  |
81  |
82  | RETURNS    : VARCHAR2
83  |
84  | NOTES
85  |
86  | MODIFICATION HISTORY
87  |
88  +===========================================================================*/
89 
90 FUNCTION propagate_role(
91              p_subscription_guid      in raw,
92              p_event                  in out NOCOPY wf_event_t)
93 return varchar2
94 ;
95 
96 
97 /*===========================================================================+
98  | The following procedures are covers that call the WF_LOCAL_SYNCH APIS.
99  +===========================================================================*/
100 
101 PROCEDURE SYNCHGROUPWFUSERROLE ( RelationshipId         IN Number        );
102 
103 PROCEDURE SYNCHPERSONWFROLE (
104         PartyId         IN Number,
105         p_update        IN Boolean Default False ,
106         p_overwrite     IN Boolean Default False );
107 
108 PROCEDURE SYNCHCONTACTWFROLE (
109         PartyId         IN Number,
110         p_update        IN Boolean Default False ,
111         p_overwrite     IN Boolean Default False );
112 
113 PROCEDURE SYNCHGROUPWFROLE (
114         PartyId         IN Number,
115         p_update        IN Boolean Default False ,
116         p_overwrite     IN Boolean Default False );
117 
118 
119 END HZ_WF_SYNCH;
120