1 PACKAGE ecx_code_conversion_pvt AUTHID CURRENT_USER AS
2 -- $Header: ECXXREFS.pls 120.1.12020000.2 2013/03/21 11:19:28 jmaddila ship $
3
4 G_NO_ERRORS CONSTANT NUMBER := 0;
5 G_INVALID_PARAMETER CONSTANT NUMBER := 1;
6 G_UNEXP_ERROR CONSTANT NUMBER := 2;
7
8 -- Global constants holding the package and file names to be used by
9 -- messaging routines in the case of an unexpected error.
10
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ecx_Code_Conversion_PVT';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ECXXREFB.pls';
13
14 G_XREF_NOT_FOUND CONSTANT VARCHAR2(1) := 'X';
15 G_RECV_XREF_NOT_FOUND CONSTANT VARCHAR2(1) := 'R';
16
17 /** taken from the FND_API for the Standalone Version **/
18 G_MISS_NUM CONSTANT NUMBER := 9.99E125;
19 G_MISS_CHAR CONSTANT VARCHAR2(1) := chr(0);
20 G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
21
22 G_VALID_LEVEL_NONE CONSTANT NUMBER := 0;
23 G_VALID_LEVEL_FULL CONSTANT NUMBER := 100;
24
25 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := 'S';
26 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := 'E';
27 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := 'U';
28
29 G_EXC_ERROR EXCEPTION;
30 G_EXC_UNEXPECTED_ERROR EXCEPTION;
31
32 G_TRUE CONSTANT VARCHAR2(1) := 'T';
33 G_FALSE CONSTANT VARCHAR2(1) := 'F';
34
35 PROCEDURE populate_plsql_tbl_with_extval(
36 p_api_version_number IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := G_FALSE,
38 p_simulate IN VARCHAR2 := G_FALSE,
39 p_commit IN VARCHAR2 := G_FALSE,
40 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
41 p_standard_id IN NUMBER,
42 p_return_status OUT NOCOPY VARCHAR2,
43 p_msg_count OUT NOCOPY PLS_INTEGER,
44 p_msg_data OUT NOCOPY VARCHAR2,
45 p_level IN PLS_INTEGER,
46 p_tbl IN OUT NOCOPY ecx_utils.dtd_node_tbl,
47 p_tp_id IN PLS_INTEGER);
48
49 PROCEDURE populate_plsql_tbl_with_intval(
50 p_api_version_number IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := G_FALSE,
52 p_simulate IN VARCHAR2 := G_FALSE,
53 p_commit IN VARCHAR2 := G_FALSE,
54 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
55 p_standard_id IN NUMBER,
56 p_return_status OUT NOCOPY VARCHAR2,
57 p_msg_count OUT NOCOPY PLS_INTEGER,
58 p_msg_data OUT NOCOPY VARCHAR2,
59 p_level IN PLS_INTEGER,
60 p_apps_tbl IN OUT NOCOPY ecx_utils.dtd_node_tbl,
61 p_tp_id IN PLS_INTEGER);
62
63 PROCEDURE convert_external_value(
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := G_FALSE,
66 p_simulate IN VARCHAR2 := G_FALSE,
67 p_commit IN VARCHAR2 := G_FALSE,
68 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
69 p_standard_id IN NUMBER,
70 p_return_status OUT NOCOPY VARCHAR2,
71 p_msg_count OUT NOCOPY PLS_INTEGER,
72 p_msg_data OUT NOCOPY VARCHAR2,
73 p_value IN OUT NOCOPY VARCHAR2,
74 p_category_id IN PLS_INTEGER,
75 p_snd_tp_id IN PLS_INTEGER,
76 p_rec_tp_id IN PLS_INTEGER);
77 /*
78 * This api does same as convert_external_value but will be
79 * called from java. Duplicate since to track properlogging from java
80 */
81 PROCEDURE convert_external_value_java(
82 i_standard_id IN NUMBER,
83 o_return_status OUT NOCOPY VARCHAR2,
84 io_value IN OUT NOCOPY VARCHAR2,
85 o_ext_code OUT NOCOPY VARCHAR2,
86 o_int_code OUT NOCOPY VARCHAR2,
87 i_category_id IN PLS_INTEGER,
88 i_snd_tp_id IN PLS_INTEGER,
89 i_rec_tp_id IN PLS_INTEGER);
90 END;