DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_K_LINES_TL

Line 9152: -- copy_oks_k_lines_tl

9148: End copy_okc_operation_lines;
9149:
9150:
9151: --===================================================
9152: -- copy_oks_k_lines_tl
9153: -- Parameters: P_From_Chr_ID : Header ID of source contract
9154: -- P_To_Chr_ID : Header ID of target contract
9155: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9156: -- or as part of component copy from UI (value = 'Y')

Line 9158: PROCEDURE copy_oks_k_lines_tl(P_From_Chr_ID IN NUMBER

9154: -- P_To_Chr_ID : Header ID of target contract
9155: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9156: -- or as part of component copy from UI (value = 'Y')
9157: --====================================================
9158: PROCEDURE copy_oks_k_lines_tl(P_From_Chr_ID IN NUMBER
9159: ,P_To_Chr_ID IN NUMBER
9160: ,P_Partial_Copy_YN IN VARCHAR2
9161: ,P_Lines_Count IN NUMBER DEFAULT 0
9162: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

9160: ,P_Partial_Copy_YN IN VARCHAR2
9161: ,P_Lines_Count IN NUMBER DEFAULT 0
9162: ,x_return_status OUT NOCOPY VARCHAR2) IS
9163:
9164: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_K_LINES_TL';
9165: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9166:
9167: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9168: CURSOR GetOksTLFull IS

Line 9181: OKS_K_LINES_TL oksTL

9177: , oksTL.STATUS_TEXT AS oksTL_STATUS_TEXT
9178: , oksTL.REACT_TIME_NAME AS oksTL_REACT_TIME_NAME
9179: , oksTL.SECURITY_GROUP_ID AS oksTL_SECURITY_GROUP_ID
9180: FROM
9181: OKS_K_LINES_TL oksTL
9182: ,OKS_K_LINES_B oksB
9183: WHERE oksTL.ID = oksB.ORIG_SYSTEM_ID1
9184: AND oksB.DNZ_CHR_ID = P_To_Chr_ID;
9185:

Line 9199: OKS_K_LINES_TL oksTL

9195: , oksTL.STATUS_TEXT AS oksTL_STATUS_TEXT
9196: , oksTL.REACT_TIME_NAME AS oksTL_REACT_TIME_NAME
9197: , oksTL.SECURITY_GROUP_ID AS oksTL_SECURITY_GROUP_ID
9198: FROM
9199: OKS_K_LINES_TL oksTL
9200: ,OKS_K_LINES_B oksB
9201: ,OKC_K_LINES_B_TEMP okcBT
9202: WHERE oksTL.ID = oksB.ORIG_SYSTEM_ID1
9203: AND oksB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 9244: INSERT INTO OKS_K_LINES_TL(

9240: , OksTLRecTab.OksTL_SECURITY_GROUP_ID LIMIT G_BULK_FETCH_LIMIT;
9241: End If;
9242:
9243: FORALL i IN OksTLRecTab.OksTL_NewID.FIRST .. OksTLRecTab.OksTL_NewID.LAST
9244: INSERT INTO OKS_K_LINES_TL(
9245: ID
9246: , LANGUAGE
9247: , SOURCE_LANG
9248: , SFWT_FLAG

Line 9304: END copy_oks_k_lines_tl;

9300: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9301: RAISE;
9302:
9303:
9304: END copy_oks_k_lines_tl;
9305:
9306: --===================================================
9307: -- copy_oks_rev_distributions
9308: -- Parameters: P_From_Chr_ID : Header ID of source contract

Line 19631: ------------Copy of OKS_K_LINES_TL---------------------------------

19627: RAISE G_EXCEPTION_HALT_VALIDATION;
19628: End If;
19629: End;
19630: --------------------------------------------------------------------
19631: ------------Copy of OKS_K_LINES_TL---------------------------------
19632: Begin
19633: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19634: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19635: FND_LOG.string(FND_LOG.level_statement

Line 19636: ,l_module_name||'.copy_oks_k_lines_tl'

19632: Begin
19633: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19634: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19635: FND_LOG.string(FND_LOG.level_statement
19636: ,l_module_name||'.copy_oks_k_lines_tl'
19637: ,'Before call to copy_oks_k_lines_tl'
19638: );
19639: END IF;
19640: END IF;

Line 19637: ,'Before call to copy_oks_k_lines_tl'

19633: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19634: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19635: FND_LOG.string(FND_LOG.level_statement
19636: ,l_module_name||'.copy_oks_k_lines_tl'
19637: ,'Before call to copy_oks_k_lines_tl'
19638: );
19639: END IF;
19640: END IF;
19641: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19641: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

19637: ,'Before call to copy_oks_k_lines_tl'
19638: );
19639: END IF;
19640: END IF;
19641: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
19642: ,P_To_Chr_ID => P_To_Chr_ID
19643: ,P_Partial_Copy_YN => 'N'
19644: ,x_return_status => l_return_status);
19645:

Line 19649: ,l_module_name||'.copy_oks_k_lines_tl'

19645:
19646: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19647: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19648: FND_LOG.string(FND_LOG.level_statement
19649: ,l_module_name||'.copy_oks_k_lines_tl'
19650: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
19651: ||' '||SQLERRM
19652: );
19653: END IF;

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

19646: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19647: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19648: FND_LOG.string(FND_LOG.level_statement
19649: ,l_module_name||'.copy_oks_k_lines_tl'
19650: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
19651: ||' '||SQLERRM
19652: );
19653: END IF;
19654: END IF;

Line 25008: ------------Copy of OKS_K_LINES_TL---------------------------------

25004: RAISE G_EXCEPTION_HALT_VALIDATION;
25005: End If;
25006: End;
25007: --------------------------------------------------------------------
25008: ------------Copy of OKS_K_LINES_TL---------------------------------
25009: IF (P_Lines_Tbl.COUNT > 0) then
25010: Begin
25011: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25012: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 25014: ,l_module_name||'.copy_oks_k_lines_tl'

25010: Begin
25011: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25012: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25013: FND_LOG.string(FND_LOG.level_statement
25014: ,l_module_name||'.copy_oks_k_lines_tl'
25015: ,'Before call to copy_oks_k_lines_tl'
25016: );
25017: END IF;
25018: END IF;

Line 25015: ,'Before call to copy_oks_k_lines_tl'

25011: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25012: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25013: FND_LOG.string(FND_LOG.level_statement
25014: ,l_module_name||'.copy_oks_k_lines_tl'
25015: ,'Before call to copy_oks_k_lines_tl'
25016: );
25017: END IF;
25018: END IF;
25019: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 25019: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

25015: ,'Before call to copy_oks_k_lines_tl'
25016: );
25017: END IF;
25018: END IF;
25019: copy_oks_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
25020: ,P_To_Chr_ID => P_To_Chr_ID
25021: ,P_Partial_Copy_YN => 'Y'
25022: ,P_Lines_Count => P_Lines_Tbl.COUNT
25023: ,x_return_status => l_return_status);

Line 25028: ,l_module_name||'.copy_oks_k_lines_tl'

25024:
25025: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25026: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25027: FND_LOG.string(FND_LOG.level_statement
25028: ,l_module_name||'.copy_oks_k_lines_tl'
25029: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
25030: ||' '||SQLERRM
25031: );
25032: END IF;

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

25025: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25026: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25027: FND_LOG.string(FND_LOG.level_statement
25028: ,l_module_name||'.copy_oks_k_lines_tl'
25029: ,'After call to copy_oks_k_lines_tl: x_return_status:'||l_return_status
25030: ||' '||SQLERRM
25031: );
25032: END IF;
25033: END IF;