DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_VALUES_PKG

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

3125: IF (l_terr_value_id = FND_API.G_MISS_NUM) THEN
3126: l_terr_value_id := NULL;
3127: END IF;
3128: --
3129: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
3130: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
3131: x_TERR_VALUE_ID => l_terr_value_id,
3132: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
3133: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,

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

3126: l_terr_value_id := NULL;
3127: END IF;
3128: --
3129: --dbms_output('Create_Terr_Value PVT: Before Calling JTF_TERR_VALUES_PKG.Insert_Row');
3130: JTF_TERR_VALUES_PKG.Insert_Row(x_Rowid => l_rowid,
3131: x_TERR_VALUE_ID => l_terr_value_id,
3132: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
3133: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
3134: x_CREATED_BY => P_Terr_Value_Rec.CREATED_BY,

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

4695: raise FND_API.G_EXC_ERROR;
4696:
4697: End if;
4698: CLOSE C_GetTerritoryValue;
4699: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4700: --call the table handler
4701: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4702: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4703: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,

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

4697: End if;
4698: CLOSE C_GetTerritoryValue;
4699: --dbms_output('Update_Terr_Value REC: Before Calling JTF_TERR_VALUES_PKG.Update_Row');
4700: --call the table handler
4701: JTF_TERR_VALUES_PKG.Update_Row(x_Rowid => l_rowid,
4702: x_TERR_VALUE_ID => P_Terr_Value_Rec.TERR_VALUE_ID,
4703: x_LAST_UPDATED_BY => P_Terr_Value_Rec.LAST_UPDATED_BY,
4704: x_LAST_UPDATE_DATE => P_Terr_Value_Rec.LAST_UPDATE_DATE,
4705: x_CREATED_BY => P_Terr_Value_Rec.created_by,

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

5527: --Initialize the return status to success
5528: x_return_status := FND_API.G_RET_STS_SUCCESS;
5529: --
5530:
5531: JTF_TERR_VALUES_PKG.Delete_Row(X_TERR_VALUE_ID => P_Terr_Value_Id);
5532: --
5533: --Prepare message name
5534: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');
5535: IF SQL%FOUND THEN