APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QTYPE_USGS_PKG

Line 2013: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');

2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: END IF;
2013: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');
2014:
2015: /* Intialise to NULL if FND_API.G_MISS_NUM,
2016: ** otherwise used passed in value
2017: */

Line 2024: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,

2020: END IF;
2021:
2022:
2023: -- Call insert terr_Qual_Type_Usgs table handler
2024: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
2025: x_TERR_QTYPE_USG_ID => l_TERR_QUAL_TYPE_USG_ID,
2026: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
2027: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
2028: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

Line 3692: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');

3688: raise FND_API.G_EXC_ERROR;
3689: End if;
3690: CLOSE C_GetTerrQualTypeUsgs;
3691:
3692: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
3693: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3694: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
3695: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
3696: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,

Line 3693: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,

3689: End if;
3690: CLOSE C_GetTerrQualTypeUsgs;
3691:
3692: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
3693: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3694: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
3695: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
3696: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
3697: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

Line 4807: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');

4803:
4804: --Initialize the return status to success
4805: x_return_status := FND_API.G_RET_STS_SUCCESS;
4806:
4807: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
4808: --
4809: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
4810: --
4811: --

Line 4809: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);

4805: x_return_status := FND_API.G_RET_STS_SUCCESS;
4806:
4807: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
4808: --
4809: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
4810: --
4811: --
4812: --Prepare message name
4813: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');