DBA Data[Home] [Help]

APPS.OKI_LOAD_TERR_PVT dependencies on JTF_TERR_ASSIGN_PUB

Line 772: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

768: retcode NUMBER;
769: l_sqlcode VARCHAR2(100);
770: l_sqlerrm VARCHAR2(1000);
771: l_return_status VARCHAR2(1);
772: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
773: l_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
774:
775: l_no_update_refresh EXCEPTION;
776: l_sysdate DATE;

Line 773: l_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

769: l_sqlcode VARCHAR2(100);
770: l_sqlerrm VARCHAR2(1000);
771: l_return_status VARCHAR2(1);
772: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
773: l_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
774:
775: l_no_update_refresh EXCEPTION;
776: l_sysdate DATE;
777:

Line 804: --JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type plsql table with the list of

800: LOOP
801:
802: --
803: --For each combination of authoring_org and customer combination populate
804: --JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type plsql table with the list of
805: --party_name, state_code, country_code and party_id
806: --
807:
808: l_gen_bulk_rec.trans_object_id.EXTEND;

Line 834: JTF_TERR_ASSIGN_PUB.get_winners

830: --
831: BEGIN
832: rlog('Calling JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);
833:
834: JTF_TERR_ASSIGN_PUB.get_winners
835: ( p_api_version_number => 1.0
836: , p_init_msg_list => OKC_API.G_FALSE
837: , p_use_type => l_use_type
838: , p_source_id => -1500

Line 858: rlog('Error in JTF_TERR_ASSIGN_PUB call ',1);

854: rlog ('Returned From JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);
855:
856: EXCEPTION
857: WHEN OTHERS THEN
858: rlog('Error in JTF_TERR_ASSIGN_PUB call ',1);
859: RAISE;
860: END;
861:
862: --FOR i IN l_gen_return_rec.trans_object_id.FIRST .. l_gen_return_rec.trans_object_id.LAST