APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 277: okc_bus_doc_types_b doctypes,

273: CURSOR cur_val_event
274: IS
275: SELECT 'Y'
276: FROM okc_bus_doc_events_v evts,
277: okc_bus_doc_types_b doctypes,
278: okc_del_bus_doc_combxns delcomb,
279: okc_deliverable_types_b deltypes
280: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
281: AND 'TEMPLATE' = p_document_type

Line 288: FROM okc_bus_doc_types_b

284: AND deltypes.deliverable_type_code = delcomb.deliverable_type_code
285: AND doctypes.document_type = evts.bus_doc_type
286: AND ( doctypes.document_type IN (
287: SELECT target_response_doc_type
288: FROM okc_bus_doc_types_b
289: WHERE document_type_class =
290: delcomb.document_type_class
291: AND target_response_doc_type IS NOT NULL)
292: OR doctypes.show_in_lov_yn = 'Y'

Line 325: okc_bus_doc_types_b doctypes,

321: CURSOR cur_val_event
322: IS
323: SELECT 'Y'
324: FROM okc_bus_doc_events_v evts,
325: okc_bus_doc_types_b doctypes,
326: okc_del_bus_doc_combxns delcomb,
327: okc_deliverable_types_b deltypes
328: WHERE 'TEMPLATE' = p_document_type
329: AND evts.bus_doc_event_id = p_bus_doc_event_id

Line 432: okc_bus_doc_types_b end_type

428: UNION
429: SELECT 'Y'
430: FROM okc_bus_doc_events_b start_event,
431: okc_bus_doc_events_b end_event,
432: okc_bus_doc_types_b end_type
433: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
434: AND end_event.bus_doc_event_id = p_end_event_id --end event id
435: AND end_type.document_type = end_event.bus_doc_type
436: AND start_event.bus_doc_type = end_type.target_response_doc_type

Line 441: okc_bus_doc_types_b start_type

437: UNION
438: SELECT 'Y'
439: FROM okc_bus_doc_events_b start_event,
440: okc_bus_doc_events_b end_event,
441: okc_bus_doc_types_b start_type
442: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
443: AND end_event.bus_doc_event_id = p_end_event_id --end event id
444: AND start_type.document_type = start_event.bus_doc_type
445: AND end_event.bus_doc_type = start_type.target_response_doc_type;

Line 685: FROM okc_bus_doc_types_b bus, fnd_lookups fnd

681: l_tmpl_intent VARCHAR2 (120) := g_template_intent;
682: BEGIN
683: SELECT 'Y'
684: INTO l_valid_bus_doc_type
685: FROM okc_bus_doc_types_b bus, fnd_lookups fnd
686: WHERE bus.document_type <> 'TEMPLATE'
687: AND DECODE (bus.document_type_class,
688: 'REPOSITORY', NVL (bus.enable_contract_terms_yn, 'N'),
689: NVL (bus.show_in_lov_yn, 'Y')

Line 2186: -- Business document type. Refers to document_type in okc_bus_doc_types_b

2182: THEN
2183: p_section_rec.old_id := NULL;
2184: END IF;
2185:
2186: -- Business document type. Refers to document_type in okc_bus_doc_types_b
2187: IF p_section_rec.document_type = okc_api.g_miss_char
2188: THEN
2189: p_section_rec.document_type := 'TEMPLATE';
2190: END IF;

Line 5066: FROM okc_bus_doc_types_b

5062:
5063: CURSOR l_doc_intent_csr
5064: IS
5065: SELECT intent
5066: FROM okc_bus_doc_types_b
5067: WHERE document_type = p_tmpl_usage_rec.document_type;
5068: BEGIN
5069: l_progress := '010';
5070: