1 PACKAGE gl_coa_seg_val_imp_pub AUTHID CURRENT_USER AS
2 /* $Header: GLSVIPBS.pls 120.1 2011/01/28 14:30:14 sommukhe noship $ */
3 /***********************************************************************************************
4 Created By: Somnath Mukherjee
5 Date Created By: 01-AUG-2008
6 Purpose: A public API to import data from external system to GL is declared along with
7 several PL-SQL table types to be used in the API.
8 Known limitations,enhancements,remarks:
9
10 Change History
11
12 Who When What
13
14 ***********************************************************************************************/
15 -- Start of Comments
16 -- API Name : Chart of Accounts Segment Values import
17 -- Type : Public
18 -- Pre-reqs : None
19 -- Function : Imports Chart of Accounts Segment Values from external System to General Ledger
20 -- Parameters
21 -- IN p_api_version
22 -- IN p_init_msg_list
23 -- IN p_commit
24 -- IN p_validation_level
25 -- OUT x_return_status
26 -- OUT x_msg_count
27 -- OUT x_msg_data
28 -- IN OUT p_gl_flex_values_tbl
29 --
30
31 -- OUT p_gl_flex_values_status
32 -- This parameter returns the import status of Fnd Flex Values table
33
34
35 -- Version: Current Version 1.0
36 -- Previous Version
37 -- Initial Version 1.0
38 -- End of Comments
39
40
41
42 /**********************fnd_flex_values Record Type ************/
43 TYPE gl_flex_values_rec_type IS RECORD (
44 value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45 flex_value fnd_flex_values.flex_value%TYPE,
46 flex_desc fnd_flex_values_tl.description%TYPE,
47 parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48 summary_flag fnd_flex_values.summary_flag%TYPE,
49 roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
50 hierarchy_level fnd_flex_values.hierarchy_level%TYPE,
51 allow_budgeting VARCHAR2(1),
52 allow_posting VARCHAR2(1),
53 account_type VARCHAR2(1),
54 reconcile VARCHAR2(1),
55 third_party_control_account VARCHAR2(10), /* DRM Change */
56 /*third_party_control_account VARCHAR2(1),*/
57 enabled_flag fnd_flex_values.enabled_flag%TYPE,
58 effective_from DATE,
59 effective_to DATE,
60 msg_from NUMBER(6),
61 msg_to NUMBER(6),
62 status VARCHAR2(1),
63 interface_id NUMBER(15,0)
64 );
65 TYPE gl_flex_values_tbl_type IS TABLE OF gl_flex_values_rec_type INDEX BY BINARY_INTEGER;
66
67 TYPE gl_flex_values_nh_rec_type IS RECORD (
68 value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
69 parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,
70 range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE,
71 child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,
72 child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,
73 msg_from NUMBER(6),
74 msg_to NUMBER(6),
75 status VARCHAR2(1),
76 interface_id NUMBER(15,0)
77 );
78 TYPE gl_flex_values_nh_tbl_type IS TABLE OF gl_flex_values_nh_rec_type INDEX BY BINARY_INTEGER;
79
80 PROCEDURE coa_segment_val_imp (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_gl_flex_values_obj_tbl IN OUT NOCOPY GL_FLEX_VALUES_OBJ_TBL,
89 p_gl_flex_values_nh_obj_tbl IN OUT NOCOPY GL_FLEX_VALUES_NH_OBJ_TBL,
90 p_gl_flex_values_status OUT NOCOPY VARCHAR2,
91 p_gl_flex_values_nh_status OUT NOCOPY VARCHAR2
92
93 ) ;
94
95
96
97 END gl_coa_seg_val_imp_pub;