DBA Data[Home] [Help]

APPS.JTF_TERR_SALES_PUB dependencies on JTF_TERRITORY_PUB

Line 54: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,

50: -- end of comments
51: procedure Get_WinningTerrMembers
52: ( p_api_version_number IN number,
53: p_init_msg_list IN varchar2 := fnd_api.g_false,
54: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,
55: p_Resource_Type IN varchar2,
56: p_Role IN varchar2,
57: x_return_status OUT NOCOPY varchar2,
58: x_msg_count OUT NOCOPY number,

Line 60: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

56: p_Role IN varchar2,
57: x_return_status OUT NOCOPY varchar2,
58: x_msg_count OUT NOCOPY number,
59: X_msg_data OUT NOCOPY varchar2,
60: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
61: );
62:
63:
64: -- ***************************************************

Line 86: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,

82: -- end of comments
83: procedure Get_WinningTerrMembers
84: ( p_api_version_number IN number,
85: p_init_msg_list IN varchar2 := fnd_api.g_false,
86: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
87: p_Resource_Type IN varchar2,
88: p_Role IN varchar2,
89: x_return_status OUT NOCOPY varchar2,
90: x_msg_count OUT NOCOPY number,

Line 92: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,

88: p_Role IN varchar2,
89: x_return_status OUT NOCOPY varchar2,
90: x_msg_count OUT NOCOPY number,
91: X_msg_data OUT NOCOPY varchar2,
92: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
93: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_num_winners IN NUMBER := FND_API.G_MISS_NUM
95: );
96:

Line 123: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type

119: p_init_msg_list IN varchar2 := fnd_api.g_false,
120: x_return_status OUT NOCOPY varchar2,
121: x_msg_count OUT NOCOPY number,
122: X_msg_data OUT NOCOPY varchar2,
123: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type
124: );
125:
126: --
127: -- Start of Comments

Line 153: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,

149: p_init_msg_list IN varchar2 := fnd_api.g_false,
150: x_return_status OUT NOCOPY varchar2,
151: x_msg_count OUT NOCOPY number,
152: X_msg_data OUT NOCOPY varchar2,
153: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
154: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
155: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
157: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 154: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,

150: x_return_status OUT NOCOPY varchar2,
151: x_msg_count OUT NOCOPY number,
152: X_msg_data OUT NOCOPY varchar2,
153: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
154: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
155: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
157: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
158: );

Line 187: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,

183: -- end of comments
184: procedure Get_WinningTerrMembers
185: ( p_api_version_number IN number,
186: p_init_msg_list IN varchar2 := fnd_api.g_false,
187: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,
188: p_Resource_Type IN varchar2,
189: p_Role IN varchar2,
190: x_return_status OUT NOCOPY varchar2,
191: x_msg_count OUT NOCOPY number,

Line 193: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

189: p_Role IN varchar2,
190: x_return_status OUT NOCOPY varchar2,
191: x_msg_count OUT NOCOPY number,
192: X_msg_data OUT NOCOPY varchar2,
193: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
194: ) ;
195:
196: -- ***************************************************
197: -- start of comments

Line 218: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,

214: -- end of comments
215: procedure Get_WinningTerrMembers
216: ( p_api_version_number IN number,
217: p_init_msg_list IN varchar2 := fnd_api.g_false,
218: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,
219: p_Resource_Type IN varchar2,
220: p_Role IN varchar2,
221: x_return_status OUT NOCOPY varchar2,
222: x_msg_count OUT NOCOPY number,

Line 224: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE

220: p_Role IN varchar2,
221: x_return_status OUT NOCOPY varchar2,
222: x_msg_count OUT NOCOPY number,
223: X_msg_data OUT NOCOPY varchar2,
224: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
225: );
226:
227:
228: /*========================================================================================*/

Line 255: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,

251: -- end of comments
252: procedure Get_WinningTerrMembers
253: ( p_api_version_number IN number,
254: p_init_msg_list IN varchar2 := fnd_api.g_false,
255: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,
256: p_Resource_Type IN varchar2,
257: p_Role IN varchar2,
258: x_return_status OUT NOCOPY varchar2,
259: x_msg_count OUT NOCOPY number,

Line 261: x_TerrResource_tbl out NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

257: p_Role IN varchar2,
258: x_return_status OUT NOCOPY varchar2,
259: x_msg_count OUT NOCOPY number,
260: X_msg_data OUT NOCOPY varchar2,
261: x_TerrResource_tbl out NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
262: );
263:
264: -- ***************************************************
265: -- start of comments

Line 286: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,

282: -- end of comments
283: procedure Get_WinningTerrMembers
284: ( p_api_version_number IN number,
285: p_init_msg_list IN varchar2 := fnd_api.g_false,
286: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
287: p_Resource_Type IN varchar2,
288: p_Role IN varchar2,
289: x_return_status OUT NOCOPY varchar2,
290: x_msg_count OUT NOCOPY number,

Line 292: x_winners_rec out NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE

288: p_Role IN varchar2,
289: x_return_status OUT NOCOPY varchar2,
290: x_msg_count OUT NOCOPY number,
291: X_msg_data OUT NOCOPY varchar2,
292: x_winners_rec out NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
293: );
294:
295:
296: