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 11701: -- copy_oks_billrate_schedules

11697: End copy_oks_k_sales_credits;
11698:
11699: ------------------------------------------------------------
11700: --===================================================
11701: -- copy_oks_billrate_schedules
11702: -- Parameters: P_From_Chr_ID : Header ID of source contract
11703: -- P_To_Chr_ID : Header ID of target contract
11704: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11705: -- or as part of component copy from UI (value = 'Y')

Line 11708: PROCEDURE copy_oks_billrate_schedules(P_From_Chr_ID IN NUMBER

11704: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11705: -- or as part of component copy from UI (value = 'Y')
11706: --====================================================
11707:
11708: PROCEDURE copy_oks_billrate_schedules(P_From_Chr_ID IN NUMBER
11709: ,P_To_Chr_ID IN NUMBER
11710: ,P_Partial_Copy_YN IN VARCHAR2
11711: ,P_Lines_Count IN NUMBER DEFAULT 0
11712: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

11710: ,P_Partial_Copy_YN IN VARCHAR2
11711: ,P_Lines_Count IN NUMBER DEFAULT 0
11712: ,x_return_status OUT NOCOPY VARCHAR2) IS
11713:
11714: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_BILLRATE_SCHEDULES';
11715: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11716: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11717:
11718: CURSOR GetOksBSCHFull IS

Line 11751: OKS_BILLRATE_SCHEDULES oksBSCH

11747: ,oksBSCH.REQUEST_ID AS oksBSCH_REQUEST_ID
11748: ,oksBSCH.SECURITY_GROUP_ID AS oksBSCH_SECURITY_GROUP_ID
11749: ,1 AS oksBSCH_OBJECT_VERSION_NUMBER
11750: FROM
11751: OKS_BILLRATE_SCHEDULES oksBSCH
11752: ,OKC_K_LINES_B okcB
11753: WHERE oksBSCH.CLE_ID = okcB.ORIG_SYSTEM_ID1
11754: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11755: AND oksBSCH.DNZ_CHR_ID = P_From_Chr_ID;

Line 11790: OKS_BILLRATE_SCHEDULES oksBSCH

11786: ,oksBSCH.REQUEST_ID AS oksBSCH_REQUEST_ID
11787: ,oksBSCH.SECURITY_GROUP_ID AS oksBSCH_SECURITY_GROUP_ID
11788: ,1 AS oksBSCH_OBJECT_VERSION_NUMBER
11789: FROM
11790: OKS_BILLRATE_SCHEDULES oksBSCH
11791: ,OKC_K_LINES_B_TEMP okcBT
11792: WHERE oksBSCH.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11793: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
11794: AND oksBSCH.DNZ_CHR_ID = P_From_Chr_ID;

Line 11876: INSERT INTO OKS_BILLRATE_SCHEDULES (

11872:
11873: End If;
11874:
11875: FORALL i IN OksBSCHRecTab.OksBSCH_NewID.FIRST .. OksBSCHRecTab.OksBSCH_NewID.LAST
11876: INSERT INTO OKS_BILLRATE_SCHEDULES (
11877: ID
11878: ,CLE_ID
11879: ,BT_CLE_ID
11880: ,DNZ_CHR_ID

Line 11976: End copy_oks_billrate_schedules;

11972: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11973: RAISE;
11974:
11975:
11976: End copy_oks_billrate_schedules;
11977:
11978: ------------------------------------------------------------
11979: --===================================================
11980: -- copy_oks_stream_levels_b

Line 19904: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------

19900: --=====================End of Action Times copy================================
19901:
19902: --=====================Start of BillRate Schedule copy for Lines===============
19903:
19904: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
19905: Begin
19906: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
19907: ,P_To_Chr_ID => P_To_Chr_ID
19908: ,P_Partial_Copy_YN => 'N'

Line 19906: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID

19902: --=====================Start of BillRate Schedule copy for Lines===============
19903:
19904: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
19905: Begin
19906: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
19907: ,P_To_Chr_ID => P_To_Chr_ID
19908: ,P_Partial_Copy_YN => 'N'
19909: ,x_return_status => l_return_status);
19910:

Line 25337: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------

25333:
25334: --=====================Start of BillRate Schedule copy for Lines===============
25335:
25336: IF (P_Lines_Tbl.COUNT > 0) then
25337: --------------Copy of OKS_BILLRATE_SCHEDULES-------------------------------
25338: Begin
25339: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25340: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25341: FND_LOG.string(FND_LOG.level_statement

Line 25348: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID

25344: );
25345: END IF;
25346: END IF;
25347:
25348: copy_oks_billrate_schedules(P_From_Chr_ID => P_From_Chr_ID
25349: ,P_To_Chr_ID => P_To_Chr_ID
25350: ,P_Partial_Copy_YN => 'Y'
25351: ,P_Lines_Count => P_Lines_Tbl.COUNT
25352: ,x_return_status => l_return_status);