DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_VALUES_PKG

Line 2755: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');

2751: l_terr_value_id := NULL;
2752: END IF;
2753:
2754: --
2755: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
2756: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
2757: x_TERR_VALUE_ID => l_terr_value_id,
2758: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
2759: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,

Line 2756: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,

2752: END IF;
2753:
2754: --
2755: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
2756: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
2757: x_TERR_VALUE_ID => l_terr_value_id,
2758: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
2759: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
2760: x_CREATED_BY => P_Terr_Value_Rec.CREATED_BY,

Line 4286: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');

4282: CLOSE C_GetTerritoryValue;
4283: --
4284: -- Add check for concurrency
4285: --
4286: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4287: --call the table handler
4288: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4289: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4290: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,

Line 4288: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,

4284: -- Add check for concurrency
4285: --
4286: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4287: --call the table handler
4288: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4289: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4290: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
4291: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
4292: x_CREATED_BY => P_Terr_Value_Rec.created_by,

Line 5116: --dbms_output('Delete_Terr_Value: Before Calling JTF_TERR_VALUES_PKG.Delete_Row');

5112:
5113: --Initialize the return status to success
5114: x_return_status := FND_API.G_RET_STS_SUCCESS;
5115: --
5116: --dbms_output('Delete_Terr_Value: Before Calling JTF_TERR_VALUES_PKG.Delete_Row');
5117:
5118: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);
5119: --
5120: --Prepare message name

Line 5118: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);

5114: x_return_status := FND_API.G_RET_STS_SUCCESS;
5115: --
5116: --dbms_output('Delete_Terr_Value: Before Calling JTF_TERR_VALUES_PKG.Delete_Row');
5117:
5118: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);
5119: --
5120: --Prepare message name
5121: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5122: IF SQL%FOUND THEN