DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_COVERAGE_TIMES

Line 9943: -- copy_oks_coverage_times

9939:
9940:
9941: -----------------------------------------------------------
9942: --===================================================
9943: -- copy_oks_coverage_times
9944: -- Parameters: P_From_Chr_ID : Header ID of source contract
9945: -- P_To_Chr_ID : Header ID of target contract
9946: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9947: -- or as part of component copy from UI (value = 'Y')

Line 9950: PROCEDURE copy_oks_coverage_times(P_From_Chr_ID IN NUMBER

9946: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9947: -- or as part of component copy from UI (value = 'Y')
9948: --====================================================
9949:
9950: PROCEDURE copy_oks_coverage_times(P_From_Chr_ID IN NUMBER
9951: ,P_To_Chr_ID IN NUMBER
9952: ,P_Partial_Copy_YN IN VARCHAR2
9953: ,P_Lines_Count IN NUMBER DEFAULT 0
9954: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

9952: ,P_Partial_Copy_YN IN VARCHAR2
9953: ,P_Lines_Count IN NUMBER DEFAULT 0
9954: ,x_return_status OUT NOCOPY VARCHAR2) IS
9955:
9956: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_COVERAGE_TIMES';
9957: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9958: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9959:
9960: CURSOR GetOksCTFull IS

Line 9984: OKS_COVERAGE_TIMES oksCT

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

Line 10015: OKS_COVERAGE_TIMES oksCT

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

Line 10086: INSERT INTO OKS_COVERAGE_TIMES(

10082:
10083: End If;
10084:
10085: FORALL i in OksCTRecTab.OksCT_NewID.FIRST .. OksCTRecTab.OksCT_NewID.LAST
10086: INSERT INTO OKS_COVERAGE_TIMES(
10087: ID
10088: ,DNZ_CHR_ID
10089: ,COV_TZE_LINE_ID
10090: ,START_HOUR

Line 10167: End copy_oks_coverage_times;

10163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
10165: RAISE;
10166:
10167: End copy_oks_coverage_times;
10168:
10169: -----------------------------------------------------------
10170: --===================================================
10171: -- copy_oks_pm_activities

Line 19817: -------------Copy of OKS_COVERAGE_TIMES-----------------------------

19813: End If;
19814: End;
19815: ---------------------------------------------------------------------
19816:
19817: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
19818: Begin
19819: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
19820: ,P_To_Chr_ID => P_To_Chr_ID
19821: ,P_Partial_Copy_YN => 'N'

Line 19819: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID

19815: ---------------------------------------------------------------------
19816:
19817: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
19818: Begin
19819: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
19820: ,P_To_Chr_ID => P_To_Chr_ID
19821: ,P_Partial_Copy_YN => 'N'
19822: ,x_return_status => l_return_status);
19823: If (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 25109: -------------Copy of OKS_COVERAGE_TIMES-----------------------------

25105: RAISE G_EXCEPTION_HALT_VALIDATION;
25106: End If;
25107: End;
25108: ---------------------------------------------------------------------
25109: -------------Copy of OKS_COVERAGE_TIMES-----------------------------
25110: Begin
25111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25112: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25113: FND_LOG.string(FND_LOG.level_statement

Line 25114: ,l_module_name||'.copy_oks_coverage_times'

25110: Begin
25111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25112: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25113: FND_LOG.string(FND_LOG.level_statement
25114: ,l_module_name||'.copy_oks_coverage_times'
25115: ,'Before call to copy_oks_coverage_times'
25116: );
25117: END IF;
25118: END IF;

Line 25115: ,'Before call to copy_oks_coverage_times'

25111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25112: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25113: FND_LOG.string(FND_LOG.level_statement
25114: ,l_module_name||'.copy_oks_coverage_times'
25115: ,'Before call to copy_oks_coverage_times'
25116: );
25117: END IF;
25118: END IF;
25119:

Line 25120: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID

25116: );
25117: END IF;
25118: END IF;
25119:
25120: copy_oks_coverage_times(P_From_Chr_ID => P_From_Chr_ID
25121: ,P_To_Chr_ID => P_To_Chr_ID
25122: ,P_Partial_Copy_YN => 'Y'
25123: ,P_Lines_Count => P_Lines_Tbl.COUNT
25124: ,x_return_status => l_return_status);

Line 25129: ,l_module_name||'.copy_oks_coverage_times'

25125:
25126: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25127: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25128: FND_LOG.string(FND_LOG.level_statement
25129: ,l_module_name||'.copy_oks_coverage_times'
25130: ,'After call to copy_oks_coverage_times: x_return_status:'||l_return_status
25131: ||' '||SQLERRM
25132: );
25133: END IF;

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

25126: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25127: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25128: FND_LOG.string(FND_LOG.level_statement
25129: ,l_module_name||'.copy_oks_coverage_times'
25130: ,'After call to copy_oks_coverage_times: x_return_status:'||l_return_status
25131: ||' '||SQLERRM
25132: );
25133: END IF;
25134: END IF;