DBA Data[Home] [Help]

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.65.12020000.2 2012/07/18 11:36:52 harchand 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_concat_art_no VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_CONCAT_ART_NO'),'N');
11:

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

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

Line 11077: END OKC_XPRT_UTIL_PVT ;

11073: );
11074:
11075: END update_document;
11076:
11077: END OKC_XPRT_UTIL_PVT ;