DBA Data[Home] [Help]

APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_K_ENTITY_LOCKS_GRP

Line 1: PACKAGE BODY okc_k_entity_locks_grp

1: PACKAGE BODY okc_k_entity_locks_grp
2: /* $Header: OKCGELKB.pls 120.2.12020000.6 2013/03/26 08:51:55 skavutha ship $ */
3: AS
4: l_debug VARCHAR2 (1)
5: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');

Line 14: := 'OKC_K_ENTITY_LOCKS_GRP';

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: g_pkg_name CONSTANT VARCHAR2 (200)
14: := 'OKC_K_ENTITY_LOCKS_GRP';
15: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
16:
17: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: ------------------------------------------------------------------------------

Line 1553: AND entity_name = okc_k_entity_locks_grp.g_clause_entity

1549: FORALL i IN l_clause_tbl.FIRST .. l_clause_tbl.LAST
1550: DELETE FROM okc_k_entity_locks
1551: WHERE lock_by_document_type = p_target_document_type
1552: AND lock_by_document_id = p_target_document_id
1553: AND entity_name = okc_k_entity_locks_grp.g_clause_entity
1554: AND entity_pk1 = l_clause_tbl (i);
1555: end if;
1556: --------------------------------------------
1557: -- Delete contract expert suggested clauses

Line 2497: IF p_entity_name = okc_k_entity_locks_grp.g_clause_entity

2493:
2494: -- Initialize API return status to success
2495: x_return_status := fnd_api.g_ret_sts_success;
2496:
2497: IF p_entity_name = okc_k_entity_locks_grp.g_clause_entity
2498: THEN
2499: refresh_clause (p_source_doc_clause_id => TO_NUMBER
2500: (p_entity_pk1),
2501: p_target_document_type => p_lock_by_document_type,

Line 2508: ELSIF p_entity_name = okc_k_entity_locks_grp.g_section_entity

2504: x_return_status => x_return_status,
2505: x_msg_count => x_msg_count,
2506: x_msg_data => x_msg_data
2507: );
2508: ELSIF p_entity_name = okc_k_entity_locks_grp.g_section_entity
2509: THEN
2510: refresh_section (p_source_section_id => TO_NUMBER
2511: (p_entity_pk1),
2512: p_target_document_type => p_lock_by_document_type,

Line 2519: ELSIF p_entity_name = okc_k_entity_locks_grp.g_xprt_entity

2515: x_return_status => x_return_status,
2516: x_msg_count => x_msg_count,
2517: x_msg_data => x_msg_data
2518: );
2519: ELSIF p_entity_name = okc_k_entity_locks_grp.g_xprt_entity
2520: THEN
2521: refresh_xprt (p_target_document_type => p_lock_by_document_type,
2522: p_target_document_id => p_lock_by_document_id,
2523: x_return_status => x_return_status,

Line 2527: ELSIF p_entity_name = okc_k_entity_locks_grp.G_DLVBL_ENTITY

2523: x_return_status => x_return_status,
2524: x_msg_count => x_msg_count,
2525: x_msg_data => x_msg_data
2526: );
2527: ELSIF p_entity_name = okc_k_entity_locks_grp.G_DLVBL_ENTITY
2528: THEN
2529: refresh_deliverable(
2530: p_source_deliverable_id => TO_NUMBER
2531: (p_entity_pk1),

Line 3431: '100: Inside OKC_K_ENTITY_LOCKS_GRP.REBUILD_IDS'

3427:
3428: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3429: THEN
3430: fnd_log.STRING (fnd_log.level_statement, G_MODULE||l_api_name,
3431: '100: Inside OKC_K_ENTITY_LOCKS_GRP.REBUILD_IDS'
3432: );
3433:
3434: fnd_log.STRING (fnd_log.level_statement, G_MODULE||l_api_name,
3435: '100: p_update_from_doc_type : ' || p_update_from_doc_type

Line 3959: END okc_k_entity_locks_grp;

3955: );
3956: END IF;
3957: RAISE;
3958: END merge_changes;
3959: END okc_k_entity_locks_grp;