APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QUAL_PKG

Line 373: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => l_Terr_Qual_Id );

369:
370: --Remove the qualifier if no values are specified.
371: BEGIN
372: IF l_index = 0 THEN
373: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => l_Terr_Qual_Id );
374: FND_MESSAGE.Set_Name('JTF', 'JTY_TERR_MISSING_TERR_VALUES');
375: FND_MESSAGE.Set_Token('QUAL_USG_ID', to_char(l_Terr_Qual_Tbl(1).QUAL_USG_ID));
376: FND_MSG_PUB.ADD;
377: End If;

Line 2529: JTF_TERR_QUAL_PKG.Insert_Row(x_Rowid => l_rowid,

2525: l_terr_qual_id := NULL;
2526: END IF;
2527:
2528: -- Call insert terr_Qual_Type_Usgs table handler
2529: JTF_TERR_QUAL_PKG.Insert_Row(x_Rowid => l_rowid,
2530: x_TERR_QUAL_ID => l_terr_qual_id,
2531: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
2532: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
2533: x_CREATION_DATE => P_Terr_Qual_Rec.CREATION_DATE,

Line 4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');

4346: raise FND_API.G_EXC_ERROR;
4347: End if;
4348: CLOSE C_GetTerrQualifier;
4349: -- P_Terr_Qual_Rec.terr_qual_id cant be null
4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
4352: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
4353: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
4354: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,

Line 4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,

4347: End if;
4348: CLOSE C_GetTerrQualifier;
4349: -- P_Terr_Qual_Rec.terr_qual_id cant be null
4350: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
4351: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
4352: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
4353: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
4354: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
4355: x_CREATION_DATE => P_Terr_Qual_Rec.creation_date,

Line 5391: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => P_Terr_Qual_Id );

5387: WHERE terr_qual_id = p_terr_qual_id
5388: RETURNING terr_value_id
5389: BULK COLLECT INTO deletedIds;
5390:
5391: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => P_Terr_Qual_Id );
5392: --
5393: --Prepare message name
5394: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5395: IF SQL%FOUND THEN