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.

[Home] [Help]

APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,

45: FROM DUAL;
46:
47:
48: TYPE g_doc_type IS RECORD (
49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,
50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,
51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,

Line 50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,

46:
47:
48: TYPE g_doc_type IS RECORD (
49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,
50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,
51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,

Line 52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,

48: TYPE g_doc_type IS RECORD (
49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,
50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,
51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,
55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,
56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);

Line 53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,

49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,
50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,
51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,
55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,
56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);
57:

Line 54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,

50: DOCUMENT_TYPE_CLASS OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE,
51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,
55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,
56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);
57:
58: G_DOC_TYPE_REC g_doc_type;

Line 55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,

51: NAME OKC_BUS_DOC_TYPES_TL.NAME%TYPE,
52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,
55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,
56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);
57:
58: G_DOC_TYPE_REC g_doc_type;
59:

Line 56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);

52: INTENT OKC_BUS_DOC_TYPES_B.INTENT%TYPE,
53: PROVISION_ALLOWED_YN OKC_BUS_DOC_TYPES_B.PROVISION_ALLOWED_YN%TYPE,
54: ENABLE_DELIVERABLES_YN OKC_BUS_DOC_TYPES_B.ENABLE_DELIVERABLES_YN%TYPE,
55: ENABLE_ATTACHMENTS_YN OKC_BUS_DOC_TYPES_B.ENABLE_ATTACHMENTS_YN%TYPE,
56: TARGET_RESPONSE_DOC_TYPE OKC_BUS_DOC_TYPES_B.TARGET_RESPONSE_DOC_TYPE%TYPE);
57:
58: G_DOC_TYPE_REC g_doc_type;
59:
60: Procedure apply_numbering_scheme

Line 458: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;

454:
455: l_api_version CONSTANT NUMBER := 1;
456: l_api_name CONSTANT VARCHAR2(30) := 'Create_Contract_Terms';
457: l_conterms_deliv_upd_date DATE := NULL;
458: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
459: l_document_id NUMBER;
460: lc_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_document_type;
461: lc_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_document_id;
462: l_dummy VARCHAR2(1) := NULL;

Line 460: lc_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_document_type;

456: l_api_name CONSTANT VARCHAR2(30) := 'Create_Contract_Terms';
457: l_conterms_deliv_upd_date DATE := NULL;
458: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
459: l_document_id NUMBER;
460: lc_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_document_type;
461: lc_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_document_id;
462: l_dummy VARCHAR2(1) := NULL;
463: l_blob BLOB := null;
464: l_fid NUMBER;

Line 577: SELECT intent FROM okc_bus_doc_types_b

573: AND poh.revision_num = poa.revision_num
574: AND poh.po_header_id = p_document_id;
575:
576: CURSOR c_get_intent_csr IS
577: SELECT intent FROM okc_bus_doc_types_b
578: WHERE document_type = p_document_type;
579:
580: BEGIN
581: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1797: SELECT intent FROM okc_bus_doc_types_b

1793: AND document_id = p_document_id
1794: AND scn_id=lc_scn_id;
1795:
1796: CURSOR c_get_intent_csr IS
1797: SELECT intent FROM okc_bus_doc_types_b
1798: WHERE document_type = p_document_type;
1799:
1800: BEGIN
1801: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2912: SELECT intent FROM okc_bus_doc_types_b

2908: WHERE flex_value = p_variable_value
2909: AND FLEX_VALUE_SET_ID = p_attr_value_set_id;
2910:
2911: CURSOR c_get_intent_csr IS
2912: SELECT intent FROM okc_bus_doc_types_b
2913: WHERE document_type = p_doc_type;
2914:
2915: BEGIN
2916:

Line 3216: SELECT intent FROM okc_bus_doc_types_b

3212: WHERE document_type = p_document_type
3213: AND template_id = l_template_id;
3214:
3215: CURSOR c_get_intent_csr IS
3216: SELECT intent FROM okc_bus_doc_types_b
3217: WHERE document_type = p_document_type;
3218:
3219: CURSOR c_get_user_id_csr(p_user_name IN VARCHAR2) IS
3220: SELECT user_id FROM fnd_user WHERE user_name LIKE p_user_name;

Line 3737: okc_bus_doc_types_b end_type

3733: UNION
3734: SELECT 'Y'
3735: FROM okc_bus_doc_events_b start_event,
3736: okc_bus_doc_events_b end_event,
3737: okc_bus_doc_types_b end_type
3738: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3739: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3740: AND end_type.document_type = end_event.bus_doc_type
3741: AND start_event.bus_doc_type = end_type.target_response_doc_type

Line 3746: okc_bus_doc_types_b start_type

3742: UNION
3743: SELECT 'Y'
3744: FROM okc_bus_doc_events_b start_event,
3745: okc_bus_doc_events_b end_event,
3746: okc_bus_doc_types_b start_type
3747: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3748: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3749: AND start_type.document_type = start_event.bus_doc_type
3750: AND end_event.bus_doc_type = start_type.target_response_doc_type;

Line 3877: okc_bus_doc_types_b doctypes,

3873: CURSOR cur_val_event
3874: IS
3875: SELECT 'Y'
3876: FROM okc_bus_doc_events_v evts,
3877: okc_bus_doc_types_b doctypes,
3878: okc_del_bus_doc_combxns delcomb,
3879: okc_deliverable_types_b deltypes
3880: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3881: AND deltypes.deliverable_type_code = p_deliverable_type

Line 3892: okc_bus_doc_types_b doctypes,

3888: )
3889: UNION
3890: SELECT 'Y'
3891: FROM okc_bus_doc_events_v evts,
3892: okc_bus_doc_types_b doctypes,
3893: okc_del_bus_doc_combxns delcomb,
3894: okc_deliverable_types_b deltypes
3895: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3896: AND deltypes.deliverable_type_code = p_deliverable_type

Line 3907: okc_bus_doc_types_b doctypes,

3903: )
3904: UNION
3905: SELECT 'Y'
3906: FROM okc_bus_doc_events_v evts,
3907: okc_bus_doc_types_b doctypes,
3908: okc_del_bus_doc_combxns delcomb,
3909: okc_deliverable_types_b deltypes
3910: WHERE 1=1
3911: AND evts.bus_doc_event_id = p_bus_doc_event_id

Line 3952: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3948:
3949: CURSOR cur_val_event
3950: IS
3951: select 'Y'
3952: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3953: okc_del_bus_doc_combxns delComb,
3954: okc_deliverable_types_b delTypes
3955: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3956: AND delTypes.deliverable_type_code = p_deliverable_type

Line 3966: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3962:
3963: UNION
3964:
3965: select 'Y'
3966: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3967: okc_del_bus_doc_combxns delComb,
3968: okc_deliverable_types_b delTypes
3969: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3970: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType

Line 3980: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3976:
3977: UNION
3978:
3979: select 'Y'
3980: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3981: okc_del_bus_doc_combxns delComb,
3982: okc_deliverable_types_b delTypes
3983: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3984: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType

Line 3995: okc_bus_doc_types_b doc_types,

3991: UNION
3992:
3993: select 'Y'
3994: from okc_bus_doc_events_v evts,
3995: okc_bus_doc_types_b doc_types,
3996: okc_del_bus_doc_combxns delComb,
3997: okc_deliverable_types_b del_types
3998:
3999: WHERE

Line 4010: FROM okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

4006:
4007: UNION
4008:
4009: select 'Y'
4010: FROM okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
4011: okc_del_bus_doc_combxns delComb,
4012: okc_deliverable_types_b delTypes
4013: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
4014: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType

Line 4060: FROM OKC_BUS_DOC_TYPES_B

4056:
4057: CURSOR cur_val_bus_doc (p_doc_type VARCHAR2)
4058: IS
4059: SELECT DOCUMENT_TYPE_CLASS, intent
4060: FROM OKC_BUS_DOC_TYPES_B
4061: WHERE document_type = p_doc_type;
4062:
4063: CURSOR cur_val_del_type (p_del_type VARCHAR2)
4064: IS

Line 5189: okc_bus_doc_types_b doctyp,

5185:
5186: CURSOR C_delTypeExists is
5187: SELECT 'X'
5188: FROM
5189: okc_bus_doc_types_b doctyp,
5190: okc_del_bus_doc_combxns deltypcomb
5191: WHERE
5192: doctyp.document_type_class = deltypcomb.document_type_class
5193: AND doctyp.document_type = p_document_type