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.

[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_K_LINES_TL

Line 9107: -- copy_oks_k_lines_tl

9103: End copy_okc_operation_lines;
9104:
9105:
9106: --===================================================
9107: -- copy_oks_k_lines_tl
9108: -- Parameters: P_From_Chr_ID : Header ID of source contract
9109: -- P_To_Chr_ID : Header ID of target contract
9110: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9111: -- or as part of component copy from UI (value = 'Y')

Line 9113: PROCEDURE copy_oks_k_lines_tl(P_From_Chr_ID IN NUMBER

9109: -- P_To_Chr_ID : Header ID of target contract
9110: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9111: -- or as part of component copy from UI (value = 'Y')
9112: --====================================================
9113: PROCEDURE copy_oks_k_lines_tl(P_From_Chr_ID IN NUMBER
9114: ,P_To_Chr_ID IN NUMBER
9115: ,P_Partial_Copy_YN IN VARCHAR2
9116: ,P_Lines_Count IN NUMBER DEFAULT 0
9117: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 9119: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_K_LINES_TL';

9115: ,P_Partial_Copy_YN IN VARCHAR2
9116: ,P_Lines_Count IN NUMBER DEFAULT 0
9117: ,x_return_status OUT NOCOPY VARCHAR2) IS
9118:
9119: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_K_LINES_TL';
9120: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9121:
9122: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9123: CURSOR GetOksTLFull IS

Line 9136: OKS_K_LINES_TL oksTL

9132: , oksTL.STATUS_TEXT AS oksTL_STATUS_TEXT
9133: , oksTL.REACT_TIME_NAME AS oksTL_REACT_TIME_NAME
9134: , oksTL.SECURITY_GROUP_ID AS oksTL_SECURITY_GROUP_ID
9135: FROM
9136: OKS_K_LINES_TL oksTL
9137: ,OKS_K_LINES_B oksB
9138: WHERE oksTL.ID = oksB.ORIG_SYSTEM_ID1
9139: AND oksB.DNZ_CHR_ID = P_To_Chr_ID;
9140:

Line 9154: OKS_K_LINES_TL oksTL

9150: , oksTL.STATUS_TEXT AS oksTL_STATUS_TEXT
9151: , oksTL.REACT_TIME_NAME AS oksTL_REACT_TIME_NAME
9152: , oksTL.SECURITY_GROUP_ID AS oksTL_SECURITY_GROUP_ID
9153: FROM
9154: OKS_K_LINES_TL oksTL
9155: ,OKS_K_LINES_B oksB
9156: ,OKC_K_LINES_B_TEMP okcBT
9157: WHERE oksTL.ID = oksB.ORIG_SYSTEM_ID1
9158: AND oksB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 9199: INSERT INTO OKS_K_LINES_TL(

9195: , OksTLRecTab.OksTL_SECURITY_GROUP_ID LIMIT G_BULK_FETCH_LIMIT;
9196: End If;
9197:
9198: FORALL i IN OksTLRecTab.OksTL_NewID.FIRST .. OksTLRecTab.OksTL_NewID.LAST
9199: INSERT INTO OKS_K_LINES_TL(
9200: ID
9201: , LANGUAGE
9202: , SOURCE_LANG
9203: , SFWT_FLAG

Line 9259: END copy_oks_k_lines_tl;

9255: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9256: RAISE;
9257:
9258:
9259: END copy_oks_k_lines_tl;
9260:
9261: --===================================================
9262: -- copy_oks_rev_distributions
9263: -- Parameters: P_From_Chr_ID : Header ID of source contract

Line 19484: ------------Copy of OKS_K_LINES_TL---------------------------------

19480: RAISE G_EXCEPTION_HALT_VALIDATION;
19481: End If;
19482: End;
19483: --------------------------------------------------------------------
19484: ------------Copy of OKS_K_LINES_TL---------------------------------
19485: Begin
19486: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19487: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19488: FND_LOG.string(FND_LOG.level_statement

Line 19489: ,l_module_name||'.copy_oks_k_lines_tl'

19485: Begin
19486: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19487: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19488: FND_LOG.string(FND_LOG.level_statement
19489: ,l_module_name||'.copy_oks_k_lines_tl'
19490: ,'Before call to copy_oks_k_lines_tl'
19491: );
19492: END IF;
19493: END IF;

Line 19490: ,'Before call to copy_oks_k_lines_tl'

19486: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19487: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19488: FND_LOG.string(FND_LOG.level_statement
19489: ,l_module_name||'.copy_oks_k_lines_tl'
19490: ,'Before call to copy_oks_k_lines_tl'
19491: );
19492: END IF;
19493: END IF;
19494: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19494: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

19490: ,'Before call to copy_oks_k_lines_tl'
19491: );
19492: END IF;
19493: END IF;
19494: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
19495: ,P_To_Chr_ID => P_To_Chr_ID
19496: ,P_Partial_Copy_YN => 'N'
19497: ,x_return_status => l_return_status);
19498:

Line 19502: ,l_module_name||'.copy_oks_k_lines_tl'

19498:
19499: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19500: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19501: FND_LOG.string(FND_LOG.level_statement
19502: ,l_module_name||'.copy_oks_k_lines_tl'
19503: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
19504: ||' '||SQLERRM
19505: );
19506: END IF;

Line 19503: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status

19499: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19500: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19501: FND_LOG.string(FND_LOG.level_statement
19502: ,l_module_name||'.copy_oks_k_lines_tl'
19503: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
19504: ||' '||SQLERRM
19505: );
19506: END IF;
19507: END IF;

Line 24813: ------------Copy of OKS_K_LINES_TL---------------------------------

24809: RAISE G_EXCEPTION_HALT_VALIDATION;
24810: End If;
24811: End;
24812: --------------------------------------------------------------------
24813: ------------Copy of OKS_K_LINES_TL---------------------------------
24814: IF (P_Lines_Tbl.COUNT > 0) then
24815: Begin
24816: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24817: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24819: ,l_module_name||'.copy_oks_k_lines_tl'

24815: Begin
24816: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24817: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24818: FND_LOG.string(FND_LOG.level_statement
24819: ,l_module_name||'.copy_oks_k_lines_tl'
24820: ,'Before call to copy_oks_k_lines_tl'
24821: );
24822: END IF;
24823: END IF;

Line 24820: ,'Before call to copy_oks_k_lines_tl'

24816: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24817: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24818: FND_LOG.string(FND_LOG.level_statement
24819: ,l_module_name||'.copy_oks_k_lines_tl'
24820: ,'Before call to copy_oks_k_lines_tl'
24821: );
24822: END IF;
24823: END IF;
24824: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 24824: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

24820: ,'Before call to copy_oks_k_lines_tl'
24821: );
24822: END IF;
24823: END IF;
24824: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
24825: ,P_To_Chr_ID => P_To_Chr_ID
24826: ,P_Partial_Copy_YN => 'Y'
24827: ,P_Lines_Count => P_Lines_Tbl.COUNT
24828: ,x_return_status => l_return_status);

Line 24833: ,l_module_name||'.copy_oks_k_lines_tl'

24829:
24830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24831: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24832: FND_LOG.string(FND_LOG.level_statement
24833: ,l_module_name||'.copy_oks_k_lines_tl'
24834: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
24835: ||' '||SQLERRM
24836: );
24837: END IF;

Line 24834: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status

24830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24831: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24832: FND_LOG.string(FND_LOG.level_statement
24833: ,l_module_name||'.copy_oks_k_lines_tl'
24834: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
24835: ||' '||SQLERRM
24836: );
24837: END IF;
24838: END IF;