APPS.OKC_REP_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 59: FROM okc_bus_doc_types_b

55: l_result VARCHAR2(1);
56:
57: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
58: SELECT NULL
59: FROM okc_bus_doc_types_b
60: WHERE document_type = p_contract_type
61: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
62: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL);
63:

Line 459: FROM okc_bus_doc_types_b

455: l_transaction_type CONSTANT VARCHAR2(200) := 'OKC_REP_CON_APPROVAL';
456:
457: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
458: SELECT NULL
459: FROM okc_bus_doc_types_b
460: WHERE document_type = p_contract_type
461: AND ((is_sales_workbench() = 'N'
462: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
463: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)

Line 4102: --OKC_BUS_DOC_TYPES_B DOC_TYPES

4098:
4099: --CURSOR PARTY_INTENT_CSR (p_contract_type VARCHAR2, p_party_role_code VARCHAR2) IS
4100: --SELECT INTERNAL_EXTERNAL_FLAG
4101: --FROM OKC_RESP_PARTIES_B RESP_PARTIES,
4102: --OKC_BUS_DOC_TYPES_B DOC_TYPES
4103: --WHERE RESP_PARTIES.RESP_PARTY_CODE = p_party_role_code
4104: --AND RESP_PARTIES.DOCUMENT_TYPE_CLASS = 'REPOSITORY'
4105: --AND DOC_TYPES.INTENT = RESP_PARTIES.INTENT
4106: --AND DOC_TYPES.DOCUMENT_TYPE = p_contract_type;

Line 4141: select auto_num_enabled_yn from okc_bus_doc_types_b where document_type = p_doc_type ;

4137: AND LANGUAGE = userenv('LANG');
4138:
4139:
4140: CURSOR doc_type_auto_num(p_doc_type IN VARCHAR2) IS
4141: select auto_num_enabled_yn from okc_bus_doc_types_b where document_type = p_doc_type ;
4142:
4143: l_auto_num_doc VARCHAR2(1);
4144: l_auto_num_profile VARCHAR2(1);
4145: