1 PACKAGE AS_RTTAP_ACCOUNT AS
2 /* $Header: asxrtacs.pls 120.2 2005/08/21 09:02:04 subabu noship $ */
3
4 FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
5 FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
6 FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
7 FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
8 FUNCTION CREATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
9 FUNCTION UPDATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
10 FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
11 FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
12 FUNCTION UPDATE_LOCATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2;
13
14 PROCEDURE PROCESS_RTTAP_ACCOUNT(
15 p_party_Id NUMBER,
16 p_return_status OUT NOCOPY VARCHAR2);
17
18 PROCEDURE RTTAP_WRAPPER(
19 p_party_id IN NUMBER,
20 X_Return_Status OUT NOCOPY VARCHAR2 );
21
22 PROCEDURE EXPLODE_TEAMS_ACCOUNTS(
23 x_errbuf OUT NOCOPY VARCHAR2,
24 x_retcode OUT NOCOPY VARCHAR2,
25 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
26 x_return_status OUT NOCOPY VARCHAR2);
27
28 PROCEDURE EXPLODE_GROUPS_ACCOUNTS(
29 x_errbuf OUT NOCOPY VARCHAR2,
30 x_retcode OUT NOCOPY VARCHAR2,
31 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
32 x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE SET_TEAM_LEAD_ACCOUNTS(
35 x_errbuf OUT NOCOPY VARCHAR2,
36 x_retcode OUT NOCOPY VARCHAR2,
37 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
38 x_return_status OUT NOCOPY VARCHAR2);
39
40 PROCEDURE INSERT_ACCESSES_ACCOUNTS(
41 x_errbuf OUT NOCOPY VARCHAR2,
42 x_retcode OUT NOCOPY VARCHAR2,
43 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE INSERT_TERR_ACCESSES_ACCOUNTS(
47 x_errbuf OUT NOCOPY VARCHAR2,
48 x_retcode OUT NOCOPY VARCHAR2,
49 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE PERFORM_ACCOUNT_CLEANUP(
53 x_errbuf OUT NOCOPY VARCHAR2,
54 x_retcode OUT NOCOPY VARCHAR2,
55 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
56 x_return_status OUT NOCOPY VARCHAR2);
57 END AS_RTTAP_ACCOUNT;