DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_LINES_TL

Line 3940: -- copy_okc_k_lines_tl

3936:
3937: End GenerateNewLineNumber;
3938:
3939: --===================================================
3940: -- copy_okc_k_lines_tl
3941: -- Parameters: P_From_Chr_ID : Header ID of source contract
3942: -- P_To_Chr_ID : Header ID of target contract
3943: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
3944: -- or as part of component copy from UI (value = 'Y')

Line 3946: PROCEDURE copy_okc_k_lines_tl(P_From_Chr_ID IN NUMBER

3942: -- P_To_Chr_ID : Header ID of target contract
3943: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
3944: -- or as part of component copy from UI (value = 'Y')
3945: --====================================================
3946: PROCEDURE copy_okc_k_lines_tl(P_From_Chr_ID IN NUMBER
3947: ,P_To_Chr_ID IN NUMBER
3948: ,P_Partial_Copy_YN IN VARCHAR2
3949: ,P_Lines_Count IN NUMBER DEFAULT 0
3950: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

3948: ,P_Partial_Copy_YN IN VARCHAR2
3949: ,P_Lines_Count IN NUMBER DEFAULT 0
3950: ,x_return_status OUT NOCOPY VARCHAR2) IS
3951:
3952: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_K_LINES_TL';
3953: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
3954:
3955: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3956:

Line 3972: OKC_K_LINES_TL okcTL

3968: ,OkcTL.SECURITY_GROUP_ID AS OkcTL_SECURITY_GROUP_ID
3969: ,OkcTL.OKE_BOE_DESCRIPTION AS OkcTL_OKE_BOE_DESCRIPTION
3970: ,OkcTL.COGNOMEN AS OkcTL_COGNOMEN
3971: FROM
3972: OKC_K_LINES_TL okcTL
3973: ,OKC_K_LINES_B okcB
3974: where
3975: okcB.ORIG_SYSTEM_ID1 = okcTL.ID
3976: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;

Line 3993: OKC_K_LINES_TL okcTL

3989: ,OkcTL.SECURITY_GROUP_ID AS OkcTL_SECURITY_GROUP_ID
3990: ,OkcTL.OKE_BOE_DESCRIPTION AS OkcTL_OKE_BOE_DESCRIPTION
3991: ,OkcTL.COGNOMEN AS OkcTL_COGNOMEN
3992: FROM
3993: OKC_K_LINES_TL okcTL
3994: ,OKC_K_LINES_B_TEMP okcBT
3995: where
3996: okcBT.ORIG_SYSTEM_ID1 = okcTL.ID
3997: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;

Line 4064: INSERT INTO OKC_K_LINES_TL

4060: ,OKCLinesTLRecTab.OkcTL_COGNOMEN LIMIT G_BULK_FETCH_LIMIT;
4061: END IF;
4062:
4063: FORALL i IN OKCLinesTLRecTab.OkcTL_NewID.FIRST .. OKCLinesTLRecTab.OkcTL_NewID.LAST
4064: INSERT INTO OKC_K_LINES_TL
4065: (
4066: ID
4067: ,LANGUAGE
4068: ,SOURCE_LANG

Line 4127: End copy_okc_k_lines_tl;

4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
4125: RAISE;
4126:
4127: End copy_okc_k_lines_tl;
4128:
4129:
4130: --===================================================
4131: -- copy_okc_price_att_values

Line 19303: ------------Copy of OKC_K_LINES_TL--------------------------------------------------

19299: End If;
19300: End;
19301:
19302: ------------------------------------------------------------------------------------
19303: ------------Copy of OKC_K_LINES_TL--------------------------------------------------
19304: Begin
19305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19306: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19307: FND_LOG.string(FND_LOG.level_statement

Line 19308: ,l_module_name||'.copy_okc_k_lines_tl'

19304: Begin
19305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19306: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19307: FND_LOG.string(FND_LOG.level_statement
19308: ,l_module_name||'.copy_okc_k_lines_tl'
19309: ,'Before call to copy_okc_k_lines_tl'
19310: );
19311: END IF;
19312: END IF;

Line 19309: ,'Before call to copy_okc_k_lines_tl'

19305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19306: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19307: FND_LOG.string(FND_LOG.level_statement
19308: ,l_module_name||'.copy_okc_k_lines_tl'
19309: ,'Before call to copy_okc_k_lines_tl'
19310: );
19311: END IF;
19312: END IF;
19313: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19313: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

19309: ,'Before call to copy_okc_k_lines_tl'
19310: );
19311: END IF;
19312: END IF;
19313: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
19314: ,P_To_Chr_ID => P_To_Chr_ID
19315: ,P_Partial_Copy_YN => 'N'
19316: ,x_return_status => l_return_status);
19317:

Line 19321: ,l_module_name||'.copy_okc_k_lines_tl'

19317:
19318: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19319: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19320: FND_LOG.string(FND_LOG.level_statement
19321: ,l_module_name||'.copy_okc_k_lines_tl'
19322: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
19323: ||' '||SQLERRM
19324: );
19325: END IF;

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

19318: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19319: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19320: FND_LOG.string(FND_LOG.level_statement
19321: ,l_module_name||'.copy_okc_k_lines_tl'
19322: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
19323: ||' '||SQLERRM
19324: );
19325: END IF;
19326: END IF;

Line 24615: ------------Copy of OKC_K_LINES_TL--------------------------------------------------

24611: End;
24612: END IF;
24613: -------------------------------------------------------------------------------------
24614:
24615: ------------Copy of OKC_K_LINES_TL--------------------------------------------------
24616: IF (P_Lines_Tbl.COUNT > 0) then
24617: Begin
24618: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24619: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24621: ,l_module_name||'.copy_okc_k_lines_tl'

24617: Begin
24618: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24619: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24620: FND_LOG.string(FND_LOG.level_statement
24621: ,l_module_name||'.copy_okc_k_lines_tl'
24622: ,'Before call to copy_okc_k_lines_tl'
24623: );
24624: END IF;
24625: END IF;

Line 24622: ,'Before call to copy_okc_k_lines_tl'

24618: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24619: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24620: FND_LOG.string(FND_LOG.level_statement
24621: ,l_module_name||'.copy_okc_k_lines_tl'
24622: ,'Before call to copy_okc_k_lines_tl'
24623: );
24624: END IF;
24625: END IF;
24626: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

Line 24626: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID

24622: ,'Before call to copy_okc_k_lines_tl'
24623: );
24624: END IF;
24625: END IF;
24626: copy_okc_k_lines_tl(P_From_Chr_ID => P_From_Chr_ID
24627: ,P_To_Chr_ID => P_To_Chr_ID
24628: ,P_Partial_Copy_YN => 'Y'
24629: ,P_Lines_Count => P_Lines_Tbl.COUNT
24630: ,x_return_status => l_return_status);

Line 24635: ,l_module_name||'.copy_okc_k_lines_tl'

24631:
24632: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24633: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24634: FND_LOG.string(FND_LOG.level_statement
24635: ,l_module_name||'.copy_okc_k_lines_tl'
24636: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
24637: ||' '||SQLERRM
24638: );
24639: END IF;

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

24632: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24633: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24634: FND_LOG.string(FND_LOG.level_statement
24635: ,l_module_name||'.copy_okc_k_lines_tl'
24636: ,'After call to copy_okc_k_lines_tl: x_return_status:'||l_return_status
24637: ||' '||SQLERRM
24638: );
24639: END IF;
24640: END IF;