DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on JTY_ASSIGN_REALTIME_PUB

Line 20: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

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:
24: aso_debug_pub.add('Begin INSERT_ACCESSES_ACCOUNTS',1,'Y');

Line 83: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

79: /************************** Start Explode Teams ******************/
80: PROCEDURE EXPLODE_TEAMS(
81: x_errbuf OUT NOCOPY VARCHAR2,
82: x_retcode OUT NOCOPY VARCHAR2,
83: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
84: x_return_status OUT NOCOPY VARCHAR2)
85: IS
86:
87: /*-------------------------------------------------------------------------+

Line 313: lx_gen_return_Rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;

309: -- Changes Done by : Girish
310: -- Comments : Call from release 12 has changed and also the record type
311:
312: --lx_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
313: lx_gen_return_Rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
314:
315:
316: TYPE Keep_Res_Id_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
317:

Line 1731: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

1727: -- This procedure is changed to call the new JTF Terr Assignment API.
1728: PROCEDURE EXPLODE_GROUPS_ACCOUNTS(
1729: x_errbuf OUT NOCOPY VARCHAR2,
1730: x_retcode OUT NOCOPY VARCHAR2,
1731: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1732: x_return_status OUT NOCOPY VARCHAR2)
1733: IS
1734: -------------RS_GROUP---------
1735: /*-------------------------------------------------------------------------+

Line 1849: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

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

Line 1858: lp_bulk_trans_id JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;

1854: IS
1855: l_errbuf VARCHAR2(4000);
1856: l_retcode VARCHAR2(255);
1857: l_return_status VARCHAR2(30);
1858: lp_bulk_trans_id JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
1859: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Sales_Team';
1860:
1861: BEGIN
1862:

Line 1880: aso_debug_pub.add('Before Calling JTY_ASSIGN_REALTIME_PUB.get_winners',1,'Y');

1876: aso_debug_pub.add('Get_Sales_Team: P_Qte_Header_Rec.quote_header_id: '||P_qte_header_rec.quote_header_id,1,'N');
1877: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.party_id: '||P_qte_header_rec.party_id,1,'N');
1878: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.cust_party_id: '||P_qte_header_rec.cust_party_id,1,'N');
1879: aso_debug_pub.add('Get_Sales_Team: P_qte_header_rec.sold_to_party_site_id: '||P_qte_header_rec.sold_to_party_site_id,1,'N');
1880: aso_debug_pub.add('Before Calling JTY_ASSIGN_REALTIME_PUB.get_winners',1,'Y');
1881: aso_utility_pvt.print_login_info();
1882: END IF;
1883:
1884: -- Call the new JTF Terr Assignment API

Line 1885: JTY_ASSIGN_REALTIME_PUB.get_winners (

1881: aso_utility_pvt.print_login_info();
1882: END IF;
1883:
1884: -- Call the new JTF Terr Assignment API
1885: JTY_ASSIGN_REALTIME_PUB.get_winners (
1886: P_api_version_number => 1.0,
1887: P_init_msg_list => FND_API.G_FALSE,
1888: P_source_id => -1001 , /* Oracle Sales and Telesales */
1889: P_trans_id => -1105 , /* Quoting */