APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_PKG

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

1147: raise FND_API.G_EXC_ERROR;
1148: End if;
1149: CLOSE C_GetTerritory;
1150:
1151: --dbms_output('Deactivate_Territory PVT: Before Calling JTF_TERR_PKG.Update_Row');
1152: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
1153: x_terr_id => p_terr_id,
1154: x_last_update_date => l_ref_terr_all_rec.LAST_UPDATE_DATE,
1155: x_last_updated_by => l_ref_terr_all_rec.LAST_UPDATED_BY,

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

1148: End if;
1149: CLOSE C_GetTerritory;
1150:
1151: --dbms_output('Deactivate_Territory PVT: Before Calling JTF_TERR_PKG.Update_Row');
1152: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
1153: x_terr_id => p_terr_id,
1154: x_last_update_date => l_ref_terr_all_rec.LAST_UPDATE_DATE,
1155: x_last_updated_by => l_ref_terr_all_rec.LAST_UPDATED_BY,
1156: x_creation_date => l_ref_terr_all_rec.CREATION_DATE,

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

1641: END IF;
1642:
1643: -- Call insert terr_all table handler
1644: --
1645: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row APP_SHORT_NAME-' || G_APP_SHORT_NAME);
1646: --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);
1647:
1648: /* Intialise to NULL if FND_API.G_MISS_NUM,
1649: ** otherwise use passed in value

Line 1646: --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);

1642:
1643: -- Call insert terr_all table handler
1644: --
1645: --dbms_output('Create_Territory_Record PVT: Before Calling JTF_TERR_PKG.Insert_Row APP_SHORT_NAME-' || G_APP_SHORT_NAME);
1646: --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);
1647:
1648: /* Intialise to NULL if FND_API.G_MISS_NUM,
1649: ** otherwise use passed in value
1650: */

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

1651: IF (l_terr_id = FND_API.G_MISS_NUM) THEN
1652: l_terr_id := NULL;
1653: END IF;
1654:
1655: JTF_TERR_PKG.Insert_Row(x_rowid => l_rowid,
1656: x_terr_id => l_terr_id,
1657: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
1658: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,
1659: x_creation_date => p_terr_all_rec.CREATION_DATE,

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

3580: raise FND_API.G_EXC_ERROR;
3581: End if;
3582: CLOSE C_GetTerritory;
3583:
3584: --dbms_output('Update_territory_Record: Before Calling JTF_TERR_PKG.Update_Row');
3585: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
3586: x_terr_id => p_terr_all_rec.terr_id,
3587: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
3588: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,

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

3581: End if;
3582: CLOSE C_GetTerritory;
3583:
3584: --dbms_output('Update_territory_Record: Before Calling JTF_TERR_PKG.Update_Row');
3585: JTF_TERR_PKG.Update_Row(x_rowid => l_rowid,
3586: x_terr_id => p_terr_all_rec.terr_id,
3587: x_last_update_date => p_terr_all_rec.LAST_UPDATE_DATE,
3588: x_last_updated_by => p_terr_all_rec.LAST_UPDATED_BY,
3589: x_creation_date => p_terr_all_rec.CREATION_DATE,

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

4948: x_return_status := FND_API.G_RET_STS_SUCCESS;
4949: --
4950: --dbms_output('Delete_territory_Record: Before Calling Create_TerrType_Qualifier TBL');
4951: --
4952: JTF_TERR_PKG.Delete_Row(x_terr_Id => P_Terr_Id);
4953: --
4954: --Prepare message name
4955: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
4956: