DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_TL

Line 8524: -- copy_okc_k_party_roles_tl

8520:
8521: End create_vendor_if_missing;
8522: ---------------------------------------------------------------------------------
8523: --===================================================
8524: -- copy_okc_k_party_roles_tl
8525: -- Parameters: P_From_Chr_ID : Header ID of source contract
8526: -- P_To_Chr_ID : Header ID of target contract
8527: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8528: -- or as part of component copy from UI (value = 'Y')

Line 8530: PROCEDURE copy_okc_k_party_roles_tl(P_From_Chr_ID IN NUMBER

8526: -- P_To_Chr_ID : Header ID of target contract
8527: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8528: -- or as part of component copy from UI (value = 'Y')
8529: --====================================================
8530: PROCEDURE copy_okc_k_party_roles_tl(P_From_Chr_ID IN NUMBER
8531: ,P_To_Chr_ID IN NUMBER
8532: ,P_Partial_Copy_YN IN VARCHAR2
8533: ,P_Lines_Count IN NUMBER DEFAULT 0
8534: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 8551: OKC_K_PARTY_ROLES_TL okcPRTL

8547: ,okcPRTL.COGNOMEN AS okcPRTL_COGNOMEN
8548: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8549: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8550: FROM
8551: OKC_K_PARTY_ROLES_TL okcPRTL
8552: ,OKC_K_PARTY_ROLES_B okcPRB
8553: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8554: AND okcPRB.DNZ_CHR_ID = P_To_Chr_ID;
8555:

Line 8567: OKC_K_PARTY_ROLES_TL okcPRTL

8563: ,okcPRTL.COGNOMEN AS okcPRTL_COGNOMEN
8564: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8565: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8566: FROM
8567: OKC_K_PARTY_ROLES_TL okcPRTL
8568: ,OKC_K_PARTY_ROLES_B okcPRB
8569: ,OKC_K_LINES_B_TEMP okcBT
8570: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8571: AND okcPRB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 8622: INSERT INTO OKC_K_PARTY_ROLES_TL(

8618: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID LIMIT G_BULK_FETCH_LIMIT;
8619: End If;
8620:
8621: FORALL i IN OkcPRTLRecTab.OkcPRTL_NewID.FIRST .. OkcPRTLRecTab.OkcPRTL_NewID.LAST
8622: INSERT INTO OKC_K_PARTY_ROLES_TL(
8623: ID
8624: ,LANGUAGE
8625: ,SOURCE_LANG
8626: ,SFWT_FLAG

Line 8676: End copy_okc_k_party_roles_tl;

8672: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
8673: RAISE;
8674:
8675:
8676: End copy_okc_k_party_roles_tl;
8677:
8678:
8679: --===================================================
8680: -- copy_okc_contacts

Line 19516: ,l_module_name||'.copy_okc_k_party_roles_tl'

19512: Begin
19513: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19514: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19515: FND_LOG.string(FND_LOG.level_statement
19516: ,l_module_name||'.copy_okc_k_party_roles_tl'
19517: ,'Before call to copy_okc_k_party_roles_tl'
19518: );
19519: END IF;
19520: END IF;

Line 19517: ,'Before call to copy_okc_k_party_roles_tl'

19513: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19514: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19515: FND_LOG.string(FND_LOG.level_statement
19516: ,l_module_name||'.copy_okc_k_party_roles_tl'
19517: ,'Before call to copy_okc_k_party_roles_tl'
19518: );
19519: END IF;
19520: END IF;
19521: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19521: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

19517: ,'Before call to copy_okc_k_party_roles_tl'
19518: );
19519: END IF;
19520: END IF;
19521: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID
19522: ,P_To_Chr_ID => P_To_Chr_ID
19523: ,P_Partial_Copy_YN => 'N'
19524: ,x_return_status => l_return_status);
19525:

Line 19529: ,l_module_name||'.copy_okc_k_party_roles_tl'

19525:
19526: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19527: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19528: FND_LOG.string(FND_LOG.level_statement
19529: ,l_module_name||'.copy_okc_k_party_roles_tl'
19530: ,'After call to copy_okc_party_roles_tl: x_return_status:'||l_return_status
19531: ||' '||SQLERRM
19532: );
19533: END IF;

Line 24884: ,l_module_name||'.copy_okc_k_party_roles_tl'

24880: Begin
24881: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24882: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24883: FND_LOG.string(FND_LOG.level_statement
24884: ,l_module_name||'.copy_okc_k_party_roles_tl'
24885: ,'Before call to copy_okc_k_party_roles_tl'
24886: );
24887: END IF;
24888: END IF;

Line 24885: ,'Before call to copy_okc_k_party_roles_tl'

24881: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24882: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24883: FND_LOG.string(FND_LOG.level_statement
24884: ,l_module_name||'.copy_okc_k_party_roles_tl'
24885: ,'Before call to copy_okc_k_party_roles_tl'
24886: );
24887: END IF;
24888: END IF;
24889: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

Line 24889: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

24885: ,'Before call to copy_okc_k_party_roles_tl'
24886: );
24887: END IF;
24888: END IF;
24889: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID
24890: ,P_To_Chr_ID => P_To_Chr_ID
24891: ,P_Partial_Copy_YN => 'Y'
24892: ,P_Lines_Count => P_Lines_Tbl.COUNT
24893: ,x_return_status => l_return_status);

Line 24898: ,l_module_name||'.copy_okc_k_party_roles_tl'

24894:
24895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24896: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24897: FND_LOG.string(FND_LOG.level_statement
24898: ,l_module_name||'.copy_okc_k_party_roles_tl'
24899: ,'After call to copy_okc_k_party_roles_tl: x_return_status:'||l_return_status
24900: ||' '||SQLERRM
24901: );
24902: END IF;

Line 24899: ,'After call to copy_okc_k_party_roles_tl: x_return_status:'||l_return_status

24895: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24896: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24897: FND_LOG.string(FND_LOG.level_statement
24898: ,l_module_name||'.copy_okc_k_party_roles_tl'
24899: ,'After call to copy_okc_k_party_roles_tl: x_return_status:'||l_return_status
24900: ||' '||SQLERRM
24901: );
24902: END IF;
24903: END IF;