PACKAGE: APPS.OKC_MRV_UTIL

Source

1 PACKAGE okc_mrv_util
2 /*$Header: OKCMRVUS.pls 120.1 2011/12/09 13:44:33 serukull noship $*/
3 AUTHID CURRENT_USER AS
4    PROCEDURE update_k_art_var (
5       p_cat_id          IN   NUMBER,
6       p_variable_code   IN   VARCHAR2,
7       p_blobdata        IN   BLOB,
8       p_type            IN   VARCHAR2
9    );
10 
11    FUNCTION get_k_art_var (
12       p_cat_id          IN   NUMBER,
13       p_variable_code   IN   VARCHAR2,
14       p_type            IN   VARCHAR2
15    )
16       RETURN BLOB;
17 
18    FUNCTION get_uda_attr_xml (
19       p_cat_id          IN   NUMBER,
20       p_variable_code   IN   VARCHAR2,
21       p_attr_group_id   IN   NUMBER
22    )
23       RETURN CLOB;
24 
25    PROCEDURE update_uda_attr_xml (
26       p_init_msg_list   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27       p_cat_id          IN   NUMBER,
28       p_variable_code   IN   VARCHAR2,
29       p_attr_group_id   IN   NUMBER,
30       p_mode            IN VARCHAR2 DEFAULT 'NORMAL',
31       p_locking_enabled IN VARCHAR2 DEFAULT 'N',
32       x_return_status              OUT NOCOPY VARCHAR2,
33       x_msg_count                  OUT NOCOPY NUMBER,
34       x_msg_data                   OUT NOCOPY VARCHAR2
35      );
36 
37 PROCEDURE update_uda_attr_xml (
38       p_cat_id          IN   NUMBER,
39       p_variable_code   IN   VARCHAR2,
40       p_attr_group_id   IN   NUMBER
41    );
42 
43 
44    PROCEDURE mrv_pre_process (docid IN NUMBER, doctype IN VARCHAR2);
45 
46    PROCEDURE checkdochasmrv (
47       docid       IN              NUMBER,
48       doctype     IN              VARCHAR2,
49       dochasmrv   OUT NOCOPY      VARCHAR2
50    );
51 
52    FUNCTION getattributegroupdispname (attrgroupid IN VARCHAR2)
53       RETURN VARCHAR2;
54 
55    FUNCTION gettemplatename (mrv_tmpl_code IN VARCHAR2)
56       RETURN VARCHAR2;
57 
58    PROCEDURE copy_variable_uda_data (
59       p_from_cat_id          IN   NUMBER,
60       p_from_variable_code   IN   VARCHAR2,
61       p_to_cat_id            IN   NUMBER,
62       p_to_variable_code     IN   VARCHAR2,
63       x_return_status        OUT  NOCOPY VARCHAR2,
64       x_msg_count            OUT  NOCOPY NUMBER,
65       x_msg_data             OUT  NOCOPY VARCHAR2
66    );
67 END okc_mrv_util;