APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_UTIL_PVT

Line 1: PACKAGE BODY OKC_XPRT_UTIL_PVT AS

1: PACKAGE BODY OKC_XPRT_UTIL_PVT AS
2: /* $Header: OKCVXUTLB.pls 120.49.12000000.8 2007/08/10 21:55:40 krallapa ship $ */
3:
4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_UTIL_PVT';

3:
4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_UTIL_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';

Line 2098: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;

2094: LOOP
2095: FETCH csr_rules INTO l_rule_id;
2096: EXIT WHEN csr_rules%NOTFOUND;
2097:
2098: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2099:
2100: UPDATE okc_xprt_rule_hdrs_all
2101: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
2102: published_flag = 'Y',

Line 10223: END OKC_XPRT_UTIL_PVT ;

10219: END IF;
10220: RETURN 'E';
10221: END has_unanswered_questions;
10222:
10223: END OKC_XPRT_UTIL_PVT ;