APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERR_RSC_PKG

Line 1554: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');

1550: IF (l_TerrRsc_id = FND_API.G_MISS_NUM) THEN
1551: l_TerrRsc_id := NULL;
1552: END IF;
1553:
1554: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1555: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1556: x_TERR_RSC_ID => l_TerrRsc_Id,
1557: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1558: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,

Line 1555: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,

1551: l_TerrRsc_id := NULL;
1552: END IF;
1553:
1554: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1555: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1556: x_TERR_RSC_ID => l_TerrRsc_Id,
1557: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1558: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,
1559: x_CREATION_DATE => P_TerrRsc_Rec.CREATION_DATE,

Line 1589: --dbms_output.put_line('After calling JTF_TERR_RSC_PKG.Insert_Row');

1585: X_ATTRIBUTE13 => P_TerrRsc_Rec.ATTRIBUTE13,
1586: X_ATTRIBUTE14 => P_TerrRsc_Rec.ATTRIBUTE14,
1587: X_ATTRIBUTE15 => P_TerrRsc_Rec.ATTRIBUTE15 );
1588:
1589: --dbms_output.put_line('After calling JTF_TERR_RSC_PKG.Insert_Row');
1590: -- Save the terr_usg_id and
1591: X_TerrRsc_Out_Rec.TERR_RSC_ID := l_TerrRsc_Id;
1592:
1593: -- If successful then save the success status for the record

Line 2310: JTF_TERR_RSC_PKG.Delete_Row(x_TERR_RSC_ID => P_TerrRsc_Id);

2306:
2307: --Initialize the return status to success
2308: x_return_status := FND_API.G_RET_STS_SUCCESS;
2309: --
2310: JTF_TERR_RSC_PKG.Delete_Row(x_TERR_RSC_ID => P_TerrRsc_Id);
2311: --
2312: --Prepare message name
2313: FND_MESSAGE.SET_NAME('JTF','TERR_RESOURCE_DELETED');
2314:

Line 2694: JTF_TERR_RSC_PKG.Update_Row(x_Rowid => l_rowid,

2690: RAISE FND_API.G_EXC_ERROR;
2691: END IF;
2692:
2693:
2694: JTF_TERR_RSC_PKG.Update_Row(x_Rowid => l_rowid,
2695: x_TERR_RSC_ID => P_TerrRsc_Rec.Terr_Rsc_Id,
2696: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
2697: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY ,
2698: x_CREATION_DATE => P_TerrRsc_Rec.CREATION_DATE,