eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_K_ENTITY_LOCKS

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 224: 'SELECT LOCK_by_document_type, LOCK_by_document_id FROM okc_k_entity_locks WHERE entity_name = '

220: l_document_type VARCHAR2 (240);
221: l_document_id NUMBER;
222: BEGIN
223: l_chk_sql :=
224: 'SELECT LOCK_by_document_type, LOCK_by_document_id FROM okc_k_entity_locks WHERE entity_name = '
225: || ''''
226: || p_entity_name
227: || ''''
228: || ' and entity_pk1 = '

Line 329: FROM okc_k_entity_locks

325: CURSOR cur_lock_exists
326: IS
327: SELECT lock_by_entity_id, lock_by_document_type,
328: lock_by_document_id
329: FROM okc_k_entity_locks
330: WHERE entity_name = p_entity_name
331: AND entity_pk1 = p_entity_pk1
332: ;
333:

Line 372: INSERT INTO okc_k_entity_locks

368: END IF;
369:
370: IF p_entity_name = 'DUMMYSEC' THEN
371: x_return_status := g_ret_sts_success;
372: INSERT INTO okc_k_entity_locks
373: (k_entity_lock_id, entity_name, entity_pk1, entity_pk2,
374: entity_pk3, entity_pk4, entity_pk5, lock_by_entity_id,
375: lock_by_document_type, lock_by_document_id,
376: object_version_number, created_by, creation_date,

Line 378: SELECT okc_k_entity_locks_s.NEXTVAL, p_entity_name, p_entity_pk1,

374: entity_pk3, entity_pk4, entity_pk5, lock_by_entity_id,
375: lock_by_document_type, lock_by_document_id,
376: object_version_number, created_by, creation_date,
377: last_updated_by, last_update_date, last_update_login)
378: SELECT okc_k_entity_locks_s.NEXTVAL, p_entity_name, p_entity_pk1,
379: p_entity_pk2, p_entity_pk3, p_entity_pk4, p_entity_pk5,
380: p_lock_by_entity_id, p_lock_by_document_type, p_lock_by_document_id,
381: 1, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
382: fnd_global.login_id

Line 386: FROM okc_k_entity_locks

382: fnd_global.login_id
383: FROM DUAL
384: WHERE NOT EXISTS (
385: SELECT 'Y'
386: FROM okc_k_entity_locks
387: WHERE entity_name = p_entity_name
388: AND lock_by_document_type = p_lock_by_document_type
389: AND lock_by_document_id = p_lock_by_document_id
390: AND lock_by_entity_id = p_lock_by_entity_id);

Line 453: okc_k_entity_locks_pkg.insert_row

