APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_OPERATION_LINES

Line 8932: -- copy_okc_operation_lines

8928: End copy_okc_contacts;
8929:
8930:
8931: --===================================================
8932: -- copy_okc_operation_lines
8933: -- Parameters: P_From_Chr_ID : Header ID of source contract
8934: -- P_To_Chr_ID : Header ID of target contract
8935: --====================================================
8936: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER

Line 8936: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER

8932: -- copy_okc_operation_lines
8933: -- Parameters: P_From_Chr_ID : Header ID of source contract
8934: -- P_To_Chr_ID : Header ID of target contract
8935: --====================================================
8936: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER
8937: ,P_To_Chr_ID IN NUMBER
8938: ,x_return_status OUT NOCOPY VARCHAR2) IS
8939:
8940: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_OPERATION_LINES';

Line 8940: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_OPERATION_LINES';

8936: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER
8937: ,P_To_Chr_ID IN NUMBER
8938: ,x_return_status OUT NOCOPY VARCHAR2) IS
8939:
8940: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_OPERATION_LINES';
8941: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
8942:
8943: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8944:

Line 9005: INSERT INTO OKC_OPERATION_LINES(

9001: ,OkcOLRecTab.OkcOLACTIVE_YN
9002: LIMIT G_BULK_FETCH_LIMIT;
9003:
9004: FORALL i in OkcOLRecTab.OkcOLID.FIRST .. OkcOLRecTab.OkcOLID.LAST
9005: INSERT INTO OKC_OPERATION_LINES(
9006: ID
9007: ,SELECT_YN
9008: ,PROCESS_FLAG
9009: ,OIE_ID

Line 9059: UPDATE okc_operation_lines ola

9055:
9056: CLOSE GetOkcOLFull;
9057:
9058: --------Update of PARENT_OLE_ID for Operation Lines created for Top Lines----------------
9059: UPDATE okc_operation_lines ola
9060: set ola.PARENT_OLE_ID = (select olb.ID
9061: from okc_operation_lines olb
9062: where olb.SUBJECT_CHR_ID = P_To_Chr_ID
9063: and olb.SUBJECT_CLE_ID IS NULL)

Line 9061: from okc_operation_lines olb

9057:
9058: --------Update of PARENT_OLE_ID for Operation Lines created for Top Lines----------------
9059: UPDATE okc_operation_lines ola
9060: set ola.PARENT_OLE_ID = (select olb.ID
9061: from okc_operation_lines olb
9062: where olb.SUBJECT_CHR_ID = P_To_Chr_ID
9063: and olb.SUBJECT_CLE_ID IS NULL)
9064: where
9065: ola.SUBJECT_CHR_ID = P_To_Chr_ID

Line 9074: UPDATE okc_operation_lines ola

9070: okcb.DNZ_CHR_ID = P_To_Chr_ID
9071: AND okcb.CLE_ID IS NULL);
9072: ------------------------------------------------------------------------------------------
9073: --------Update of PARENT_OLE_ID for Operation Lines created for Sub Lines Lines-----------
9074: UPDATE okc_operation_lines ola
9075: set ola.PARENT_OLE_ID = (select olb.ID
9076: from okc_operation_lines olb
9077: where olb.SUBJECT_CLE_ID = (select b.CLE_ID from
9078: okc_k_lines_b b

Line 9076: from okc_operation_lines olb

9072: ------------------------------------------------------------------------------------------
9073: --------Update of PARENT_OLE_ID for Operation Lines created for Sub Lines Lines-----------
9074: UPDATE okc_operation_lines ola
9075: set ola.PARENT_OLE_ID = (select olb.ID
9076: from okc_operation_lines olb
9077: where olb.SUBJECT_CLE_ID = (select b.CLE_ID from
9078: okc_k_lines_b b
9079: where b.ID = ola.SUBJECT_CLE_ID
9080: )

Line 9103: End copy_okc_operation_lines;

9099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9101: RAISE;
9102:
9103: End copy_okc_operation_lines;
9104:
9105:
9106: --===================================================
9107: -- copy_oks_k_lines_tl

Line 19597: ,l_module_name||'.copy_okc_operation_lines'

19593: Begin
19594: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19595: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19596: FND_LOG.string(FND_LOG.level_statement
19597: ,l_module_name||'.copy_okc_operation_lines'
19598: ,'Before call to copy_okc_operation_lines'
19599: );
19600: END IF;
19601: END IF;

Line 19598: ,'Before call to copy_okc_operation_lines'

19594: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19595: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19596: FND_LOG.string(FND_LOG.level_statement
19597: ,l_module_name||'.copy_okc_operation_lines'
19598: ,'Before call to copy_okc_operation_lines'
19599: );
19600: END IF;
19601: END IF;
19602:

Line 19603: copy_okc_operation_lines(P_From_Chr_ID => P_From_Chr_ID

19599: );
19600: END IF;
19601: END IF;
19602:
19603: copy_okc_operation_lines(P_From_Chr_ID => P_From_Chr_ID
19604: ,P_To_Chr_ID => P_To_Chr_ID
19605: ,x_return_status => l_return_status);
19606:
19607: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 19610: ,l_module_name||'.copy_okc_operation_lines'

19606:
19607: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19608: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19609: FND_LOG.string(FND_LOG.level_statement
19610: ,l_module_name||'.copy_okc_operation_lines'
19611: ,'After call to copy_okc_operation_lines: x_return_status:'||l_return_status
19612: ||' '||SQLERRM
19613: );
19614: END IF;

Line 19611: ,'After call to copy_okc_operation_lines: x_return_status:'||l_return_status

19607: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19608: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19609: FND_LOG.string(FND_LOG.level_statement
19610: ,l_module_name||'.copy_okc_operation_lines'
19611: ,'After call to copy_okc_operation_lines: x_return_status:'||l_return_status
19612: ||' '||SQLERRM
19613: );
19614: END IF;
19615: END IF;