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 9800: -- copy_oks_coverage_timezones

9796: End copy_oks_qualifiers;
9797:
9798: -----------------------------------------------------------
9799: --===================================================
9800: -- copy_oks_coverage_timezones
9801: -- Parameters: P_From_Chr_ID : Header ID of source contract
9802: -- P_To_Chr_ID : Header ID of target contract
9803: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9804: -- or as part of component copy from UI (value = 'Y')

Line 9807: PROCEDURE copy_oks_coverage_timezones(P_From_Chr_ID IN NUMBER

9803: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9804: -- or as part of component copy from UI (value = 'Y')
9805: --====================================================
9806:
9807: PROCEDURE copy_oks_coverage_timezones(P_From_Chr_ID IN NUMBER
9808: ,P_To_Chr_ID IN NUMBER
9809: ,P_Partial_Copy_YN IN VARCHAR2
9810: ,P_Lines_Count IN NUMBER DEFAULT 0
9811: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

9809: ,P_Partial_Copy_YN IN VARCHAR2
9810: ,P_Lines_Count IN NUMBER DEFAULT 0
9811: ,x_return_status OUT NOCOPY VARCHAR2) IS
9812:
9813: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMEZONES';
9814: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9815: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9816:
9817: CURSOR GetOksCTZFull IS

Line 9835: OKS_COVERAGE_TIMEZONES oksCTZ

9831: ,oksCTZ.ID AS oksCTZ_ORIG_SYSTEM_ID1 --*
9832: ,NULL AS oksCTZ_ORIG_SYSTEM_SOURCE_CODE --*
9833: ,'COPY' AS oksCTZ_ORIG_SYSTEM_REFERENCE1 --*
9834: FROM
9835: OKS_COVERAGE_TIMEZONES oksCTZ
9836: ,OKC_K_LINES_B okcB
9837: WHERE
9838: oksCTZ.CLE_ID = okcB.ORIG_SYSTEM_ID1
9839: AND oksCTZ.DNZ_CHR_ID = P_From_Chr_ID

Line 9860: OKS_COVERAGE_TIMEZONES oksCTZ

9856: ,oksCTZ.ID AS oksCTZ_ORIG_SYSTEM_ID1 --*
9857: ,NULL AS oksCTZ_ORIG_SYSTEM_SOURCE_CODE --*
9858: ,'COPY' AS oksCTZ_ORIG_SYSTEM_REFERENCE1 --*
9859: FROM
9860: OKS_COVERAGE_TIMEZONES oksCTZ
9861: ,OKC_K_LINES_B_TEMP okcBT
9862: WHERE
9863: oksCTZ.CLE_ID = okcBT.ORIG_SYSTEM_ID1
9864: AND oksCTZ.DNZ_CHR_ID = P_From_Chr_ID

Line 9916: INSERT INTO OKS_COVERAGE_TIMEZONES(

9912:
9913: End If;
9914:
9915: FORALL i IN OksCTZRecTab.OksCTZ_NewID.FIRST .. OksCTZRecTab.OksCTZ_NewID.LAST
9916: INSERT INTO OKS_COVERAGE_TIMEZONES(
9917: ID
9918: ,CLE_ID
9919: ,DEFAULT_YN
9920: ,TIMEZONE_ID

Line 9983: End copy_oks_coverage_timezones;

9979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9980: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9981: RAISE;
9982:
9983: End copy_oks_coverage_timezones;
9984:
9985:
9986: -----------------------------------------------------------
9987: --===================================================

Line 10030: ,OKS_COVERAGE_TIMEZONES oksCTZ

10026: ,oksCT.PROGRAM_UPDATE_DATE AS oksCT_PROGRAM_UPDATE_DATE
10027: ,oksCT.REQUEST_ID AS oksCT_REQUEST_ID
10028: FROM
10029: OKS_COVERAGE_TIMES oksCT
10030: ,OKS_COVERAGE_TIMEZONES oksCTZ
10031: WHERE
10032: OksCT.COV_TZE_LINE_ID = oksCTZ.ORIG_SYSTEM_ID1
10033: AND oksCTZ.DNZ_CHR_ID = P_To_Chr_ID
10034: AND oksCT.DNZ_CHR_ID = P_From_Chr_ID;

Line 10061: ,OKS_COVERAGE_TIMEZONES oksCTZ

10057: ,oksCT.PROGRAM_UPDATE_DATE AS oksCT_PROGRAM_UPDATE_DATE
10058: ,oksCT.REQUEST_ID AS oksCT_REQUEST_ID
10059: FROM
10060: OKS_COVERAGE_TIMES oksCT
10061: ,OKS_COVERAGE_TIMEZONES oksCTZ
10062: ,OKC_K_LINES_B_TEMP okcBT
10063: WHERE
10064: OksCT.COV_TZE_LINE_ID = oksCTZ.ORIG_SYSTEM_ID1
10065: AND oksCTZ.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 19952: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------

19948: --================End of Billing Schedule copy===============================
19949:
19950: --================Start of Coverage Schedule copy for Lines==================
19951:
19952: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
19953: Begin
19954: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
19955: ,P_To_Chr_ID => P_To_Chr_ID
19956: ,P_Partial_Copy_YN => 'N'

Line 19954: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID

19950: --================Start of Coverage Schedule copy for Lines==================
19951:
19952: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
19953: Begin
19954: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
19955: ,P_To_Chr_ID => P_To_Chr_ID
19956: ,P_Partial_Copy_YN => 'N'
19957: ,x_return_status => l_return_status);
19958: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 25272: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------

25268:
25269: --================Start of Coverage Schedule copy for Lines==================
25270:
25271: IF (P_Lines_Tbl.COUNT > 0) then
25272: -------------Copy of OKS_COVERAGE_TIMEZONES------------------------
25273: Begin
25274: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25275: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25276: FND_LOG.string(FND_LOG.level_statement

Line 25277: ,l_module_name||'.copy_oks_coverage_timezones'

25273: Begin
25274: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25275: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25276: FND_LOG.string(FND_LOG.level_statement
25277: ,l_module_name||'.copy_oks_coverage_timezones'
25278: ,'Before call to copy_oks_coverage_timezones'
25279: );
25280: END IF;
25281: END IF;

Line 25278: ,'Before call to copy_oks_coverage_timezones'

25274: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25275: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25276: FND_LOG.string(FND_LOG.level_statement
25277: ,l_module_name||'.copy_oks_coverage_timezones'
25278: ,'Before call to copy_oks_coverage_timezones'
25279: );
25280: END IF;
25281: END IF;
25282:

Line 25283: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID

25279: );
25280: END IF;
25281: END IF;
25282:
25283: copy_oks_coverage_timezones(P_From_Chr_ID => P_From_Chr_ID
25284: ,P_To_Chr_ID => P_To_Chr_ID
25285: ,P_Partial_Copy_YN => 'Y'
25286: ,P_Lines_Count => P_Lines_Tbl.COUNT
25287: ,x_return_status => l_return_status);

Line 25292: ,l_module_name||'.copy_oks_coverage_timezones'

25288:
25289: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25290: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25291: FND_LOG.string(FND_LOG.level_statement
25292: ,l_module_name||'.copy_oks_coverage_timezones'
25293: ,'After call to copy_oks_coverage_timezones: x_return_status:'||l_return_status
25294: ||' '||SQLERRM
25295: );
25296: END IF;

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

25289: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25290: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25291: FND_LOG.string(FND_LOG.level_statement
25292: ,l_module_name||'.copy_oks_coverage_timezones'
25293: ,'After call to copy_oks_coverage_timezones: x_return_status:'||l_return_status
25294: ||' '||SQLERRM
25295: );
25296: END IF;
25297: END IF;