APPS.OKC_TERMS_COPY_PVT dependencies on FND_PROFILE

Line 1193: -- fnd_profile.get('ORG_ID',l_current_org_id);

1189: FETCH l_get_article_org_csr INTO l_article_org_id;
1190: CLOSE l_get_article_org_csr;
1191:
1192: -- current Org Id
1193: -- fnd_profile.get('ORG_ID',l_current_org_id);
1194: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_target_doc_type, p_target_doc_id);
1195:
1196: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1197: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);

Line 1340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Profile OKC_GLOBAL_ORG_ID : '||fnd_profile.value('OKC_GLOBAL_ORG_ID'));

1336: AND l_standard_yn='Y' THEN
1337:
1338: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1339: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Template To Template Copy l_global_yn : '||l_global_yn);
1340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Profile OKC_GLOBAL_ORG_ID : '||fnd_profile.value('OKC_GLOBAL_ORG_ID'));
1341: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100:Target Template org_id : '||l_org_id);
1342: END IF;
1343:
1344: IF l_global_yn = 'Y'

Line 1345: AND nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'?') <> l_org_id THEN

1341: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100:Target Template org_id : '||l_org_id);
1342: END IF;
1343:
1344: IF l_global_yn = 'Y'
1345: AND nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'?') <> l_org_id THEN
1346:
1347: OPEN l_get_local_article_csr(sav_sae_tbl(i),l_org_id);
1348: FETCH l_get_local_article_csr INTO l_local_article_rec;
1349:

Line 1818: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')

1814: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1815: AND nvl(AMENDMENT_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1816: AND nvl(SUMMARY_AMEND_OPERATION_CODE,'?')<>G_AMEND_CODE_DELETED
1817: AND (( l_scn_drp_action = 'DROP_AMEND_SEC' AND
1818: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')
1819: ) OR
1820: (
1821: l_scn_drp_action = 'DROP_PROV_SEC' AND
1822: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE

Line 1883: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')

1879: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1880: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1881: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
1882: AND (( l_scn_drp_action = 'DROP_AMEND_SEC' AND
1883: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')
1884: ) OR
1885: (
1886: l_scn_drp_action = 'DROP_PROV_SEC' AND
1887: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE

Line 2996: SELECT UPPER(FND_PROFILE.VALUE('OKC_USE_CONTRACTS_RULES_ENGINE')) INTO l_cntrcts_ruls_eng_exists FROM DUAL;

2992: END IF;
2993:
2994:
2995: BEGIN
2996: SELECT UPPER(FND_PROFILE.VALUE('OKC_USE_CONTRACTS_RULES_ENGINE')) INTO l_cntrcts_ruls_eng_exists FROM DUAL;
2997: EXCEPTION
2998: WHEN OTHERS THEN
2999: l_cntrcts_ruls_eng_exists := 'N';
3000: END;

Line 3401: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

3397: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3398: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Update the existing OKC_TEMPLATE_USAGES record with new template id : '||p_source_doc_id);
3399: END IF;
3400:
3401: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
3402:
3403: --Added in 10+ word integration, update values for contract_source_code and authoring_party_code
3404: UPDATE OKC_TEMPLATE_USAGES
3405: SET TEMPLATE_ID = p_source_doc_id,