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_TIMES

Line 9988: -- copy_oks_coverage_times

9984:
9985:
9986: -----------------------------------------------------------
9987: --===================================================
9988: -- copy_oks_coverage_times
9989: -- Parameters: P_From_Chr_ID : Header ID of source contract
9990: -- P_To_Chr_ID : Header ID of target contract
9991: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9992: -- or as part of component copy from UI (value = 'Y')

Line 9995: PROCEDURE copy_oks_coverage_times(P_From_Chr_ID IN NUMBER

9991: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9992: -- or as part of component copy from UI (value = 'Y')
9993: --====================================================
9994:
9995: PROCEDURE copy_oks_coverage_times(P_From_Chr_ID IN NUMBER
9996: ,P_To_Chr_ID IN NUMBER
9997: ,P_Partial_Copy_YN IN VARCHAR2
9998: ,P_Lines_Count IN NUMBER DEFAULT 0
9999: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 10001: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMES';

9997: ,P_Partial_Copy_YN IN VARCHAR2
9998: ,P_Lines_Count IN NUMBER DEFAULT 0
9999: ,x_return_status OUT NOCOPY VARCHAR2) IS
10000:
10001: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMES';
10002: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
10003: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10004:
10005: CURSOR GetOksCTFull IS

Line 10029: OKS_COVERAGE_TIMES oksCT

10025: ,oksCT.PROGRAM_ID AS oksCT_PROGRAM_ID
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

Line 10060: OKS_COVERAGE_TIMES oksCT

10056: ,oksCT.PROGRAM_ID AS oksCT_PROGRAM_ID
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

Line 10131: INSERT INTO OKS_COVERAGE_TIMES(

10127:
10128: End If;
10129:
10130: FORALL i in OksCTRecTab.OksCT_NewID.FIRST .. OksCTRecTab.OksCT_NewID.LAST
10131: INSERT INTO OKS_COVERAGE_TIMES(
10132: ID
10133: ,DNZ_CHR_ID
10134: ,COV_TZE_LINE_ID
10135: ,START_HOUR

Line 10212: End copy_oks_coverage_times;

10208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
10210: RAISE;
10211:
10212: End copy_oks_coverage_times;
10213:
10214: -----------------------------------------------------------
10215: --===================================================
10216: -- copy_oks_pm_activities

Line 19964: -------------Copy of OKS_COVERAGE_TIMES-----------------------------

19960: End If;
19961: End;
19962: ---------------------------------------------------------------------
19963:
19964: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
19965: Begin
19966: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
19967: ,P_To_Chr_ID => P_To_Chr_ID
19968: ,P_Partial_Copy_YN => 'N'

Line 19966: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID

19962: ---------------------------------------------------------------------
19963:
19964: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
19965: Begin
19966: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
19967: ,P_To_Chr_ID => P_To_Chr_ID
19968: ,P_Partial_Copy_YN => 'N'
19969: ,x_return_status => l_return_status);
19970: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 25304: -------------Copy of OKS_COVERAGE_TIMES-----------------------------

25300: RAISE G_EXCEPTION_HALT_VALIDATION;
25301: End If;
25302: End;
25303: ---------------------------------------------------------------------
25304: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
25305: Begin
25306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25307: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25308: FND_LOG.string(FND_LOG.level_statement

Line 25309: ,l_module_name||'.copy_oks_coverage_times'

25305: Begin
25306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25307: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25308: FND_LOG.string(FND_LOG.level_statement
25309: ,l_module_name||'.copy_oks_coverage_times'
25310: ,'Before call to copy_oks_coverage_times'
25311: );
25312: END IF;
25313: END IF;

Line 25310: ,'Before call to copy_oks_coverage_times'

25306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25307: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25308: FND_LOG.string(FND_LOG.level_statement
25309: ,l_module_name||'.copy_oks_coverage_times'
25310: ,'Before call to copy_oks_coverage_times'
25311: );
25312: END IF;
25313: END IF;
25314:

Line 25315: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID

25311: );
25312: END IF;
25313: END IF;
25314:
25315: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
25316: ,P_To_Chr_ID => P_To_Chr_ID
25317: ,P_Partial_Copy_YN => 'Y'
25318: ,P_Lines_Count => P_Lines_Tbl.COUNT
25319: ,x_return_status => l_return_status);

Line 25324: ,l_module_name||'.copy_oks_coverage_times'

25320:
25321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25322: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25323: FND_LOG.string(FND_LOG.level_statement
25324: ,l_module_name||'.copy_oks_coverage_times'
25325: ,'After call to copy_oks_coverage_times: x_return_status:'||l_return_status
25326: ||' '||SQLERRM
25327: );
25328: END IF;

Line 25325: ,'After call to copy_oks_coverage_times: x_return_status:'||l_return_status

25321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25322: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25323: FND_LOG.string(FND_LOG.level_statement
25324: ,l_module_name||'.copy_oks_coverage_times'
25325: ,'After call to copy_oks_coverage_times: x_return_status:'||l_return_status
25326: ||' '||SQLERRM
25327: );
25328: END IF;
25329: END IF;