APPS.AS_RTTAP_ACCOUNT dependencies on JTY_ASSIGN_REALTIME_PUB

Line 335: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;

331: l_errbuf VARCHAR2(4000);
332: l_retcode VARCHAR2(255);
333: l_msg_count NUMBER;
334: l_msg_data VARCHAR2(255);
335: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
336: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
337: l_return_status VARCHAR2(1);
338:
339: BEGIN

Line 336: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;

332: l_retcode VARCHAR2(255);
333: l_msg_count NUMBER;
334: l_msg_data VARCHAR2(255);
335: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
336: l_WinningTerrMember_tbl JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
337: l_return_status VARCHAR2(1);
338:
339: BEGIN
340:

Line 393: JTY_ASSIGN_REALTIME_PUB.get_winners(

389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);
393: JTY_ASSIGN_REALTIME_PUB.get_winners(
394: p_api_version_number => 1.0,
395: p_init_msg_list => FND_API.G_FALSE,
396: p_source_id => -1001,
397: p_trans_id => -1002,

Line 542: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

538: /************************** Start Explode Teams ACCOUNTs ******************/
539: PROCEDURE EXPLODE_TEAMS_ACCOUNTS(
540: x_errbuf OUT NOCOPY VARCHAR2,
541: x_retcode OUT NOCOPY VARCHAR2,
542: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
543: x_return_status OUT NOCOPY VARCHAR2)
544: IS
545:
546: /*-------------------------------------------------------------------------+

Line 747: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

743: /************************** Start Explode Groups ACCOUNTs ******************/
744: PROCEDURE EXPLODE_GROUPS_ACCOUNTS(
745: x_errbuf OUT NOCOPY VARCHAR2,
746: x_retcode OUT NOCOPY VARCHAR2,
747: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
748: x_return_status OUT NOCOPY VARCHAR2)
749: IS
750: -------------RS_GROUP---------
751: /*-------------------------------------------------------------------------+

Line 857: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

853:
854: PROCEDURE SET_TEAM_LEAD_ACCOUNTS(
855: x_errbuf OUT NOCOPY VARCHAR2,
856: x_retcode OUT NOCOPY VARCHAR2,
857: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
858: x_return_status OUT NOCOPY VARCHAR2) IS
859:
860: src_id NUMBER:= 0;
861: BEGIN

Line 901: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

897:
898: PROCEDURE INSERT_ACCESSES_ACCOUNTS(
899: x_errbuf OUT NOCOPY VARCHAR2,
900: x_retcode OUT NOCOPY VARCHAR2,
901: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
902: x_return_status OUT NOCOPY VARCHAR2) IS
903: BEGIN
904: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
905: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1050: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

1046:
1047: PROCEDURE INSERT_TERR_ACCESSES_ACCOUNTS(
1048: x_errbuf OUT NOCOPY VARCHAR2,
1049: x_retcode OUT NOCOPY VARCHAR2,
1050: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1051: x_return_status OUT NOCOPY VARCHAR2) IS
1052: BEGIN
1053: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1054: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1139: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,

1135:
1136: PROCEDURE PERFORM_ACCOUNT_CLEANUP(
1137: x_errbuf OUT NOCOPY VARCHAR2,
1138: x_retcode OUT NOCOPY VARCHAR2,
1139: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1140: x_return_status OUT NOCOPY VARCHAR2) IS
1141:
1142: TYPE access_type IS TABLE OF NUMBER;
1143: l_access_rec_id access_type;