[Home] [Help]
PACKAGE: APPS.ASO_SALES_TEAM_PVT
Source
1 PACKAGE ASO_SALES_TEAM_PVT AUTHID CURRENT_USER as
2 /* $Header: asovasts.pls 120.4 2011/05/11 09:41:09 vidsrini ship $ */
3 -- Start of Comments
4 -- Package name : ASO_SALES_TEAM_PVT
5 -- Purpose :
6 --
7 -- History :
8 -- NOTE :
9 --
10 -- End of Comments
11 --
12
13 PROCEDURE Assign_Sales_Team(
14 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
17 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
18 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
19 P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
20 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
23 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 );
25
26
27 PROCEDURE Get_Sales_Team(
28 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
30 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
31 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
32 --X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
33 X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
34 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
35 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
36 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 );
38
39
40 PROCEDURE Update_Primary_SalesInfo(
41 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
43 P_Primary_SalesAgent IN NUMBER,
44 P_Primary_SalesGrp IN NUMBER,
45 P_Reassign_Flag IN VARCHAR2,
46 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
47 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
48 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
49 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 );
51
52
53 PROCEDURE Opp_Quote_Primary_SalesRep(
54 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
55 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
56 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
57 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
59 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 );
61
62 PROCEDURE EXPLODE_GROUPS_ACCOUNTS(
63 x_errbuf OUT NOCOPY VARCHAR2,
64 x_retcode OUT NOCOPY VARCHAR2,
65 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE EXPLODE_TEAMS(
70 x_errbuf OUT NOCOPY VARCHAR2,
71 x_retcode OUT NOCOPY VARCHAR2,
72 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
73 x_return_status OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE INSERT_ACCESSES_ACCOUNTS(
77 x_errbuf OUT NOCOPY VARCHAR2,
78 x_retcode OUT NOCOPY VARCHAR2,
79 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
80 p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
81 x_return_status OUT NOCOPY VARCHAR2
82 );
83
84 End ASO_SALES_TEAM_PVT;