449: RETURN;
450: END IF;
451:
452: -- Call the Package Handler to insert the Row
453: okc_k_entity_locks_pkg.insert_row
454: (p_entity_name => p_entity_name,
455: p_entity_pk1 => p_entity_pk1,
456: p_entity_pk2 => p_entity_pk2,
457: p_entity_pk3 => p_entity_pk3,

Line 610: okc_k_entity_locks klock -- Locks Table

606: FROM okc_k_articles_b SOURCE -- Modification Doc
607: ,
608: okc_k_articles_b target -- Base Doc
609: ,
610: okc_k_entity_locks klock -- Locks Table
611: WHERE SOURCE.document_type = p_update_from_doc_type
612: AND SOURCE.document_id = p_update_from_doc_id
613: AND target.document_type = p_update_to_doc_type
614: AND target.document_id = p_update_to_doc_id

Line 626: okc_k_entity_locks klock -- Locks Table

622: FROM okc_sections_b SOURCE -- Modification Doc
623: ,
624: okc_sections_b target -- Base Doc
625: ,
626: okc_k_entity_locks klock -- Locks Table
627: WHERE SOURCE.document_type = p_update_from_doc_type
628: AND SOURCE.document_id = p_update_from_doc_id
629: AND target.document_type = p_update_to_doc_type
630: AND target.document_id = p_update_to_doc_id

Line 642: okc_k_entity_locks klock -- Locks Table

638: FROM okc_sections_b SOURCE -- Modification Doc
639: ,
640: okc_sections_b target -- Base Doc
641: ,
642: okc_k_entity_locks klock -- Locks Table
643: WHERE SOURCE.document_type = p_update_from_doc_type
644: AND SOURCE.document_id = p_update_from_doc_id
645: AND target.document_type = p_update_to_doc_type
646: AND target.document_id = p_update_to_doc_id

Line 659: okc_k_entity_locks klock -- Locks Table

655: FROM okc_deliverables SOURCE -- Modification Doc
656: ,
657: okc_deliverables target -- Base Doc
658: ,
659: okc_k_entity_locks klock -- Locks Table
660: WHERE SOURCE.business_document_type = p_update_from_doc_type
661: AND SOURCE.business_document_id = p_update_from_doc_id
662: AND target.business_document_type = p_update_to_doc_type
663: AND target.business_document_id = p_update_to_doc_id

Line 692: UPDATE okc_k_entity_locks

688:
689: CLOSE c_clauses;
690:
691: FORALL i IN l_old_clause_id_tbl.FIRST .. l_old_clause_id_tbl.LAST
692: UPDATE okc_k_entity_locks
693: SET entity_pk1 = TO_CHAR (l_new_clause_id_tbl (i)),
694: last_updated_by = fnd_global.user_id,
695: last_update_date = SYSDATE,
696: last_update_login = fnd_global.login_id

Line 715: UPDATE okc_k_entity_locks

711:
712: CLOSE c_sections;
713:
714: FORALL i IN l_old_scn_id_tbl.FIRST .. l_old_scn_id_tbl.LAST
715: UPDATE okc_k_entity_locks
716: SET entity_pk1 = l_new_scn_id_tbl (i)
717: WHERE entity_pk1 = l_old_scn_id_tbl (i) AND entity_name = G_SECTION_ENTITY;
718:
719: FORALL i IN l_new_scn_id_tbl.first..l_new_scn_id_tbl.LAST

Line 733: UPDATE okc_k_entity_locks

729: CLOSE c_Dummysections;
730:
731:
732: FORALL i IN l_old_scn_id_tbl.FIRST .. l_old_scn_id_tbl.LAST
733: UPDATE okc_k_entity_locks
734: SET entity_pk1 = l_new_scn_id_tbl (i)
735: WHERE entity_pk1 = l_old_scn_id_tbl (i)
736: AND entity_name = 'DUMMYSEC';
737:

Line 748: UPDATE okc_k_entity_locks

744:
745: CLOSE c_deliverables;
746:
747: FORALL i IN l_old_dlvbl_id_tbl.FIRST .. l_old_dlvbl_id_tbl.LAST
748: UPDATE okc_k_entity_locks
749: SET entity_pk1 = TO_CHAR (l_new_dlvbl_id_tbl (i)),
750: last_updated_by = fnd_global.user_id,
751: last_update_date = SYSDATE,
752: last_update_login = fnd_global.login_id

Line 785: DELETE FROM okc_k_entity_locks

781: )
782: IS
783: l_api_version CONSTANT NUMBER := 1;
784: BEGIN
785: DELETE FROM okc_k_entity_locks
786: WHERE lock_by_document_type = p_doc_type
787: AND lock_by_document_id = p_doc_id;
788:
789: -- Standard check of p_commit

Line 810: FROM okc_k_entity_locks

806: IS
807: CURSOR c_lock_exists
808: IS
809: SELECT 'Y'
810: FROM okc_k_entity_locks
811: WHERE entity_name = p_entity_name
812: AND lock_by_document_type = p_lock_by_document_type
813: AND lock_by_document_id = p_lock_by_document_id;
814:

Line 884: okc_k_entity_locks_pkg.delete_row

880:
881: -- Initialize API return status to success
882: x_return_status := fnd_api.g_ret_sts_success;
883: -- Calling simple API to delete the row
884: okc_k_entity_locks_pkg.delete_row
885: (p_entity_name => p_entity_name,
886: p_entity_pk1 => p_entity_pk1,
887: p_entity_pk2 => p_entity_pk2,
888: p_entity_pk3 => p_entity_pk3,

Line 1550: DELETE FROM okc_k_entity_locks

1546: CLOSE cur_lock_on_clauses;
1547:
1548: if l_clause_tbl.count > 0 then
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);

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 2550: DELETE FROM okc_k_entity_locks

2546: );
2547: END IF;
2548:
2549: -- Delete the lock from the table
2550: DELETE FROM okc_k_entity_locks
2551: WHERE k_entity_lock_id = p_K_ENTITY_LOCK_ID;
2552:
2553: -- Standard check of p_commit
2554: IF fnd_api.to_boolean (p_commit)

Line 2789: FROM OKC_K_ENTITY_LOCKS

2785:
2786: CURSOR cur_lock_details
2787: IS
2788: SELECT entity_name, entity_pk1, entity_pk2, entity_pk3, entity_pk4, entity_pk5, lock_by_entity_id, lock_by_document_type, lock_by_document_id
2789: FROM OKC_K_ENTITY_LOCKS
2790: WHERE k_entity_lock_id = p_k_entity_lock_id;
2791:
2792: lock_details_rec cur_lock_details%rowtype;
2793: BEGIN

Line 2828: FROM okc_k_entity_locks

