APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_PKG

Line 1125: --dbms_output('Deactivate_Territory PVT: Before Calling JTF_TERR_PKG.Update_Row');

1121: raise FND_API.G_EXC_ERROR;
1122: End if;
1123: CLOSE C_GetTerritory;
1124:
1125: --dbms_output('Deactivate_Territory PVT: Before Calling JTF_TERR_PKG.Update_Row');
1126: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
1127: x_terr_id => p_terr_id,
1128: x_last_update_date => l_ref_terr_all_rec.LAST_UPDATE_DATE,
1129: x_last_updated_by => l_ref_terr_all_rec.LAST_UPDATED_BY,

Line 1126: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,

1122: End if;
1123: CLOSE C_GetTerritory;
1124:
1125: --dbms_output('Deactivate_Territory PVT: Before Calling JTF_TERR_PKG.Update_Row');
1126: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
1127: x_terr_id => p_terr_id,
1128: x_last_update_date => l_ref_terr_all_rec.LAST_UPDATE_DATE,
1129: x_last_updated_by => l_ref_terr_all_rec.LAST_UPDATED_BY,
1130: x_creation_date => l_ref_terr_all_rec.CREATION_DATE,

Line 1544: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row APP_SHORT_NAME-' || G_APP_SHORT_NAME);

1540: END IF;
1541:
1542: -- Call insert terr_all table handler
1543: --
1544: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row APP_SHORT_NAME-' || G_APP_SHORT_NAME);
1545: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row p_terr_all_rec.APPLICATION_SHORT_NAME-' || p_terr_all_rec.APPLICATION_SHORT_NAME);
1546:
1547: /* Intialise to NULL if FND_API.G_MISS_NUM,
1548: ** otherwise use passed in value

Line 1545: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row p_terr_all_rec.APPLICATION_SHORT_NAME-' || p_terr_all_rec.APPLICATION_SHORT_NAME);

1541:
1542: -- Call insert terr_all table handler
1543: --
1544: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row APP_SHORT_NAME-' || G_APP_SHORT_NAME);
1545: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row p_terr_all_rec.APPLICATION_SHORT_NAME-' || p_terr_all_rec.APPLICATION_SHORT_NAME);
1546:
1547: /* Intialise to NULL if FND_API.G_MISS_NUM,
1548: ** otherwise use passed in value
1549: */

Line 1554: JTF_TERR_PKG.Insert_Row(x_rowid => l_rowid,

1550: IF (l_terr_id = FND_API.G_MISS_NUM) THEN
1551: l_terr_id := NULL;
1552: END IF;
1553:
1554: JTF_TERR_PKG.Insert_Row(x_rowid => l_rowid,
1555: x_terr_id => l_terr_id,
1556: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
1557: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,
1558: x_creation_date => p_terr_all_rec.CREATION_DATE,

Line 3211: --dbms_output('Update_territory_Record: Before Calling JTF_TERR_PKG.Update_Row');

3207: raise FND_API.G_EXC_ERROR;
3208: End if;
3209: CLOSE C_GetTerritory;
3210:
3211: --dbms_output('Update_territory_Record: Before Calling JTF_TERR_PKG.Update_Row');
3212: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
3213: x_terr_id => p_terr_all_rec.terr_id,
3214: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
3215: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,

Line 3212: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,

3208: End if;
3209: CLOSE C_GetTerritory;
3210:
3211: --dbms_output('Update_territory_Record: Before Calling JTF_TERR_PKG.Update_Row');
3212: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
3213: x_terr_id => p_terr_all_rec.terr_id,
3214: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
3215: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,
3216: x_creation_date => p_terr_all_rec.CREATION_DATE,

Line 4538: JTF_TERR_PKG.Delete_Row(x_terr_Id => P_Terr_Id);

4534: x_return_status := FND_API.G_RET_STS_SUCCESS;
4535: --
4536: --dbms_output('Delete_territory_Record: Before Calling Create_TerrType_Qualifier TBL');
4537: --
4538: JTF_TERR_PKG.Delete_Row(x_terr_Id => P_Terr_Id);
4539: --
4540: --Prepare message name
4541: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
4542: