APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_OPERATION_LINES

Line 8977: -- copy_okc_operation_lines

8973: End copy_okc_contacts;
8974:
8975:
8976: --===================================================
8977: -- copy_okc_operation_lines
8978: -- Parameters: P_From_Chr_ID : Header ID of source contract
8979: -- P_To_Chr_ID : Header ID of target contract
8980: --====================================================
8981: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER

Line 8981: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER

8977: -- copy_okc_operation_lines
8978: -- Parameters: P_From_Chr_ID : Header ID of source contract
8979: -- P_To_Chr_ID : Header ID of target contract
8980: --====================================================
8981: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER
8982: ,P_To_Chr_ID IN NUMBER
8983: ,x_return_status OUT NOCOPY VARCHAR2) IS
8984:
8985: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_OPERATION_LINES';

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

8981: PROCEDURE copy_okc_operation_lines(P_From_Chr_ID IN NUMBER
8982: ,P_To_Chr_ID IN NUMBER
8983: ,x_return_status OUT NOCOPY VARCHAR2) IS
8984:
8985: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_OPERATION_LINES';
8986: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
8987:
8988: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8989:

Line 9050: INSERT INTO OKC_OPERATION_LINES(

9046: ,OkcOLRecTab.OkcOLACTIVE_YN
9047: LIMIT G_BULK_FETCH_LIMIT;
9048:
9049: FORALL i in OkcOLRecTab.OkcOLID.FIRST .. OkcOLRecTab.OkcOLID.LAST
9050: INSERT INTO OKC_OPERATION_LINES(
9051: ID
9052: ,SELECT_YN
9053: ,PROCESS_FLAG
9054: ,OIE_ID

Line 9104: UPDATE okc_operation_lines ola

9100:
9101: CLOSE GetOkcOLFull;
9102:
9103: --------Update of PARENT_OLE_ID for Operation Lines created for Top Lines----------------
9104: UPDATE okc_operation_lines ola
9105: set ola.PARENT_OLE_ID = (select olb.ID
9106: from okc_operation_lines olb
9107: where olb.SUBJECT_CHR_ID = P_To_Chr_ID
9108: and olb.SUBJECT_CLE_ID IS NULL)

Line 9106: from okc_operation_lines olb

9102:
9103: --------Update of PARENT_OLE_ID for Operation Lines created for Top Lines----------------
9104: UPDATE okc_operation_lines ola
9105: set ola.PARENT_OLE_ID = (select olb.ID
9106: from okc_operation_lines olb
9107: where olb.SUBJECT_CHR_ID = P_To_Chr_ID
9108: and olb.SUBJECT_CLE_ID IS NULL)
9109: where
9110: ola.SUBJECT_CHR_ID = P_To_Chr_ID

Line 9119: UPDATE okc_operation_lines ola

9115: okcb.DNZ_CHR_ID = P_To_Chr_ID
9116: AND okcb.CLE_ID IS NULL);
9117: ------------------------------------------------------------------------------------------
9118: --------Update of PARENT_OLE_ID for Operation Lines created for Sub Lines Lines-----------
9119: UPDATE okc_operation_lines ola
9120: set ola.PARENT_OLE_ID = (select olb.ID
9121: from okc_operation_lines olb
9122: where olb.SUBJECT_CLE_ID = (select b.CLE_ID from
9123: okc_k_lines_b b

Line 9121: from okc_operation_lines olb

9117: ------------------------------------------------------------------------------------------
9118: --------Update of PARENT_OLE_ID for Operation Lines created for Sub Lines Lines-----------
9119: UPDATE okc_operation_lines ola
9120: set ola.PARENT_OLE_ID = (select olb.ID
9121: from okc_operation_lines olb
9122: where olb.SUBJECT_CLE_ID = (select b.CLE_ID from
9123: okc_k_lines_b b
9124: where b.ID = ola.SUBJECT_CLE_ID
9125: )

Line 9148: End copy_okc_operation_lines;

9144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9146: RAISE;
9147:
9148: End copy_okc_operation_lines;
9149:
9150:
9151: --===================================================
9152: -- copy_oks_k_lines_tl

Line 19744: ,l_module_name||'.copy_okc_operation_lines'

19740: Begin
19741: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19742: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19743: FND_LOG.string(FND_LOG.level_statement
19744: ,l_module_name||'.copy_okc_operation_lines'
19745: ,'Before call to copy_okc_operation_lines'
19746: );
19747: END IF;
19748: END IF;

Line 19745: ,'Before call to copy_okc_operation_lines'

19741: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19742: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19743: FND_LOG.string(FND_LOG.level_statement
19744: ,l_module_name||'.copy_okc_operation_lines'
19745: ,'Before call to copy_okc_operation_lines'
19746: );
19747: END IF;
19748: END IF;
19749:

Line 19750: copy_okc_operation_lines(P_From_Chr_ID => P_From_Chr_ID

19746: );
19747: END IF;
19748: END IF;
19749:
19750: copy_okc_operation_lines(P_From_Chr_ID => P_From_Chr_ID
19751: ,P_To_Chr_ID => P_To_Chr_ID
19752: ,x_return_status => l_return_status);
19753:
19754: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 19757: ,l_module_name||'.copy_okc_operation_lines'

19753:
19754: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19755: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19756: FND_LOG.string(FND_LOG.level_statement
19757: ,l_module_name||'.copy_okc_operation_lines'
19758: ,'After call to copy_okc_operation_lines: x_return_status:'||l_return_status
19759: ||' '||SQLERRM
19760: );
19761: END IF;

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

19754: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19755: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19756: FND_LOG.string(FND_LOG.level_statement
19757: ,l_module_name||'.copy_okc_operation_lines'
19758: ,'After call to copy_okc_operation_lines: x_return_status:'||l_return_status
19759: ||' '||SQLERRM
19760: );
19761: END IF;
19762: END IF;