APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERR_RSC_PKG

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

1383: IF (l_TerrRsc_id = FND_API.G_MISS_NUM) THEN
1384: l_TerrRsc_id := NULL;
1385: END IF;
1386:
1387: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1388: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1389: x_TERR_RSC_ID => l_TerrRsc_Id,
1390: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1391: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,

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

1384: l_TerrRsc_id := NULL;
1385: END IF;
1386:
1387: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1388: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1389: x_TERR_RSC_ID => l_TerrRsc_Id,
1390: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1391: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,
1392: x_CREATION_DATE => P_TerrRsc_Rec.CREATION_DATE,

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

1418: X_ATTRIBUTE13 => P_TerrRsc_Rec.ATTRIBUTE13,
1419: X_ATTRIBUTE14 => P_TerrRsc_Rec.ATTRIBUTE14,
1420: X_ATTRIBUTE15 => P_TerrRsc_Rec.ATTRIBUTE15 );
1421:
1422: --dbms_output.put_line('After calling JTF_TERR_RSC_PKG.Insert_Row');
1423: -- Save the terr_usg_id and
1424: X_TerrRsc_Out_Rec.TERR_RSC_ID := l_TerrRsc_Id;
1425:
1426: -- If successful then save the success status for the record

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

1565: IF (l_TerrRsc_id = FND_API.G_MISS_NUM) THEN
1566: l_TerrRsc_id := NULL;
1567: END IF;
1568:
1569: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1570: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1571: x_TERR_RSC_ID => l_TerrRsc_Id,
1572: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1573: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,

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

1566: l_TerrRsc_id := NULL;
1567: END IF;
1568:
1569: --dbms_output.put_line('Create_Terr_Resource REC: Before Calling JTF_TERR_RSC_PKG.Insert_Row');
1570: JTF_TERR_RSC_PKG.Insert_Row(x_Rowid => l_rowid,
1571: x_TERR_RSC_ID => l_TerrRsc_Id,
1572: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
1573: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY,
1574: x_CREATION_DATE => P_TerrRsc_Rec.CREATION_DATE,

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

1584: X_END_DATE_ACTIVE => P_TerrRsc_Rec.END_DATE_ACTIVE,
1585: X_FULL_ACCESS_FLAG => P_TerrRsc_Rec.FULL_ACCESS_FLAG,
1586: X_ORG_ID => P_TerrRsc_Rec.ORG_ID );
1587:
1588: --dbms_output.put_line('After calling JTF_TERR_RSC_PKG.Insert_Row');
1589: -- Save the terr_usg_id and
1590: X_TerrRsc_Out_Rec.TERR_RSC_ID := l_TerrRsc_Id;
1591:
1592: -- If successful then save the success status for the record

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

2368:
2369: --Initialize the return status to success
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;
2371: --
2372: JTF_TERR_RSC_PKG.Delete_Row(x_TERR_RSC_ID => P_TerrRsc_Id);
2373: --
2374: --Prepare message name
2375: FND_MESSAGE.SET_NAME('JTF','TERR_RESOURCE_DELETED');
2376:

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

2548: raise FND_API.G_EXC_ERROR;
2549: End if;
2550: CLOSE C_GetTerrResource;
2551:
2552: JTF_TERR_RSC_PKG.Update_Row(x_Rowid => l_rowid,
2553: x_TERR_RSC_ID => P_TerrRsc_Rec.Terr_Rsc_Id,
2554: x_LAST_UPDATE_DATE => P_TerrRsc_Rec.LAST_UPDATE_DATE,
2555: x_LAST_UPDATED_BY => P_TerrRsc_Rec.LAST_UPDATED_BY ,
2556: x_CREATION_DATE => P_TerrRsc_Rec.CREATION_DATE,