DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_PUB

Line 16: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 17: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

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,

Line 18: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

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,

Line 20: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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: );

Line 29: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 30: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

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,

Line 31: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

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,

Line 42: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 46: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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: );

Line 55: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 56: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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: );

Line 79: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

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: