DBA Data[Home] [Help]

PACKAGE: APPS.AS_RTTAP_OPPTY

Source


1 PACKAGE AS_RTTAP_OPPTY as
2 /* $Header: asxrtops.pls 120.3 2005/10/10 03:46:06 subabu noship $ */
3 -- Start of Comments
4 -- Package name     : AS_RTTAP_OPPTY
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 
11 
12 --   *******************************************************
13 --    Start of Comments
14 --   *******************************************************
15 --   API Name:  Opp_Terr_Assignment
16 --   Type    :  Private
17 --   Pre-Req :
18 --   Parameters:
19 --   IN:
20 --      p_api_version_number IN NUMBER   Required
21 --      p_init_msg_list      IN VARCHAR2 Optional Default = FND_API_G_FALSE
22 --      p_commit             IN VARCHAR2 Optional Default = FND_API.G_FALSE
23 --      p_validation_level   IN NUMBER   Optional Default =
24 --                                                   FND_API.G_VALID_LEVEL_FULL
25 --   OUT:
26 --      x_return_status      OUT  VARCHAR2
27 --      x_msg_count          OUT  NUMBER
28 --      x_msg_data           OUT  VARCHAR2
29 --   Version : Current version 2.0
30 --
31 --   End of Comments
32 
33 
34 
35 PROCEDURE RTTAP_WRAPPER(
36     P_Api_Version_Number         IN  NUMBER,
37     P_Init_Msg_List              IN  VARCHAR2    := FND_API.G_FALSE,
38     P_Commit                     IN  VARCHAR2    := FND_API.G_FALSE,
39     p_LEAD_ID			 IN  NUMBER,
40     X_Return_Status              OUT NOCOPY  VARCHAR2,
41     X_Msg_Count                  OUT NOCOPY  NUMBER,
42     X_Msg_Data                   OUT NOCOPY  VARCHAR2
43     );
44 
45 PROCEDURE EXPLODE_TEAMS_OPPTYS(
46     x_errbuf           OUT NOCOPY VARCHAR2,
47     x_retcode          OUT NOCOPY VARCHAR2,
48     p_WinningTerrMember_tbl     IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
49     x_return_status    OUT NOCOPY VARCHAR2);
50 PROCEDURE EXPLODE_GROUPS_OPPTYS(
51     x_errbuf           OUT NOCOPY VARCHAR2,
52     x_retcode          OUT NOCOPY VARCHAR2,
53     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
54     x_return_status    OUT NOCOPY VARCHAR2);
55 PROCEDURE SET_TEAM_LEAD_OPPTYS(
56     x_errbuf           OUT NOCOPY VARCHAR2,
57     x_retcode          OUT NOCOPY VARCHAR2,
58     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
59     x_return_status    OUT NOCOPY VARCHAR2 );
60 PROCEDURE INSERT_ACCESSES_OPPTYS(
61     x_errbuf           OUT NOCOPY VARCHAR2,
62     x_retcode          OUT NOCOPY VARCHAR2,
63     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
64     x_return_status    OUT NOCOPY VARCHAR2);
65 PROCEDURE INSERT_TERR_ACCESSES_OPPTYS(
66     x_errbuf           OUT NOCOPY VARCHAR2,
67     x_retcode          OUT NOCOPY VARCHAR2,
68     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
69     x_return_status    OUT NOCOPY VARCHAR2);
70 PROCEDURE PERFORM_OPPTY_CLEANUP(
71     x_errbuf           OUT NOCOPY VARCHAR2,
72     x_retcode          OUT NOCOPY VARCHAR2,
73     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
74     x_return_status    OUT NOCOPY VARCHAR2);
75 PROCEDURE ASSIGN_OPPTY_OWNER(
76     x_errbuf           OUT NOCOPY VARCHAR2,
77     x_retcode          OUT NOCOPY VARCHAR2,
78     p_WinningTerrMember_tbl     IN OUT NOCOPY  JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
79     x_return_status    OUT NOCOPY VARCHAR2);
80 PROCEDURE RAISE_BUSINESS_EVENT(
81     x_errbuf        OUT NOCOPY VARCHAR2,
82     x_retcode       OUT NOCOPY VARCHAR2,
83     x_return_status OUT NOCOPY VARCHAR2);
84 END AS_RTTAP_OPPTY;
85