eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_SALES_PUB dependencies on JTF_TERRITORY_PUB

Line 89: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,

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

Line 95: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,

91: p_Role IN varchar2,
92: x_return_status OUT NOCOPY varchar2,
93: x_msg_count OUT NOCOPY number,
94: X_msg_data OUT NOCOPY varchar2,
95: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
96: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_num_winners IN NUMBER := FND_API.G_MISS_NUM
98: )
99: AS

Line 158: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,

154: -- end of comments
155: procedure Get_WinningTerrMembers
156: ( p_api_version_number IN number,
157: p_init_msg_list IN varchar2 := fnd_api.g_false,
158: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,
159: p_Resource_Type IN varchar2,
160: p_Role IN varchar2,
161: x_return_status OUT NOCOPY varchar2,
162: x_msg_count OUT NOCOPY number,

Line 164: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE

160: p_Role IN varchar2,
161: x_return_status OUT NOCOPY varchar2,
162: x_msg_count OUT NOCOPY number,
163: X_msg_data OUT NOCOPY varchar2,
164: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
165: )
166: AS
167: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerrMembers_Oppor';
168: l_api_version_number CONSTANT NUMBER := 1.0;

Line 228: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,

224: -- end of comments
225: procedure Get_WinningTerrMembers
226: ( p_api_version_number IN number,
227: p_init_msg_list IN varchar2 := fnd_api.g_false,
228: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
229: p_Resource_Type IN varchar2,
230: p_Role IN varchar2,
231: x_return_status OUT NOCOPY varchar2,
232: x_msg_count OUT NOCOPY number,

Line 234: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE

230: p_Role IN varchar2,
231: x_return_status OUT NOCOPY varchar2,
232: x_msg_count OUT NOCOPY number,
233: X_msg_data OUT NOCOPY varchar2,
234: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
235: )
236: AS
237: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerrMembers_Lead';
238: l_api_version_number CONSTANT NUMBER := 1.0;

Line 432: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,

428: -- end of comments
429: procedure Get_WinningTerrMembers
430: ( p_api_version_number IN number,
431: p_init_msg_list IN varchar2 := fnd_api.g_false,
432: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,
433: p_Resource_Type IN varchar2,
434: p_Role IN varchar2,
435: x_return_status OUT NOCOPY varchar2,
436: x_msg_count OUT NOCOPY number,

Line 438: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

434: p_Role IN varchar2,
435: x_return_status OUT NOCOPY varchar2,
436: x_msg_count OUT NOCOPY number,
437: X_msg_data OUT NOCOPY varchar2,
438: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
439: ) AS
440:
441: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
442: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

Line 441: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;

437: X_msg_data OUT NOCOPY varchar2,
438: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
439: ) AS
440:
441: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
442: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
443: l_RscCounter NUMBER := 0;
444: l_counter NUMBER := 0;
445:

Line 442: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

438: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
439: ) AS
440:
441: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
442: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
443: l_RscCounter NUMBER := 0;
444: l_counter NUMBER := 0;
445:
446: BEGIN

Line 544: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type

540: p_init_msg_list IN varchar2 := fnd_api.g_false,
541: x_return_status OUT NOCOPY varchar2,
542: x_msg_count OUT NOCOPY number,
543: X_msg_data OUT NOCOPY varchar2,
544: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type
545: )AS
546:
547: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
548: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

Line 547: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;

543: X_msg_data OUT NOCOPY varchar2,
544: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type
545: )AS
546:
547: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
548: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
549:
550: l_RscCounter NUMBER := 0;
551:

Line 548: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

544: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type
545: )AS
546:
547: p_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
548: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
549:
550: l_RscCounter NUMBER := 0;
551:
552: BEGIN

Line 631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,

627: p_init_msg_list IN varchar2 := fnd_api.g_false,
628: x_return_status OUT NOCOPY varchar2,
629: x_msg_count OUT NOCOPY number,
630: X_msg_data OUT NOCOPY varchar2,
631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,

