APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QTYPE_USGS_PKG

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

2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;
2112:
2113: END IF;
2114: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');
2115:
2116: /* Intialise to NULL if FND_API.G_MISS_NUM,
2117: ** otherwise used passed in value
2118: */

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

2121: END IF;
2122:
2123:
2124: -- Call insert terr_Qual_Type_Usgs table handler
2125: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
2126: x_TERR_QTYPE_USG_ID => l_TERR_QUAL_TYPE_USG_ID,
2127: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
2128: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
2129: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

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

4063: raise FND_API.G_EXC_ERROR;
4064: End if;
4065: CLOSE C_GetTerrQualTypeUsgs;
4066:
4067: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
4068: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
4069: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
4070: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
4071: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,

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

4064: End if;
4065: CLOSE C_GetTerrQualTypeUsgs;
4066:
4067: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
4068: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
4069: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
4070: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
4071: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
4072: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

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

5217:
5218: --Initialize the return status to success
5219: x_return_status := FND_API.G_RET_STS_SUCCESS;
5220:
5221: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
5222: --
5223: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
5224: --
5225: --

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

5219: x_return_status := FND_API.G_RET_STS_SUCCESS;
5220:
5221: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
5222: --
5223: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
5224: --
5225: --
5226: --Prepare message name
5227: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');