DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_PUB

Line 20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

16:
17: PROCEDURE Assign_Sales_Team(
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

17: PROCEDURE Assign_Sales_Team(
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
27: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: )

Line 80: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

76: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'ASSIGN_SALES_TEAM';
77: l_api_version_number CONSTANT NUMBER := 1.0;
78: l_exists_flag VARCHAR2(1);
79: l_last_upd_date DATE;
80: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_reassign_flag VARCHAR2(1) := 'N';
82: l_creator_res NUMBER := NULL;
83: l_creator_found VARCHAR2(1);
84: l_creator_role NUMBER;

Line 1209: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1205: -- Commenting the whole procedure as the realtime call has changed.
1206: /*
1207: PROCEDURE Get_Sales_Team(
1208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1209: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1210: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1211: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1212: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1213: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1210: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

1206: /*
1207: PROCEDURE Get_Sales_Team(
1208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1209: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1210: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1211: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1212: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1213: X_Return_Status OUT NOCOPY VARCHAR2,
1214: X_Msg_Count OUT NOCOPY NUMBER,

Line 1211: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

1207: PROCEDURE Get_Sales_Team(
1208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1209: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1210: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1211: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1212: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1213: X_Return_Status OUT NOCOPY VARCHAR2,
1214: X_Msg_Count OUT NOCOPY NUMBER,
1215: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1437: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1433: -- This procedure is changed to call the new JTF Terr Assignment API.
1434:
1435: PROCEDURE Get_Sales_Team(
1436: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1437: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1438: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1439: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1440: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1441: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1438: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

1434:
1435: PROCEDURE Get_Sales_Team(
1436: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1437: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1438: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1439: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1440: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1441: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1442: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1555: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1551:
1552:
1553: PROCEDURE Update_Primary_SalesInfo(
1554: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1555: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1556: P_Primary_SalesAgent IN NUMBER,
1557: P_Primary_SalesGrp IN NUMBER,
1558: P_Reassign_Flag IN VARCHAR2,
1559: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

1555: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1556: P_Primary_SalesAgent IN NUMBER,
1557: P_Primary_SalesGrp IN NUMBER,
1558: P_Reassign_Flag IN VARCHAR2,
1559: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1560: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1561: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1562: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1563: )

Line 1944: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1940:
1941:
1942: PROCEDURE Opp_Quote_Primary_SalesRep(
1943: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1944: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1945: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1946: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1947: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1948: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

1941:
1942: PROCEDURE Opp_Quote_Primary_SalesRep(
1943: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1944: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1945: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1946: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1947: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1948: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1949: )