1 package fnd_oid_subscriptions as
2 /* $Header: AFSCOSBS.pls 120.3 2005/07/19 19:21:24 scheruku noship $ */
3 --
4 /*****************************************************************************/
5 -- Start of Package Globals
6
7 -- End of Package Globals
8 --
9 --
10 /*
11 ** Name : entity_changes
12 ** Type : Public, FND Internal
13 ** Desc : This proc "queues" up the user change for OID. Also, detects
14 ** future dated changes and queues real events to pick them up when ready.
15 ** Pre-Reqs :
16 ** Parameters :
17 ** p_userguid -- User GUID as stored in OID.
18 **
19 ** Notes :
20 */
21 function identity_add(
22 p_subscription_guid in raw
23 , p_event in out nocopy wf_event_t)
24 return varchar2;
25 --
26 -------------------------------------------------------------------------------
27 function identity_modify(
28 p_subscription_guid in raw
29 , p_event in out nocopy wf_event_t)
30 return varchar2;
31 --
32 -------------------------------------------------------------------------------
33 function identity_delete(
34 p_subscription_guid in raw
35 , p_event in out nocopy wf_event_t)
36 return varchar2;
37 --
38 -------------------------------------------------------------------------------
39 function subscription_add(
40 p_subscription_guid in raw
41 , p_event in out nocopy wf_event_t)
42 return varchar2;
43 --
44 -------------------------------------------------------------------------------
45 function subscription_delete(
46 p_subscription_guid in raw
47 , p_event in out nocopy wf_event_t)
48 return varchar2;
49 --
50 -------------------------------------------------------------------------------
51 function on_demand_user_create(
52 p_subscription_guid in raw
53 , p_event in out nocopy wf_event_t)
54 return varchar2;
55 --
56 -------------------------------------------------------------------------------
57 function event_error(
58 p_subscription_guid in raw
59 , p_event in out nocopy wf_event_t)
60 return varchar2;
61 --
62 -------------------------------------------------------------------------------
63 function event_resend(
64 p_subscription_guid in raw
65 , p_event in out nocopy wf_event_t)
66 return varchar2;
67 --
68 -------------------------------------------------------------------------------
69 function hz_identity_add(
70 p_subscription_guid in raw
71 , p_event in out nocopy wf_event_t)
72 return varchar2;
73 --
74 -------------------------------------------------------------------------------
75 function hz_identity_modify(
76 p_subscription_guid in raw
77 , p_event in out nocopy wf_event_t)
78 return varchar2;
79 --
80 -------------------------------------------------------------------------------
81 function hz_identity_delete(
82 p_subscription_guid in raw
83 , p_event in out nocopy wf_event_t)
84 return varchar2;
85 --
86 -------------------------------------------------------------------------------
87 function hz_subscription_add(
88 p_subscription_guid in raw
89 , p_event in out nocopy wf_event_t)
90 return varchar2;
91 --
92 -------------------------------------------------------------------------------
93 function hz_subscription_delete(
94 p_subscription_guid in raw
95 , p_event in out nocopy wf_event_t)
96 return varchar2;
97 --
98 -------------------------------------------------------------------------------
99 function synch_oid_to_tca(
100 p_subscription_guid in raw
101 , p_event in out nocopy wf_event_t)
102 return varchar2;
103 --
104 -------------------------------------------------------------------------------
105 procedure assign_default_resp(p_user_name in varchar2);
106 --
107 -------------------------------------------------------------------------------
108 procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
109 , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
110 , x_application_id out nocopy fnd_responsibility.application_id%type);
111 --
112 -------------------------------------------------------------------------------
113 function assign_def_resp(
114 p_subscription_guid in raw
115 , p_event in out nocopy wf_event_t)
116 return varchar2;
117 ------------------------------------------------------------------------------
118 end fnd_oid_subscriptions;