DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 57: FROM okc_bus_doc_types_b

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

Line 448: FROM okc_bus_doc_types_b

444: l_user_name FND_USER.USER_NAME%type;
445:
446: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
447: SELECT NULL
448: FROM okc_bus_doc_types_b
449: WHERE document_type = p_contract_type
450: AND ((is_sales_workbench() = 'N'
451: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
452: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)

Line 3761: --OKC_BUS_DOC_TYPES_B DOC_TYPES

3757:
3758: --CURSOR PARTY_INTENT_CSR (p_contract_type VARCHAR2, p_party_role_code VARCHAR2) IS
3759: --SELECT INTERNAL_EXTERNAL_FLAG
3760: --FROM OKC_RESP_PARTIES_B RESP_PARTIES,
3761: --OKC_BUS_DOC_TYPES_B DOC_TYPES
3762: --WHERE RESP_PARTIES.RESP_PARTY_CODE = p_party_role_code
3763: --AND RESP_PARTIES.DOCUMENT_TYPE_CLASS = 'REPOSITORY'
3764: --AND DOC_TYPES.INTENT = RESP_PARTIES.INTENT
3765: --AND DOC_TYPES.DOCUMENT_TYPE = p_contract_type;