628: x_return_status OUT NOCOPY varchar2,
629: x_msg_count OUT NOCOPY number,
630: X_msg_data OUT NOCOPY varchar2,
631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
636: )

Line 650: l_Terr_Record JTF_TERRITORY_PUB.WinningTerr_Rec_type;

646: l_RetCode BOOLEAN;
647: l_Num_Of_Winners NUMBER;
648: l_Profile_Value VARCHAR2(25);
649: l_NoOfWinTerr NUMBER;
650: l_Terr_Record JTF_TERRITORY_PUB.WinningTerr_Rec_type;
651:
652: l_two_levels VARCHAR2(10) := 'TRUE';
653: l_count NUMBER := 1;
654: l_count1 NUMBER := 0;

Line 665: lp_Acc_Rec JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type;

661: */
662:
663:
664: /* 2167091 bug fix: JDOCHERT: 01/17/02 */
665: lp_Acc_Rec JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type;
666:
667: BEGIN
668: -- Standard call to check for call compatibility.
669: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 839: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,

835: -- end of comments
836: procedure Get_WinningTerrMembers
837: ( p_api_version_number IN number,
838: p_init_msg_list IN varchar2 := fnd_api.g_false,
839: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,
840: p_Resource_Type IN varchar2,
841: p_Role IN varchar2,
842: x_return_status OUT NOCOPY varchar2,
843: x_msg_count OUT NOCOPY number,

Line 845: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

841: p_Role IN varchar2,
842: x_return_status OUT NOCOPY varchar2,
843: x_msg_count OUT NOCOPY number,
844: X_msg_data OUT NOCOPY varchar2,
845: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
846: ) AS
847:
848: p_Rec JTF_TERRITORY_PUB.JTF_Oppor_bulk_rec_type;
849: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

Line 848: p_Rec JTF_TERRITORY_PUB.JTF_Oppor_bulk_rec_type;

844: X_msg_data OUT NOCOPY varchar2,
845: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
846: ) AS
847:
848: p_Rec JTF_TERRITORY_PUB.JTF_Oppor_bulk_rec_type;
849: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
850: l_RscCounter NUMBER := 0;
851: l_counter NUMBER := 0;
852:

Line 849: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

845: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
846: ) AS
847:
848: p_Rec JTF_TERRITORY_PUB.JTF_Oppor_bulk_rec_type;
849: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
850: l_RscCounter NUMBER := 0;
851: l_counter NUMBER := 0;
852:
853: BEGIN

Line 970: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,

966: -- end of comments
967: procedure Get_WinningTerrMembers
968: ( p_api_version_number IN number,
969: p_init_msg_list IN varchar2 := fnd_api.g_false,
970: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,
971: p_Resource_Type IN varchar2,
972: p_Role IN varchar2,
973: x_return_status OUT NOCOPY varchar2,
974: x_msg_count OUT NOCOPY number,

Line 976: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type

972: p_Role IN varchar2,
973: x_return_status OUT NOCOPY varchar2,
974: x_msg_count OUT NOCOPY number,
975: X_msg_data OUT NOCOPY varchar2,
976: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
977: ) AS
978:
979: p_Rec JTF_TERRITORY_PUB.JTF_Lead_bulk_rec_type;
980: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

Line 979: p_Rec JTF_TERRITORY_PUB.JTF_Lead_bulk_rec_type;

975: X_msg_data OUT NOCOPY varchar2,
976: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
977: ) AS
978:
979: p_Rec JTF_TERRITORY_PUB.JTF_Lead_bulk_rec_type;
980: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
981: l_RscCounter NUMBER := 0;
982: l_counter NUMBER := 0;
983:

Line 980: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;

976: x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
977: ) AS
978:
979: p_Rec JTF_TERRITORY_PUB.JTF_Lead_bulk_rec_type;
980: x_rec JTF_TERRITORY_PUB.Winning_bulk_rec_type;
981: l_RscCounter NUMBER := 0;
982: l_counter NUMBER := 0;
983:
984: BEGIN