67: PROCEDURE Get_WinningTerrMembers
68: (
69: p_api_version_number IN number,
70: p_init_msg_list IN varchar2 := fnd_api.g_false,
71: p_TerrDefMgmt_Rec IN JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type,
72: p_Resource_Type IN varchar2,
73: p_Role IN varchar2,
74: x_return_status OUT NOCOPY varchar2,
75: x_msg_count OUT NOCOPY number,
73: p_Role IN varchar2,
74: x_return_status OUT NOCOPY varchar2,
75: x_msg_count OUT NOCOPY number,
76: X_msg_data OUT NOCOPY varchar2,
77: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
78: )
79: AS
80:
81: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerrMembers';
85: l_RscCounter NUMBER := 0;
86: l_NumberOfWinners NUMBER;
87: l_RetCode BOOLEAN;
88:
89: lp_rec JTF_TERRITORY_PUB.jtf_bulk_trans_rec_type;
90: lx_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
91:
92: BEGIN
93: --dbms_output.put_line('Get_WinningTerrMembers: Entering the API');
86: l_NumberOfWinners NUMBER;
87: l_RetCode BOOLEAN;
88:
89: lp_rec JTF_TERRITORY_PUB.jtf_bulk_trans_rec_type;
90: lx_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
91:
92: BEGIN
93: --dbms_output.put_line('Get_WinningTerrMembers: Entering the API');
94: