DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_PUB

Line 19: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

15:
16: PROCEDURE INSERT_ACCESSES_ACCOUNTS(
17: x_errbuf OUT NOCOPY VARCHAR2,
18: x_retcode OUT NOCOPY VARCHAR2,
19: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
20: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2) IS
22: BEGIN
23:

Line 296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

292:
293: PROCEDURE Assign_Sales_Team(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

293: PROCEDURE Assign_Sales_Team(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
301: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
301: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
302: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
301: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
302: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
303: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: )

Line 356: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

352: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'ASSIGN_SALES_TEAM';
353: l_api_version_number CONSTANT NUMBER := 1.0;
354: l_exists_flag VARCHAR2(1);
355: l_last_upd_date DATE;
356: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
357: l_reassign_flag VARCHAR2(1) := 'N';
358: l_creator_res NUMBER := NULL;
359: l_creator_found VARCHAR2(1);
360: l_creator_role NUMBER;

Line 1503: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1499: -- Commenting the whole procedure as the realtime call has changed.
1500: /*
1501: PROCEDURE Get_Sales_Team(
1502: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1503: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1504: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1505: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1506: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1507: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1504: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

1500: /*
1501: PROCEDURE Get_Sales_Team(
1502: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1503: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1504: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1505: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1506: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1507: X_Return_Status OUT NOCOPY VARCHAR2,
1508: X_Msg_Count OUT NOCOPY NUMBER,

Line 1505: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

1501: PROCEDURE Get_Sales_Team(
1502: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1503: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1504: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1505: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1506: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1507: X_Return_Status OUT NOCOPY VARCHAR2,
1508: X_Msg_Count OUT NOCOPY NUMBER,
1509: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1847: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1843: END EXPLODE_GROUPS_ACCOUNTS;
1844:
1845: PROCEDURE Get_Sales_Team(
1846: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1847: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1848: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1849: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1850: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1851: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

1844:
1845: PROCEDURE Get_Sales_Team(
1846: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1847: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1848: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1849: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1850: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1851: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1852: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1994: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

1990:
1991:
1992: PROCEDURE Update_Primary_SalesInfo(
1993: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1994: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1995: P_Primary_SalesAgent IN NUMBER,
1996: P_Primary_SalesGrp IN NUMBER,
1997: P_Reassign_Flag IN VARCHAR2,
1998: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

1994: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1995: P_Primary_SalesAgent IN NUMBER,
1996: P_Primary_SalesGrp IN NUMBER,
1997: P_Reassign_Flag IN VARCHAR2,
1998: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1999: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2000: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2001: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2002: )

Line 2383: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

2379:
2380:
2381: PROCEDURE Opp_Quote_Primary_SalesRep(
2382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2383: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2384: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2385: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2386: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2387: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

2380:
2381: PROCEDURE Opp_Quote_Primary_SalesRep(
2382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2383: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2384: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2385: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2386: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2387: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2388: )