APPS.OKC_UTIL dependencies on OKC_K_HEADERS_B

Line 21: g_scs_code okc_k_headers_b.scs_code%TYPE := OKC_API.G_MISS_CHAR;

17: g_reset_resp_flag BOOLEAN := FALSE;
18: g_userenv_lang fnd_languages.language_code%TYPE;
19: g_resp_access okc_k_accesses.access_level%TYPE := OKC_API.G_MISS_CHAR;
20: g_user_resource_id okc_k_accesses.resource_id%TYPE := OKC_API.G_MISS_NUM;
21: g_scs_code okc_k_headers_b.scs_code%TYPE := OKC_API.G_MISS_CHAR;
22: g_groups_processed Boolean := False;
23:
24: TYPE sec_group_tbl IS TABLE OF okc_k_accesses.group_id%TYPE;
25: g_sec_groups sec_group_tbl;

Line 1566: 'FROM okc_k_headers_b khr,okc_k_lines_b khl,okc_condition_headers_b cnh WHERE khr.id = khl.dnz_chr_id and cnh.object_id = khl.id and khl.Id = :id';

1562: END IF;
1563:
1564: IF p_object_code = 'OKC_K_LINE' THEN
1565: l_sql_stmt := 'SELECT contract_number||'||''''||' '||''''||'||contract_number_modifier||'||''''||' '||''''||'||line_number'||' '||
1566: 'FROM okc_k_headers_b khr,okc_k_lines_b khl,okc_condition_headers_b cnh WHERE khr.id = khl.dnz_chr_id and cnh.object_id = khl.id and khl.Id = :id';
1567: ELSE
1568: l_sql_stmt := 'SELECT ' || l_select_name || ' FROM ' || l_from_table || ' WHERE ' || l_select_id || ' = :id';
1569: /*l_sql_stmt := 'SELECT ' || l_select_name || ' FROM ' || l_from_table;
1570:

Line 1628: l_scs_code okc_k_headers_b.scs_code%TYPE;

1624: p_update_attachment IN VARCHAR2 ,
1625: p_orig_source_code IN VARCHAR2)
1626: RETURN Varchar2 IS
1627:
1628: l_scs_code okc_k_headers_b.scs_code%TYPE;
1629:
1630: l_partner_cat CONSTANT Varchar2(7) := 'PARTNER';
1631:
1632: l_modify_access CONSTANT Varchar2(1) := 'U';

Line 1662: FROM okc_k_headers_b

1658: -- executed only if the subclass is not passed in
1659:
1660: CURSOR chr_csr IS
1661: SELECT scs_code,nvl(orig_system_source_code,'NOSOURCECODE')
1662: FROM okc_k_headers_b
1663: WHERE id = p_chr_id;
1664:
1665: -- This cursor checks to see the type of access granted to the current
1666: -- user's responsibility to the sub class

Line 1763: FROM okc_k_headers_b

1759: -- used only for contracts online.
1760:
1761: CURSOR c_check_contract(p_contract_id IN NUMBER) IS
1762: SELECT 'X'
1763: FROM okc_k_headers_b
1764: WHERE ID = p_contract_id;
1765:
1766: --MMadhavi commenting for MOAC
1767: /*

Line 1771: FROM okc_k_headers_b

1767: /*
1768: -- This cursor retrieves the authoring org id for that particular contract.
1769: CURSOR auth_org_csr IS
1770: SELECT authoring_org_id
1771: FROM okc_k_headers_b
1772: WHERE id = p_chr_id;
1773: */
1774:
1775: BEGIN

Line 2051: l_application_id okc_k_headers_b.application_id%TYPE := p_application_id;

2047: p_application_id IN NUMBER ,
2048: p_scs_code IN VARCHAR2 )
2049: Return Varchar2 IS
2050: l_access_level Varchar2(30);
2051: l_application_id okc_k_headers_b.application_id%TYPE := p_application_id;
2052: cursor c1 is
2053: select application_id
2054: from okc_k_headers_b
2055: where id = p_chr_id;

Line 2054: from okc_k_headers_b

2050: l_access_level Varchar2(30);
2051: l_application_id okc_k_headers_b.application_id%TYPE := p_application_id;
2052: cursor c1 is
2053: select application_id
2054: from okc_k_headers_b
2055: where id = p_chr_id;
2056: BEGIN
2057: -- For OKE Contracts (Application ID = 777), use OKE's security function
2058: If p_application_id Is Null Then

Line 3293: RETURN ' okc_util.get_k_access_level(OKC_K_HEADERS_B_ACCESS.id,OKC_K_HEADERS_B_ACCESS.scs_code) <>''N''';

3289: ---Function to check if a user has access to a contract ---added for bug 9648125
3290: ------------------------
3291: FUNCTION ACCESS_ELIGIBLE (object_schema in varchar2, object_name varchar2) return varchar2 AS
3292: BEGIN
3293: RETURN ' okc_util.get_k_access_level(OKC_K_HEADERS_B_ACCESS.id,OKC_K_HEADERS_B_ACCESS.scs_code) <>''N''';
3294: EXCEPTION WHEN OTHERS THEN
3295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'invoked', 'Error : '||SQLERRM);
3297: END IF;

Line 3317: FROM OKC_K_HEADERS_B WHERE id=p_chr_id;

3313: l_start_date DATE;
3314: l_org_id NUMBER;
3315: CURSOR start_date_crs IS
3316: SELECT start_date, authoring_org_id
3317: FROM OKC_K_HEADERS_B WHERE id=p_chr_id;
3318: CURSOR get_doc_usage_crs IS
3319: SELECT TEMPLATE_ID FROM okc_template_usages_v
3320: WHERE document_type = x_doc_type AND document_id = x_doc_id ;
3321: CURSOR get_apps_upg_tmpl_id_crs IS