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_COVERAGE_TIMEZONES

Line 9755: -- copy_oks_coverage_timezones

9751: End copy_oks_qualifiers;
9752:
9753: -----------------------------------------------------------
9754: --===================================================
9755: -- copy_oks_coverage_timezones
9756: -- Parameters: P_From_Chr_ID : Header ID of source contract
9757: -- P_To_Chr_ID : Header ID of target contract
9758: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9759: -- or as part of component copy from UI (value = 'Y')

Line 9762: PROCEDURE copy_oks_coverage_timezones(P_From_Chr_ID IN NUMBER

9758: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9759: -- or as part of component copy from UI (value = 'Y')
9760: --====================================================
9761:
9762: PROCEDURE copy_oks_coverage_timezones(P_From_Chr_ID IN NUMBER
9763: ,P_To_Chr_ID IN NUMBER
9764: ,P_Partial_Copy_YN IN VARCHAR2
9765: ,P_Lines_Count IN NUMBER DEFAULT 0
9766: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 9768: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMEZONES';

9764: ,P_Partial_Copy_YN IN VARCHAR2
9765: ,P_Lines_Count IN NUMBER DEFAULT 0
9766: ,x_return_status OUT NOCOPY VARCHAR2) IS
9767:
9768: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMEZONES';
9769: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9770: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9771:
9772: CURSOR GetOksCTZFull IS

Line 9790: OKS_COVERAGE_TIMEZONES oksCTZ

9786: ,oksCTZ.ID AS oksCTZ_ORIG_SYSTEM_ID1 --*
9787: ,NULL AS oksCTZ_ORIG_SYSTEM_SOURCE_CODE --*
9788: ,'COPY' AS oksCTZ_ORIG_SYSTEM_REFERENCE1 --*
9789: FROM
9790: OKS_COVERAGE_TIMEZONES oksCTZ
9791: ,OKC_K_LINES_B okcB
9792: WHERE
9793: oksCTZ.CLE_ID = okcB.ORIG_SYSTEM_ID1
9794: AND oksCTZ.DNZ_CHR_ID = P_From_Chr_ID

Line 9815: OKS_COVERAGE_TIMEZONES oksCTZ

9811: ,oksCTZ.ID AS oksCTZ_ORIG_SYSTEM_ID1 --*
9812: ,NULL AS oksCTZ_ORIG_SYSTEM_SOURCE_CODE --*
9813: ,'COPY' AS oksCTZ_ORIG_SYSTEM_REFERENCE1 --*
9814: FROM
9815: OKS_COVERAGE_TIMEZONES oksCTZ
9816: ,OKC_K_LINES_B_TEMP okcBT
9817: WHERE
9818: oksCTZ.CLE_ID = okcBT.ORIG_SYSTEM_ID1
9819: AND oksCTZ.DNZ_CHR_ID = P_From_Chr_ID

Line 9871: INSERT INTO OKS_COVERAGE_TIMEZONES(

9867:
9868: End If;
9869:
9870: FORALL i IN OksCTZRecTab.OksCTZ_NewID.FIRST .. OksCTZRecTab.OksCTZ_NewID.LAST
9871: INSERT INTO OKS_COVERAGE_TIMEZONES(
9872: ID
9873: ,CLE_ID
9874: ,DEFAULT_YN
9875: ,TIMEZONE_ID

Line 9938: End copy_oks_coverage_timezones;

9934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9935: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9936: RAISE;
9937:
9938: End copy_oks_coverage_timezones;
9939:
9940:
9941: -----------------------------------------------------------
9942: --===================================================

Line 9985: ,OKS_COVERAGE_TIMEZONES oksCTZ

9981: ,oksCT.PROGRAM_UPDATE_DATE AS oksCT_PROGRAM_UPDATE_DATE
9982: ,oksCT.REQUEST_ID AS oksCT_REQUEST_ID
9983: FROM
9984: OKS_COVERAGE_TIMES oksCT
9985: ,OKS_COVERAGE_TIMEZONES oksCTZ
9986: WHERE
9987: OksCT.COV_TZE_LINE_ID = oksCTZ.ORIG_SYSTEM_ID1
9988: AND oksCTZ.DNZ_CHR_ID = P_To_Chr_ID
9989: AND oksCT.DNZ_CHR_ID = P_From_Chr_ID;

Line 10016: ,OKS_COVERAGE_TIMEZONES oksCTZ

10012: ,oksCT.PROGRAM_UPDATE_DATE AS oksCT_PROGRAM_UPDATE_DATE
10013: ,oksCT.REQUEST_ID AS oksCT_REQUEST_ID
10014: FROM
10015: OKS_COVERAGE_TIMES oksCT
10016: ,OKS_COVERAGE_TIMEZONES oksCTZ
10017: ,OKC_K_LINES_B_TEMP okcBT
10018: WHERE
10019: OksCT.COV_TZE_LINE_ID = oksCTZ.ORIG_SYSTEM_ID1
10020: AND oksCTZ.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 19805: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------

19801: --================End of Billing Schedule copy===============================
19802:
19803: --================Start of Coverage Schedule copy for Lines==================
19804:
19805: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
19806: Begin
19807: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
19808: ,P_To_Chr_ID => P_To_Chr_ID
19809: ,P_Partial_Copy_YN => 'N'

Line 19807: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID

19803: --================Start of Coverage Schedule copy for Lines==================
19804:
19805: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
19806: Begin
19807: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
19808: ,P_To_Chr_ID => P_To_Chr_ID
19809: ,P_Partial_Copy_YN => 'N'
19810: ,x_return_status => l_return_status);
19811: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 25077: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------

25073:
25074: --================Start of Coverage Schedule copy for Lines==================
25075:
25076: IF (P_Lines_Tbl.COUNT > 0) then
25077: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
25078: Begin
25079: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25080: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25081: FND_LOG.string(FND_LOG.level_statement

Line 25082: ,l_module_name||'.copy_oks_coverage_timezones'

25078: Begin
25079: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25080: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25081: FND_LOG.string(FND_LOG.level_statement
25082: ,l_module_name||'.copy_oks_coverage_timezones'
25083: ,'Before call to copy_oks_coverage_timezones'
25084: );
25085: END IF;
25086: END IF;

Line 25083: ,'Before call to copy_oks_coverage_timezones'

25079: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25080: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25081: FND_LOG.string(FND_LOG.level_statement
25082: ,l_module_name||'.copy_oks_coverage_timezones'
25083: ,'Before call to copy_oks_coverage_timezones'
25084: );
25085: END IF;
25086: END IF;
25087:

Line 25088: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID

25084: );
25085: END IF;
25086: END IF;
25087:
25088: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
25089: ,P_To_Chr_ID => P_To_Chr_ID
25090: ,P_Partial_Copy_YN => 'Y'
25091: ,P_Lines_Count => P_Lines_Tbl.COUNT
25092: ,x_return_status => l_return_status);

Line 25097: ,l_module_name||'.copy_oks_coverage_timezones'

25093:
25094: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25095: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25096: FND_LOG.string(FND_LOG.level_statement
25097: ,l_module_name||'.copy_oks_coverage_timezones'
25098: ,'After call to copy_oks_coverage_timezones: x_return_status:'||l_return_status
25099: ||' '||SQLERRM
25100: );
25101: END IF;

Line 25098: ,'After call to copy_oks_coverage_timezones: x_return_status:'||l_return_status

25094: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25095: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25096: FND_LOG.string(FND_LOG.level_statement
25097: ,l_module_name||'.copy_oks_coverage_timezones'
25098: ,'After call to copy_oks_coverage_timezones: x_return_status:'||l_return_status
25099: ||' '||SQLERRM
25100: );
25101: END IF;
25102: END IF;