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_LOOKUP_PUB dependencies on JTF_TERR_ASSIGN_PUB

Line 26: -- now calling JTF_TERR_ASSIGN_PUB

22: -- 01/26/01 JDOCHERT 1614487 bug fix
23: -- 03/21/01 EIHSU modified to handle output of win_rsc_tbl_rec from 1001_ACCT_DYN
24: -- 07/26/01 EIHSU modified all referenced charlist to 360list
25: -- 09/28/01 ARPATEL changing to generic table-of-records architecture
26: -- now calling JTF_TERR_ASSIGN_PUB
27: -- 10/10/01 ARPATEL added p_source_id and p_trans_id to get_Winners
28: -- 10/22/01 ARPATEL adding extra parameters to get_org_contacts
29: -- 10/25/01 EIHSU Get_Addn_Params added. This Procedure will serve
30: -- to fetch any additional information before assignment request made

Line 66: -- REQUIRES: llp_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type

62: -- pre-reqs : requires populated generic transaction type record
63: -- party_site_id or party_id instantiated
64: -- parameters :
65:
66: -- REQUIRES: llp_trans_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type
67: -- MODIFIES: modifies SQUAL elements
68: -- EFFECTS: sets additional qualifier values
69: --
70:

Line 76: llp_trans_rec IN OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type,

72:
73: procedure Get_Addn_Params
74: ( p_api_version_number IN number,
75: p_init_msg_list IN varchar2 := fnd_api.g_false,
76: llp_trans_rec IN OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type,
77: llp_source_id IN number,
78: llp_trans_id IN number,
79: x_return_status OUT NOCOPY varchar2
80: )

Line 383: --lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

379: lX_Msg_Data VARCHAR2(2000);
380:
381: --arpatel 09/28 now using generic bulk record types
382: --lp_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
383: --lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
384: lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
385:
386: --lx_rec JTF_TERRITORY_PUB.jtf_win_rsc_bulk_rec_type;
387: --lx_rec win_rsc_tbl_type;

Line 384: lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

380:
381: --arpatel 09/28 now using generic bulk record types
382: --lp_Rec JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type;
383: --lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
384: lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
385:
386: --lx_rec JTF_TERRITORY_PUB.jtf_win_rsc_bulk_rec_type;
387: --lx_rec win_rsc_tbl_type;
388: --lx_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

Line 388: --lx_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

384: lp_trans_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
385:
386: --lx_rec JTF_TERRITORY_PUB.jtf_win_rsc_bulk_rec_type;
387: --lx_rec win_rsc_tbl_type;
388: --lx_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
389: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
390:
391:
392: l_api_name CONSTANT VARCHAR2(30) := 'Get_Winners';

Line 700: JTF_TERR_ASSIGN_PUB.get_winners

696:
697: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Call assign API ');
698: --------arpatel 09/28 Now Calling Generic Assign package----------
699: /*
700: JTF_TERR_ASSIGN_PUB.get_winners
701: ( p_api_version_number => p_api_version_number,
702: p_init_msg_list => p_init_msg_list,
703: p_use_type => 'LOOKUP',
704: p_source_id => p_source_id, -- -1001 Oracle Sales

Line 719: -- Please not that the code has been derived from JTF_TERR_ASSIGN_PUB.get_winners

715: );
716: */ -- Code commented for bug# 7237992
717:
718: -- Code added for bug# 7237992
719: -- Please not that the code has been derived from JTF_TERR_ASSIGN_PUB.get_winners
720: -- in future if there is a change in the package, please make the corresponding changes to
721: -- this package too.
722: IF ( p_source_id = -1001 AND p_trans_id = -1002) THEN
723: l_program_name := 'SALES/ACCOUNT PROGRAM';

Line 792: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',

788:
789: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
790: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
792: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
793: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
794: END IF;
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;

Line 801: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',

797:
798: -- debug message
799: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.string(FND_LOG.LEVEL_EVENT,
801: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
802: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
803: END IF;
804:
805: JTY_ASSIGN_REALTIME_PUB.process_winners (

Line 820: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',

816:
817: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
818: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
820: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
821: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
822: END IF;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;

Line 829: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',

825:
826: -- debug message
827: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
828: FND_LOG.string(FND_LOG.LEVEL_EVENT,
829: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
830: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
831: END IF;
832:
833: -- End of Code addition