eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_BILLRATE_SCHEDULES

Line 11746: -- copy_oks_billrate_schedules

11742: End copy_oks_k_sales_credits;
11743:
11744: ------------------------------------------------------------
11745: --===================================================
11746: -- copy_oks_billrate_schedules
11747: -- Parameters: P_From_Chr_ID : Header ID of source contract
11748: -- P_To_Chr_ID : Header ID of target contract
11749: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11750: -- or as part of component copy from UI (value = 'Y')

Line 11753: PROCEDURE copy_oks_billrate_schedules(P_From_Chr_ID IN NUMBER

11749: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11750: -- or as part of component copy from UI (value = 'Y')
11751: --====================================================
11752:
11753: PROCEDURE copy_oks_billrate_schedules(P_From_Chr_ID IN NUMBER
11754: ,P_To_Chr_ID IN NUMBER
11755: ,P_Partial_Copy_YN IN VARCHAR2
11756: ,P_Lines_Count IN NUMBER DEFAULT 0
11757: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 11759: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_BILLRATE_SCHEDULES';

11755: ,P_Partial_Copy_YN IN VARCHAR2
11756: ,P_Lines_Count IN NUMBER DEFAULT 0
11757: ,x_return_status OUT NOCOPY VARCHAR2) IS
11758:
11759: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_BILLRATE_SCHEDULES';
11760: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11761: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11762:
11763: CURSOR GetOksBSCHFull IS

Line 11796: OKS_BILLRATE_SCHEDULES oksBSCH

11792: ,oksBSCH.REQUEST_ID AS oksBSCH_REQUEST_ID
11793: ,oksBSCH.SECURITY_GROUP_ID AS oksBSCH_SECURITY_GROUP_ID
11794: ,1 AS oksBSCH_OBJECT_VERSION_NUMBER
11795: FROM
11796: OKS_BILLRATE_SCHEDULES oksBSCH
11797: ,OKC_K_LINES_B okcB
11798: WHERE oksBSCH.CLE_ID = okcB.ORIG_SYSTEM_ID1
11799: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11800: AND oksBSCH.DNZ_CHR_ID = P_From_Chr_ID;

Line 11835: OKS_BILLRATE_SCHEDULES oksBSCH

11831: ,oksBSCH.REQUEST_ID AS oksBSCH_REQUEST_ID
11832: ,oksBSCH.SECURITY_GROUP_ID AS oksBSCH_SECURITY_GROUP_ID
11833: ,1 AS oksBSCH_OBJECT_VERSION_NUMBER
11834: FROM
11835: OKS_BILLRATE_SCHEDULES oksBSCH
11836: ,OKC_K_LINES_B_TEMP okcBT
11837: WHERE oksBSCH.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11838: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
11839: AND oksBSCH.DNZ_CHR_ID = P_From_Chr_ID;

Line 11921: INSERT INTO OKS_BILLRATE_SCHEDULES (

11917:
11918: End If;
11919:
11920: FORALL i IN OksBSCHRecTab.OksBSCH_NewID.FIRST .. OksBSCHRecTab.OksBSCH_NewID.LAST
11921: INSERT INTO OKS_BILLRATE_SCHEDULES (
11922: ID
11923: ,CLE_ID
11924: ,BT_CLE_ID
11925: ,DNZ_CHR_ID

Line 12021: End copy_oks_billrate_schedules;

12017: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
12018: RAISE;
12019:
12020:
12021: End copy_oks_billrate_schedules;
12022:
12023: ------------------------------------------------------------
12024: --===================================================
12025: -- copy_oks_stream_levels_b

Line 20051: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------

20047: --=====================End of Action Times copy================================
20048:
20049: --=====================Start of BillRate Schedule copy for Lines===============
20050:
20051: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
20052: Begin
20053: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
20054: ,P_To_Chr_ID => P_To_Chr_ID
20055: ,P_Partial_Copy_YN => 'N'

Line 20053: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID

20049: --=====================Start of BillRate Schedule copy for Lines===============
20050:
20051: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
20052: Begin
20053: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
20054: ,P_To_Chr_ID => P_To_Chr_ID
20055: ,P_Partial_Copy_YN => 'N'
20056: ,x_return_status => l_return_status);
20057:

Line 25532: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------

25528:
25529: --=====================Start of BillRate Schedule copy for Lines===============
25530:
25531: IF (P_Lines_Tbl.COUNT > 0) then
25532: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
25533: Begin
25534: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25535: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25536: FND_LOG.string(FND_LOG.level_statement

Line 25543: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID

25539: );
25540: END IF;
25541: END IF;
25542:
25543: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
25544: ,P_To_Chr_ID => P_To_Chr_ID
25545: ,P_Partial_Copy_YN => 'Y'
25546: ,P_Lines_Count => P_Lines_Tbl.COUNT
25547: ,x_return_status => l_return_status);