APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_DELIVERABLES

Line 124: l_from_table := 'OKC_DELIVERABLES';

120: l_entity_pk2_column := 'DOCUMENT_TYPE';
121: l_entity_pk2_c := p_entity_pk2;
122: ELSIF p_entity_name = G_DLVBL_ENTITY
123: THEN
124: l_from_table := 'OKC_DELIVERABLES';
125: l_entity_pk1_column := 'DELIVERABLE_ID';
126: l_entity_pk1_n := TO_NUMBER (p_entity_pk1);
127: END IF;
128:

Line 655: FROM okc_deliverables SOURCE -- Modification Doc

651: -- Deliverables changes:
652: CURSOR c_deliverables
653: IS
654: SELECT SOURCE.orig_system_reference_id1 old_id, target.deliverable_id new_id , klock.LOCK_by_entity_id
655: FROM okc_deliverables SOURCE -- Modification Doc
656: ,
657: okc_deliverables target -- Base Doc
658: ,
659: okc_k_entity_locks klock -- Locks Table

Line 657: okc_deliverables target -- Base Doc

653: IS
654: SELECT SOURCE.orig_system_reference_id1 old_id, target.deliverable_id new_id , klock.LOCK_by_entity_id
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

Line 758: UPDATE OKC_DELIVERABLES

754: AND entity_name = G_DLVBL_ENTITY;
755:
756: -- Update the Lock By dleiverables with the correct orig_sys_ref.
757: FORALL i IN l_new_dlvbl_id_tbl.first..l_new_dlvbl_id_tbl.LAST
758: UPDATE OKC_DELIVERABLES
759: SET orig_system_reference_id1 = l_new_dlvbl_id_tbl(i)
760: WHERE deliverable_id = l_upd_dlvbl_id_tbl(i);
761: -- Standard check of p_commit
762: IF fnd_api.to_boolean (p_commit)

Line 2186: del_rec okc_deliverables%ROWTYPE;

2182: x_msg_data OUT NOCOPY VARCHAR2
2183: )
2184: IS
2185:
2186: del_rec okc_deliverables%ROWTYPE;
2187:
2188: CURSOR cur_del
2189: IS
2190: SELECT * FROM okc_deliverables WHERE deliverable_id= p_source_deliverable_id;

Line 2190: SELECT * FROM okc_deliverables WHERE deliverable_id= p_source_deliverable_id;

2186: del_rec okc_deliverables%ROWTYPE;
2187:
2188: CURSOR cur_del
2189: IS
2190: SELECT * FROM okc_deliverables WHERE deliverable_id= p_source_deliverable_id;
2191:
2192: l_new_target_del_id NUMBER;
2193: x_errorcode NUMBER;
2194: BEGIN

Line 2208: INSERT INTO okc_deliverables

2204: del_rec.orig_system_reference_code := 'COPY';
2205: del_rec.orig_system_reference_id1 := p_source_deliverable_id;
2206: END IF;
2207:
2208: INSERT INTO okc_deliverables
2209: (DELIVERABLE_ID,
2210: BUSINESS_DOCUMENT_TYPE ,
2211: BUSINESS_DOCUMENT_ID ,
2212: BUSINESS_DOCUMENT_NUMBER ,

Line 2422: DELETE FROM okc_deliverables

2418: END IF;
2419:
2420: -- Delete the p_target_deliverable_id
2421: IF p_target_deliverable_id IS NOT NULL THEN
2422: DELETE FROM okc_deliverables
2423: WHERE deliverable_id= p_target_deliverable_id;
2424: END IF;
2425:
2426: p_target_deliverable_id := l_new_target_del_id;

Line 2682: FROM okc_deliverables

2678: WHERE id=To_Number(p_entity_pk1);
2679: ELSIF p_entity_name = G_DLVBL_ENTITY THEN
2680: SELECT deliverable_name
2681: INTO l_title
2682: FROM okc_deliverables
2683: WHERE deliverable_id=To_Number(p_entity_pk1);
2684: ELSE
2685: RETURN l_title;
2686: END IF;

Line 2873: FROM okc_deliverables

2869:
2870: CURSOR cur_src_del_details (cp_del_id NUMBER)
2871: IS
2872: SELECT business_document_type, business_document_id
2873: FROM okc_deliverables
2874: WHERE deliverable_id = cp_del_id;
2875:
2876:
2877: l_document_type VARCHAR2(30);

Line 3409: okc_deliverables tgtAward

3405: CURSOR cur_del_ids
3406: IS
3407: SELECT tgtAward.deliverable_id,srcMod.orig_system_reference_id1
3408: FROM
3409: okc_deliverables tgtAward
3410: ,okc_deliverables srcMod
3411: WHERE srcMod.business_document_type= p_update_from_doc_type
3412: AND srcMod.business_document_id= p_update_from_doc_id
3413: AND tgtAward.business_document_type= p_update_to_doc_type

Line 3410: ,okc_deliverables srcMod

3406: IS
3407: SELECT tgtAward.deliverable_id,srcMod.orig_system_reference_id1
3408: FROM
3409: okc_deliverables tgtAward
3410: ,okc_deliverables srcMod
3411: WHERE srcMod.business_document_type= p_update_from_doc_type
3412: AND srcMod.business_document_id= p_update_from_doc_id
3413: AND tgtAward.business_document_type= p_update_to_doc_type
3414: AND tgtAward.business_document_id= p_update_to_doc_id

Line 3520: UPDATE okc_deliverables

3516: CLOSE cur_del_ids;
3517:
3518: IF l_tgt_id_tbl.Count > 0 THEN
3519: FORALL i IN l_tgt_id_tbl.first..l_tgt_id_tbl.last
3520: UPDATE okc_deliverables
3521: SET deliverable_id = l_src_ref_id_tbl(i)
3522: WHERE deliverable_id = l_tgt_id_tbl(i);
3523: END IF;
3524:

Line 3666: FROM okc_deliverables

3662: AND document_id = p_doc_id
3663: AND summary_amend_operation_code IN ('UPDATED','DELETED')
3664: UNION ALL
3665: SELECT 'DELIVERABLE' entity, orig_system_reference_id1 , amendment_operation, summary_amend_operation_code
3666: FROM okc_deliverables
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')

Line 3708: FROM okc_deliverables

3704: summary_amend_operation_code,
3705: orig_system_reference_code,
3706: orig_system_reference_id1,
3707: orig_system_reference_id2
3708: FROM okc_deliverables
3709: WHERE business_document_type = p_src_doc_type
3710: AND business_document_id = p_src_doc_id
3711: AND business_document_version = -99
3712: AND amendment_operation IS NOT NULL

Line 3718: FROM okc_deliverables

3714:
3715: CURSOR cur_get_tar_del (cp_deliverable_id NUMBER)
3716: IS
3717: SELECT deliverable_id
3718: FROM okc_deliverables
3719: WHERE business_document_type = p_target_doc_type
3720: AND business_document_id = p_target_doc_id
3721: AND business_document_version = -99
3722: AND orig_system_reference_id1 = cp_deliverable_id;