DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_TL

Line 8487: -- copy_okc_k_party_roles_tl

8483:
8484: End create_vendor_if_missing;
8485: ---------------------------------------------------------------------------------
8486: --===================================================
8487: -- copy_okc_k_party_roles_tl
8488: -- Parameters: P_From_Chr_ID : Header ID of source contract
8489: -- P_To_Chr_ID : Header ID of target contract
8490: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8491: -- or as part of component copy from UI (value = 'Y')

Line 8493: PROCEDURE copy_okc_k_party_roles_tl(P_From_Chr_ID IN NUMBER

8489: -- P_To_Chr_ID : Header ID of target contract
8490: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8491: -- or as part of component copy from UI (value = 'Y')
8492: --====================================================
8493: PROCEDURE copy_okc_k_party_roles_tl(P_From_Chr_ID IN NUMBER
8494: ,P_To_Chr_ID IN NUMBER
8495: ,P_Partial_Copy_YN IN VARCHAR2
8496: ,P_Lines_Count IN NUMBER DEFAULT 0
8497: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 8514: OKC_K_PARTY_ROLES_TL okcPRTL

8510: ,okcPRTL.COGNOMEN AS okcPRTL_COGNOMEN
8511: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8512: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8513: FROM
8514: OKC_K_PARTY_ROLES_TL okcPRTL
8515: ,OKC_K_PARTY_ROLES_B okcPRB
8516: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8517: AND okcPRB.DNZ_CHR_ID = P_To_Chr_ID;
8518:

Line 8530: OKC_K_PARTY_ROLES_TL okcPRTL

8526: ,okcPRTL.COGNOMEN AS okcPRTL_COGNOMEN
8527: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8528: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8529: FROM
8530: OKC_K_PARTY_ROLES_TL okcPRTL
8531: ,OKC_K_PARTY_ROLES_B okcPRB
8532: ,OKC_K_LINES_B_TEMP okcBT
8533: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8534: AND okcPRB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 8585: INSERT INTO OKC_K_PARTY_ROLES_TL(

8581: ,OkcPRTLRecTab.OkcPRTL_SECURITY_GROUP_ID LIMIT G_BULK_FETCH_LIMIT;
8582: End If;
8583:
8584: FORALL i IN OkcPRTLRecTab.OkcPRTL_NewID.FIRST .. OkcPRTLRecTab.OkcPRTL_NewID.LAST
8585: INSERT INTO OKC_K_PARTY_ROLES_TL(
8586: ID
8587: ,LANGUAGE
8588: ,SOURCE_LANG
8589: ,SFWT_FLAG

Line 8639: End copy_okc_k_party_roles_tl;

8635: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
8636: RAISE;
8637:
8638:
8639: End copy_okc_k_party_roles_tl;
8640:
8641:
8642: --===================================================
8643: -- copy_okc_contacts

Line 19369: ,l_module_name||'.copy_okc_k_party_roles_tl'

19365: Begin
19366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19367: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19368: FND_LOG.string(FND_LOG.level_statement
19369: ,l_module_name||'.copy_okc_k_party_roles_tl'
19370: ,'Before call to copy_okc_k_party_roles_tl'
19371: );
19372: END IF;
19373: END IF;

Line 19370: ,'Before call to copy_okc_k_party_roles_tl'

19366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19367: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19368: FND_LOG.string(FND_LOG.level_statement
19369: ,l_module_name||'.copy_okc_k_party_roles_tl'
19370: ,'Before call to copy_okc_k_party_roles_tl'
19371: );
19372: END IF;
19373: END IF;
19374: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

Line 19374: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

19370: ,'Before call to copy_okc_k_party_roles_tl'
19371: );
19372: END IF;
19373: END IF;
19374: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID
19375: ,P_To_Chr_ID => P_To_Chr_ID
19376: ,P_Partial_Copy_YN => 'N'
19377: ,x_return_status => l_return_status);
19378:

Line 19382: ,l_module_name||'.copy_okc_k_party_roles_tl'

19378:
19379: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19380: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19381: FND_LOG.string(FND_LOG.level_statement
19382: ,l_module_name||'.copy_okc_k_party_roles_tl'
19383: ,'After call to copy_okc_party_roles_tl: x_return_status:'||l_return_status
19384: ||' '||SQLERRM
19385: );
19386: END IF;

Line 24689: ,l_module_name||'.copy_okc_k_party_roles_tl'

24685: Begin
24686: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24687: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24688: FND_LOG.string(FND_LOG.level_statement
24689: ,l_module_name||'.copy_okc_k_party_roles_tl'
24690: ,'Before call to copy_okc_k_party_roles_tl'
24691: );
24692: END IF;
24693: END IF;

Line 24690: ,'Before call to copy_okc_k_party_roles_tl'

24686: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24687: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24688: FND_LOG.string(FND_LOG.level_statement
24689: ,l_module_name||'.copy_okc_k_party_roles_tl'
24690: ,'Before call to copy_okc_k_party_roles_tl'
24691: );
24692: END IF;
24693: END IF;
24694: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

Line 24694: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID

24690: ,'Before call to copy_okc_k_party_roles_tl'
24691: );
24692: END IF;
24693: END IF;
24694: copy_okc_k_party_roles_tl(P_From_Chr_ID => P_From_Chr_ID
24695: ,P_To_Chr_ID => P_To_Chr_ID
24696: ,P_Partial_Copy_YN => 'Y'
24697: ,P_Lines_Count => P_Lines_Tbl.COUNT
24698: ,x_return_status => l_return_status);

Line 24703: ,l_module_name||'.copy_okc_k_party_roles_tl'

24699:
24700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24701: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24702: FND_LOG.string(FND_LOG.level_statement
24703: ,l_module_name||'.copy_okc_k_party_roles_tl'
24704: ,'After call to copy_okc_k_party_roles_tl: x_return_status:'||l_return_status
24705: ||' '||SQLERRM
24706: );
24707: END IF;

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

24700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24701: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24702: FND_LOG.string(FND_LOG.level_statement
24703: ,l_module_name||'.copy_okc_k_party_roles_tl'
24704: ,'After call to copy_okc_k_party_roles_tl: x_return_status:'||l_return_status
24705: ||' '||SQLERRM
24706: );
24707: END IF;
24708: END IF;