APPS.AS_RTTAP_OPPTY dependencies on JTY_ASSIGN_REALTIME_PUB

Line 21: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;

17: l_errbuf VARCHAR2(4000);
18: l_retcode VARCHAR2(255);
19: l_msg_count NUMBER;
20: l_msg_data VARCHAR2(1000);
21: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
22: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
23: l_api_name CONSTANT VARCHAR2(30) := 'RTTAP_WRAPPER';
24: l_api_version_number CONSTANT NUMBER := 1.0;
25: L_RETURN_STATUS VARCHAR2(10);

Line 22: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;

18: l_retcode VARCHAR2(255);
19: l_msg_count NUMBER;
20: l_msg_data VARCHAR2(1000);
21: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
22: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
23: l_api_name CONSTANT VARCHAR2(30) := 'RTTAP_WRAPPER';
24: l_api_version_number CONSTANT NUMBER := 1.0;
25: L_RETURN_STATUS VARCHAR2(10);
26: BEGIN

Line 94: JTY_ASSIGN_REALTIME_PUB.get_winners(

90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);
94: JTY_ASSIGN_REALTIME_PUB.get_winners(
95: p_api_version_number => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,
97: p_source_id => -1001,
98: p_trans_id => -1004,

Line 348: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

344: /************************** Start Explode Teams Opptys ******************/
345: PROCEDURE EXPLODE_TEAMS_OPPTYS(
346: x_errbuf OUT NOCOPY VARCHAR2,
347: x_retcode OUT NOCOPY VARCHAR2,
348: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
349: x_return_status OUT NOCOPY VARCHAR2)
350: IS
351:
352: /*-------------------------------------------------------------------------+

Line 548: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

544: /************************** Start Explode Groups Opptys ******************/
545: PROCEDURE EXPLODE_GROUPS_OPPTYS(
546: x_errbuf OUT NOCOPY VARCHAR2,
547: x_retcode OUT NOCOPY VARCHAR2,
548: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
549: x_return_status OUT NOCOPY VARCHAR2)
550: IS
551: -------------RS_GROUP---------
552: /*-------------------------------------------------------------------------+

Line 653: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

649:
650: PROCEDURE SET_TEAM_LEAD_OPPTYS(
651: x_errbuf OUT NOCOPY VARCHAR2,
652: x_retcode OUT NOCOPY VARCHAR2,
653: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
654: x_return_status OUT NOCOPY VARCHAR2) IS
655: BEGIN
656: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
657: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 688: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

684:
685: PROCEDURE INSERT_ACCESSES_OPPTYS(
686: x_errbuf OUT NOCOPY VARCHAR2,
687: x_retcode OUT NOCOPY VARCHAR2,
688: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
689: x_return_status OUT NOCOPY VARCHAR2) IS
690: BEGIN
691: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
692: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 761: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

757:
758: PROCEDURE INSERT_TERR_ACCESSES_OPPTYS(
759: x_errbuf OUT NOCOPY VARCHAR2,
760: x_retcode OUT NOCOPY VARCHAR2,
761: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
762: x_return_status OUT NOCOPY VARCHAR2) IS
763: BEGIN
764: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
765: /*------------------------------------------------------------------------------+

Line 820: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

816:
817: PROCEDURE PERFORM_OPPTY_CLEANUP(
818: x_errbuf OUT NOCOPY VARCHAR2,
819: x_retcode OUT NOCOPY VARCHAR2,
820: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
821: x_return_status OUT NOCOPY VARCHAR2) IS
822:
823: BEGIN
824: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 855: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

851: ----------------------
852: PROCEDURE ASSIGN_OPPTY_OWNER(
853: x_errbuf OUT NOCOPY VARCHAR2,
854: x_retcode OUT NOCOPY VARCHAR2,
855: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
856: x_return_status OUT NOCOPY VARCHAR2) IS
857:
858: CURSOR oppty_owner_rt IS
859: SELECT MAX(AAA.access_id) access_id -- /*+ index(aaa as_accesses_n3) */