DBA Data[Home] [Help]

APPS.JTF_TERR_SALES_PUB dependencies on JTF_TERRITORY_GLOBAL_PUB

Line 694: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;

690: -- Initialize API return status to success
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692:
693: --Reset the global variables
694: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;
695:
696: /* 2167091 bug fix: JDOCHERT: 01/17/02 */
697: lp_Acc_Rec := p_TerrAcct_Rec;
698: lp_Acc_Rec.trans_object_id := p_TerrAcct_Rec.party_id;

Line 713: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(1).terr_id

709: =======================================================================================*/
710: IF (x_winners_rec.terr_id.LAST >= 1) THEN
711:
712: -- put first terr_id into global table record
713: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(1).terr_id
714: := x_winners_rec.terr_id(x_winners_rec.terr_id.first);
715:
716: -- insert additional territories if they do not exist in the global table record
717: l_count1 := x_winners_rec.terr_id.FIRST;

Line 719: l_count2 := JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.FIRST;

715:
716: -- insert additional territories if they do not exist in the global table record
717: l_count1 := x_winners_rec.terr_id.FIRST;
718: WHILE (l_count1 <= x_winners_rec.terr_id.LAST) LOOP
719: l_count2 := JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.FIRST;
720:
721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP
722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);
723:

Line 721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP

717: l_count1 := x_winners_rec.terr_id.FIRST;
718: WHILE (l_count1 <= x_winners_rec.terr_id.LAST) LOOP
719: l_count2 := JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.FIRST;
720:
721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP
722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);
723:
724: IF (l_count2 = JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) THEN
725: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2 + 1).terr_id := x_winners_rec.terr_id(l_count1);

Line 722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);

718: WHILE (l_count1 <= x_winners_rec.terr_id.LAST) LOOP
719: l_count2 := JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.FIRST;
720:
721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP
722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);
723:
724: IF (l_count2 = JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) THEN
725: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2 + 1).terr_id := x_winners_rec.terr_id(l_count1);
726: END IF;

Line 724: IF (l_count2 = JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) THEN

720:
721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP
722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);
723:
724: IF (l_count2 = JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) THEN
725: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2 + 1).terr_id := x_winners_rec.terr_id(l_count1);
726: END IF;
727: l_count2 := l_count2 + 1;
728:

Line 725: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2 + 1).terr_id := x_winners_rec.terr_id(l_count1);

721: WHILE (l_count2 <= JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) LOOP
722: EXIT WHEN JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2).terr_id = x_winners_rec.terr_id(l_count1);
723:
724: IF (l_count2 = JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl.LAST) THEN
725: JTF_TERRITORY_GLOBAL_PUB.G_WinningTerr_Tbl(l_count2 + 1).terr_id := x_winners_rec.terr_id(l_count1);
726: END IF;
727: l_count2 := l_count2 + 1;
728:
729: END LOOP;

Line 737: l_NoOfWinTerr := JTF_TERRITORY_GLOBAL_PUB.get_RecordCount;

733:
734: END IF;
735:
736: -- Get the number of Territories in the Global Table
737: l_NoOfWinTerr := JTF_TERRITORY_GLOBAL_PUB.get_RecordCount;
738:
739: /* If the program did not find qualifying Territory then
740: ** add Catch all
741: */

Line 746: JTF_TERRITORY_GLOBAL_PUB.Add_Record( p_WinningTerr_Rec => l_Terr_Record,

742: If l_NoOfWinTerr = 0 Then
743:
744: l_Terr_Record.TERR_ID := 1;
745: l_Terr_Record.RANK := 0;
746: JTF_TERRITORY_GLOBAL_PUB.Add_Record( p_WinningTerr_Rec => l_Terr_Record,
747: p_Number_Of_Winners => l_Num_Of_Winners,
748: X_Return_Status => l_Return_Status);
749: End If;
750: