APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_USGS_PKG

Line 1859: --dbms_output('Create_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Insert_Row');

1855: FOR l_Counter IN 1 .. l_Terr_Usgs_Tbl_Count LOOP
1856: --
1857: BEGIN
1858:
1859: --dbms_output('Create_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Insert_Row');
1860:
1861: -- Initialize API return status to success
1862: x_return_status := FND_API.G_RET_STS_SUCCESS;
1863:

Line 1910: JTF_TERR_USGS_PKG.Insert_Row(x_Rowid => l_rowid,

1906: IF (l_terr_usg_id = FND_API.G_MISS_NUM) THEN
1907: l_terr_usg_id := NULL;
1908: END IF;
1909:
1910: JTF_TERR_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
1911: x_TERR_USG_ID => l_terr_usg_id,
1912: x_LAST_UPDATE_DATE => P_Terr_Usgs_Tbl(l_Counter).LAST_UPDATE_DATE,
1913: x_LAST_UPDATED_BY => P_Terr_Usgs_Tbl(l_Counter).LAST_UPDATED_BY,
1914: x_CREATION_DATE => P_Terr_Usgs_Tbl(l_Counter).CREATION_DATE,

Line 3788: --dbms_output('Update_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Update_Row');

3784: raise FND_API.G_EXC_ERROR;
3785: End if;
3786: CLOSE C_GetTerritoryUsage;
3787:
3788: --dbms_output('Update_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Update_Row');
3789: -- Call insert terr_Qual_Type_Usgs table handler
3790: JTF_TERR_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3791: x_TERR_USG_ID => P_Terr_Usgs_Rec.terr_usg_id,
3792: x_LAST_UPDATE_DATE => P_Terr_Usgs_Rec.LAST_UPDATE_DATE,

Line 3790: JTF_TERR_USGS_PKG.Update_Row(x_Rowid => l_rowid,

3786: CLOSE C_GetTerritoryUsage;
3787:
3788: --dbms_output('Update_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Update_Row');
3789: -- Call insert terr_Qual_Type_Usgs table handler
3790: JTF_TERR_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3791: x_TERR_USG_ID => P_Terr_Usgs_Rec.terr_usg_id,
3792: x_LAST_UPDATE_DATE => P_Terr_Usgs_Rec.LAST_UPDATE_DATE,
3793: x_LAST_UPDATED_BY => P_Terr_Usgs_Rec.LAST_UPDATED_BY,
3794: x_CREATION_DATE => P_Terr_Usgs_Rec.CREATION_DATE,

Line 5088: JTF_TERR_USGS_PKG.Delete_Row(x_TERR_USG_ID => P_Terr_usg_Id);

5084: x_return_status := FND_API.G_RET_STS_SUCCESS;
5085: --
5086: --dbms_output('Delete_Territory_Usages: Before Calling Create_TerrType_Qualifier TBL');
5087: --
5088: JTF_TERR_USGS_PKG.Delete_Row(x_TERR_USG_ID => P_Terr_usg_Id);
5089: --
5090: --Prepare message name
5091: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5092: IF SQL%FOUND THEN