2824: l_lock_exists VARCHAR2(1);
2825: BEGIN
2826: SELECT 'Y'
2827: INTO l_lock_exists
2828: FROM okc_k_entity_locks
2829: WHERE entity_name=G_CLAUSE_ENTITY
2830: AND entity_pk1=To_Char(p_src_kart_id)
2831: AND lock_by_document_id <> p_tgt_document_id;
2832:

Line 2906: FROM okc_k_entity_locks

2902: END IF;
2903:
2904: SELECT lock_by_document_type,lock_by_document_id
2905: INTO l_lock_by_doc_type,l_lock_by_document_id
2906: FROM okc_k_entity_locks
2907: WHERE entity_name=p_entity_name
2908: AND entity_pk1=To_Char(p_src_entity_id);
2909:
2910: IF l_lock_by_doc_type = p_tgt_document_type AND l_lock_by_document_id = p_tgt_document_id THEN

Line 2932: FROM okc_k_entity_locks

2928: l_lock_exists VARCHAR2(1);
2929: BEGIN
2930: SELECT 'Y'
2931: INTO l_lock_exists
2932: FROM okc_k_entity_locks
2933: WHERE entity_name=G_SECTION_ENTITY
2934: AND entity_pk1=To_Char(p_src_ksec_id)
2935: AND lock_by_document_id <> p_tgt_document_id;
2936:

Line 2953: FROM okc_k_entity_locks

2949: l_lock_exists VARCHAR2(1);
2950: BEGIN
2951: SELECT 'Y'
2952: INTO l_lock_exists
2953: FROM okc_k_entity_locks
2954: WHERE entity_name='DELIVERABLE'
2955: AND entity_pk1=To_Char(p_src_dlvbl_id)
2956: AND lock_by_document_id <> p_tgt_document_id;
2957:

Line 2995: FROM okc_k_entity_locks

2991: END IF;
2992:
2993: SELECT 'Y'
2994: INTO l_lock_exists
2995: FROM okc_k_entity_locks
2996: WHERE entity_name='XPRT'
2997: AND entity_pk1= To_Char(l_src_doc_id)
2998: AND entity_pk2 = l_src_doc_type
2999: AND lock_by_document_id <> p_tgt_document_id;

Line 3024: FROM okc_k_entity_locks lck

3020: AND k.document_type = p_tgt_document_type
3021: AND k.document_id = p_tgt_document_id
3022: AND k.orig_system_reference_code = 'COPY'
3023: AND EXISTS (SELECT 'Lock Exists'
3024: FROM okc_k_entity_locks lck
3025: WHERE lck.entity_name=G_CLAUSE_ENTITY
3026: AND lck.entity_pk1 = To_Char(k.orig_system_reference_id1)
3027: AND lock_by_document_id <> p_tgt_document_id)
3028: ;

Line 3077: FROM okc_k_entity_locks

3073: BEGIN
3074:
3075: SELECT 'Y'
3076: INTO l_lock_exists
3077: FROM okc_k_entity_locks
3078: WHERE entity_name='XPRT'
3079: AND entity_pk1=To_Char(l_src_doc_id)
3080: AND entity_pk2=l_src_doc_type
3081: AND lock_by_document_id <> p_doc_id;

Line 3100: FROM okc_k_entity_locks lck, okc_sections_b sec

3096: x_return_status := G_RET_STS_SUCCESS;
3097: -- Check for sections
3098: SELECT 'Y'
3099: INTO l_lock_exists
3100: FROM okc_k_entity_locks lck, okc_sections_b sec
3101: WHERE lck.entity_name=G_SECTION_ENTITY
3102: AND lck.entity_pk1= To_Char(sec.id)
3103: AND sec.document_type= l_src_doc_type
3104: AND sec.document_id= l_src_doc_id

Line 3124: FROM okc_k_entity_locks lck, okc_k_articles_b kart

3120: BEGIN
3121: -- check for clauses
3122: SELECT 'Y'
3123: INTO l_lock_exists
3124: FROM okc_k_entity_locks lck, okc_k_articles_b kart
3125: WHERE lck.entity_name=G_CLAUSE_ENTITY
3126: AND lck.entity_pk1= To_Char(kart.id)
3127: AND kart.document_type= l_src_doc_type
3128: AND kart.document_id= l_src_doc_id

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 3671: ) src, okc_k_entity_locks LcK

3667: WHERE business_document_type= p_doc_type
3668: AND business_document_id = p_doc_id
3669: AND business_document_version = -99
3670: AND summary_amend_operation_code IN ('UPDATED','DELETED')
3671: ) src, okc_k_entity_locks LcK
3672: WHERE lck.entity_name = src. entity
3673: AND lck.entity_pk1 = To_Char(orig_system_reference_id1)
3674: AND ROWNUM=1;
3675:

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;