1 PACKAGE IEX_TERR_PUB AS
2 /* $Header: iexkters.pls 120.1.12000000.2 2007/04/26 09:16:17 gnramasa ship $ */
3
4 PG_DEBUG NUMBER;
5
6 FUNCTION party_check
7 ( p_subscription_guid in raw,
8 p_event in out NOCOPY wf_event_t) return varchar2;
9
10 FUNCTION partysite_check
11 ( p_subscription_guid in raw,
12 p_event in out NOCOPY wf_event_t) return varchar2;
13
14 FUNCTION partysiteuse_check
15 ( p_subscription_guid in raw,
16 p_event in out NOCOPY wf_event_t) return varchar2;
17
18 FUNCTION location_check
19 ( p_subscription_guid in raw,
20 p_event in out NOCOPY wf_event_t) return varchar2;
21
22 FUNCTION account_check
23 ( p_subscription_guid in raw,
24 p_event in out NOCOPY wf_event_t) return varchar2;
25
26 FUNCTION profile_check
27 ( p_subscription_guid in raw,
28 p_event in out NOCOPY wf_event_t) return varchar2;
29
30 FUNCTION accountsite_check
31 ( p_subscription_guid in raw,
32 p_event in out NOCOPY wf_event_t) return varchar2;
33
34 FUNCTION accountsiteuse_check
35 ( p_subscription_guid in raw,
36 p_event in out NOCOPY wf_event_t) return varchar2;
37
38 FUNCTION profileamt_check
39 ( p_subscription_guid in raw,
40 p_event in out NOCOPY wf_event_t)
41 return varchar2;
42
43 FUNCTION finprofile_check
44 ( p_subscription_guid in raw,
45 p_event in out NOCOPY wf_event_t) return varchar2;
46
47 PROCEDURE logMessage (p_text in varchar2);
48
49 --IEX Summary Table Synchronization Start.
50 FUNCTION SYNC_TCA_SUMMARY(
51 p_party_id in number default null,
52 p_account_id in number default null,
53 p_site_use_id in number default null,
54 p_collector_id in number default null,
55 p_level in varchar2
56 ) return varchar2;
57 --IEX Summary Table Synchronization End.
58
59
60 END; -- Package spec