DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_LINES_TL

Line 3977: -- copy_okc_k_lines_tl

3973:
3974: End GenerateNewLineNumber;
3975:
3976: --===================================================
3977: -- copy_okc_k_lines_tl
3978: -- Parameters: P_From_Chr_ID : Header ID of source contract
3979: -- P_To_Chr_ID : Header ID of target contract
3980: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
3981: -- or as part of component copy from UI (value = 'Y')

Line 3983: PROCEDURE copy_okc_k_lines_tl(P_From_Chr_ID IN NUMBER

3979: -- P_To_Chr_ID : Header ID of target contract
3980: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
3981: -- or as part of component copy from UI (value = 'Y')
3982: --====================================================
3983: PROCEDURE copy_okc_k_lines_tl(P_From_Chr_ID IN NUMBER
3984: ,P_To_Chr_ID IN NUMBER
3985: ,P_Partial_Copy_YN IN VARCHAR2
3986: ,P_Lines_Count IN NUMBER DEFAULT 0
3987: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 3989: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_K_LINES_TL';

3985: ,P_Partial_Copy_YN IN VARCHAR2
3986: ,P_Lines_Count IN NUMBER DEFAULT 0
3987: ,x_return_status OUT NOCOPY VARCHAR2) IS
3988:
3989: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_K_LINES_TL';
3990: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
3991:
3992: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3993:

Line 4009: OKC_K_LINES_TL okcTL

4005: ,OkcTL.SECURITY_GROUP_ID AS OkcTL_SECURITY_GROUP_ID
4006: ,OkcTL.OKE_BOE_DESCRIPTION AS OkcTL_OKE_BOE_DESCRIPTION
4007: ,OkcTL.COGNOMEN AS OkcTL_COGNOMEN
4008: FROM
4009: OKC_K_LINES_TL okcTL
4010: ,OKC_K_LINES_B okcB
4011: where
4012: okcB.ORIG_SYSTEM_ID1 = okcTL.ID
4013: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;

Line 4030: OKC_K_LINES_TL okcTL

4026: ,OkcTL.SECURITY_GROUP_ID AS OkcTL_SECURITY_GROUP_ID
4027: ,OkcTL.OKE_BOE_DESCRIPTION AS OkcTL_OKE_BOE_DESCRIPTION
4028: ,OkcTL.COGNOMEN AS OkcTL_COGNOMEN
4029: FROM
4030: OKC_K_LINES_TL okcTL
4031: ,OKC_K_LINES_B_TEMP okcBT
4032: where
4033: okcBT.ORIG_SYSTEM_ID1 = okcTL.ID
4034: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;

Line 4101: INSERT INTO OKC_K_LINES_TL

4097: ,OKCLinesTLRecTab.OkcTL_COGNOMEN LIMIT G_BULK_FETCH_LIMIT;
4098: END IF;
4099:
4100: FORALL i IN OKCLinesTLRecTab.OkcTL_NewID.FIRST .. OKCLinesTLRecTab.OkcTL_NewID.LAST
4101: INSERT INTO OKC_K_LINES_TL
4102: (
4103: ID
4104: ,LANGUAGE
4105: ,SOURCE_LANG

Line 4164: End copy_okc_k_lines_tl;

4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
4162: RAISE;
4163:
4164: End copy_okc_k_lines_tl;
4165:
4166:
4167: --===================================================
4168: -- copy_okc_price_att_values

Line 19450: ------------Copy of OKC_K_LINES_TL--------------------------------------------------

19446: End If;
19447: End;
19448:
19449: ------------------------------------------------------------------------------------
19450: ------------Copy of OKC_K_LINES_TL--------------------------------------------------
19451: Begin
19452: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19453: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19454: FND_LOG.string(FND_LOG.level_statement

Line 19455: ,l_module_name||'.copy_okc_k_lines_tl'

19451: Begin
19452: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19453: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19454: FND_LOG.string(FND_LOG.level_statement
19455: ,l_module_name||'.copy_okc_k_lines_tl'
19456: ,'Before call to copy_okc_k_lines_tl'
19457: );
19458: END IF;
19459: END IF;

Line 19456: ,'Before call to copy_okc_k_lines_tl'

19452: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19453: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19454: FND_LOG.string(FND_LOG.level_statement
19455: ,l_module_name||'.copy_okc_k_lines_tl'
19456: ,'Before call to copy_okc_k_lines_tl'
19457: );
19458: END IF;
19459: END IF;
19460: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19460: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

19456: ,'Before call to copy_okc_k_lines_tl'
19457: );
19458: END IF;
19459: END IF;
19460: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
19461: ,P_To_Chr_ID => P_To_Chr_ID
19462: ,P_Partial_Copy_YN => 'N'
19463: ,x_return_status => l_return_status);
19464:

Line 19468: ,l_module_name||'.copy_okc_k_lines_tl'

19464:
19465: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19466: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19467: FND_LOG.string(FND_LOG.level_statement
19468: ,l_module_name||'.copy_okc_k_lines_tl'
19469: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
19470: ||' '||SQLERRM
19471: );
19472: END IF;

Line 19469: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status

19465: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19466: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19467: FND_LOG.string(FND_LOG.level_statement
19468: ,l_module_name||'.copy_okc_k_lines_tl'
19469: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
19470: ||' '||SQLERRM
19471: );
19472: END IF;
19473: END IF;

Line 24810: ------------Copy of OKC_K_LINES_TL--------------------------------------------------

24806: End;
24807: END IF;
24808: -------------------------------------------------------------------------------------
24809:
24810: ------------Copy of OKC_K_LINES_TL--------------------------------------------------
24811: IF (P_Lines_Tbl.COUNT > 0) then
24812: Begin
24813: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24814: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24816: ,l_module_name||'.copy_okc_k_lines_tl'

24812: Begin
24813: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24814: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24815: FND_LOG.string(FND_LOG.level_statement
24816: ,l_module_name||'.copy_okc_k_lines_tl'
24817: ,'Before call to copy_okc_k_lines_tl'
24818: );
24819: END IF;
24820: END IF;

Line 24817: ,'Before call to copy_okc_k_lines_tl'

24813: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24814: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24815: FND_LOG.string(FND_LOG.level_statement
24816: ,l_module_name||'.copy_okc_k_lines_tl'
24817: ,'Before call to copy_okc_k_lines_tl'
24818: );
24819: END IF;
24820: END IF;
24821: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 24821: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

24817: ,'Before call to copy_okc_k_lines_tl'
24818: );
24819: END IF;
24820: END IF;
24821: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
24822: ,P_To_Chr_ID => P_To_Chr_ID
24823: ,P_Partial_Copy_YN => 'Y'
24824: ,P_Lines_Count => P_Lines_Tbl.COUNT
24825: ,x_return_status => l_return_status);

Line 24830: ,l_module_name||'.copy_okc_k_lines_tl'

24826:
24827: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24828: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24829: FND_LOG.string(FND_LOG.level_statement
24830: ,l_module_name||'.copy_okc_k_lines_tl'
24831: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
24832: ||' '||SQLERRM
24833: );
24834: END IF;

Line 24831: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status

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