DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_QUAL_PKG

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

2392: l_terr_qual_id := NULL;
2393: END IF;
2394:
2395: -- Call insert terr_Qual_Type_Usgs table handler
2396: JTF_TERR_QUAL_PKG.Insert_Row(x_Rowid => l_rowid,
2397: x_TERR_QUAL_ID => l_terr_qual_id,
2398: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
2399: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
2400: x_CREATION_DATE => P_Terr_Qual_Rec.CREATION_DATE,

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

3971: raise FND_API.G_EXC_ERROR;
3972: End if;
3973: CLOSE C_GetTerrQualifier;
3974:
3975: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
3976: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
3977: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
3978: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
3979: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,

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

3972: End if;
3973: CLOSE C_GetTerrQualifier;
3974:
3975: --dbms_output('Update_Terr_Qualifier REC: Before Calling JTF_TERR_QUAL_PKG.Update_Row');
3976: JTF_TERR_QUAL_PKG.Update_Row(x_Rowid => l_rowid,
3977: x_TERR_QUAL_ID => P_Terr_Qual_Rec.terr_qual_id,
3978: x_LAST_UPDATE_DATE => P_Terr_Qual_Rec.LAST_UPDATE_DATE,
3979: x_LAST_UPDATED_BY => P_Terr_Qual_Rec.LAST_UPDATED_BY,
3980: x_CREATION_DATE => P_Terr_Qual_Rec.creation_date,

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

4973: WHERE terr_qual_id = p_terr_qual_id
4974: RETURNING terr_value_id
4975: BULK COLLECT INTO deletedIds;
4976:
4977: JTF_TERR_QUAL_PKG.Delete_Row(x_terr_qual_id => P_Terr_Qual_Id );
4978: --
4979: --Prepare message name
4980: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
4981: IF SQL%FOUND THEN