APPS.OKE_DELIVERABLE_UTILS_PUB dependencies on OKE_DELIVERABLES_TL

Line 524: L_Deliverable_Description oke_deliverables_tl.description%TYPE;

520: L_ID NUMBER;
521: L_Name VARCHAR2(120);
522: L_Number VARCHAR2(120);
523: L_Deliverable_ID NUMBER;
524: L_Deliverable_Description oke_deliverables_tl.description%TYPE;
525: L_Deliverable_Comments oke_deliverables_tl.comments%TYPE;
526:
527: CURSOR c IS
528: SELECT deliverable_id, description, comments

Line 525: L_Deliverable_Comments oke_deliverables_tl.comments%TYPE;

521: L_Name VARCHAR2(120);
522: L_Number VARCHAR2(120);
523: L_Deliverable_ID NUMBER;
524: L_Deliverable_Description oke_deliverables_tl.description%TYPE;
525: L_Deliverable_Comments oke_deliverables_tl.comments%TYPE;
526:
527: CURSOR c IS
528: SELECT deliverable_id, description, comments
529: FROM oke_deliverables_vl

Line 650: INSERT INTO oke_deliverables_tl (

646: AND source_header_id = p_source_project_id
647: AND source_deliverable_id = p_source_deliverable_id;
648: END IF;
649:
650: INSERT INTO oke_deliverables_tl (
651: deliverable_id
652: , language
653: , creation_date
654: , created_by

Line 675: from OKE_DELIVERABLES_TL T

671: FROM fnd_languages l
672: WHERE L.INSTALLED_FLAG in ('I', 'B')
673: AND not exists
674: (select NULL
675: from OKE_DELIVERABLES_TL T
676: where T.DELIVERABLE_ID = l_id
677: and T.LANGUAGE = L.LANGUAGE_CODE);
678:
679: