APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_USGS_PKG

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

1754: FOR l_Counter IN 1 .. l_Terr_Usgs_Tbl_Count LOOP
1755: --
1756: BEGIN
1757:
1758: --dbms_output('Create_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Insert_Row');
1759:
1760: -- Initialize API return status to success
1761: x_return_status := FND_API.G_RET_STS_SUCCESS;
1762:

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

1805: IF (l_terr_usg_id = FND_API.G_MISS_NUM) THEN
1806: l_terr_usg_id := NULL;
1807: END IF;
1808:
1809: JTF_TERR_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
1810: x_TERR_USG_ID => l_terr_usg_id,
1811: x_LAST_UPDATE_DATE => P_Terr_Usgs_Tbl(l_Counter).LAST_UPDATE_DATE,
1812: x_LAST_UPDATED_BY => P_Terr_Usgs_Tbl(l_Counter).LAST_UPDATED_BY,
1813: x_CREATION_DATE => P_Terr_Usgs_Tbl(l_Counter).CREATION_DATE,

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

3409: raise FND_API.G_EXC_ERROR;
3410: End if;
3411: CLOSE C_GetTerritoryUsage;
3412:
3413: --dbms_output('Update_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Update_Row');
3414: -- Call insert terr_Qual_Type_Usgs table handler
3415: JTF_TERR_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3416: x_TERR_USG_ID => P_Terr_Usgs_Rec.terr_usg_id,
3417: x_LAST_UPDATE_DATE => P_Terr_Usgs_Rec.LAST_UPDATE_DATE,

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

3411: CLOSE C_GetTerritoryUsage;
3412:
3413: --dbms_output('Update_Territory_Usages PVT: Before Calling JTF_TERR_USGS_PKG.Update_Row');
3414: -- Call insert terr_Qual_Type_Usgs table handler
3415: JTF_TERR_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3416: x_TERR_USG_ID => P_Terr_Usgs_Rec.terr_usg_id,
3417: x_LAST_UPDATE_DATE => P_Terr_Usgs_Rec.LAST_UPDATE_DATE,
3418: x_LAST_UPDATED_BY => P_Terr_Usgs_Rec.LAST_UPDATED_BY,
3419: x_CREATION_DATE => P_Terr_Usgs_Rec.CREATION_DATE,

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

4670: x_return_status := FND_API.G_RET_STS_SUCCESS;
4671: --
4672: --dbms_output('Delete_Territory_Usages: Before Calling Create_TerrType_Qualifier TBL');
4673: --
4674: JTF_TERR_USGS_PKG.Delete_Row(x_TERR_USG_ID => P_Terr_usg_Id);
4675: --
4676: --Prepare message name
4677: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
4678: IF SQL%FOUND THEN