1 Package CTO_ENI_WRAPPER AUTHID CURRENT_USER AS
2 /* $Header: CTOENIIS.pls 115.0 2003/09/11 04:38:07 kkonada noship $ */
3
4
5 /*===========================================================================+
6 | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
7 | All rights reserved |
8 +===========================================================================+
9 | |
10 | FILENAME |
11 | CTOENIIS.pls |
12 | |
13 | DESCRIPTION |
14 | Wrapper to call the ENI API to populate the STAR table after a config item
15 | is created
16 | |
17 | PUBLIC PROCEDURES |
18 | CTO_ENI_WRAPPER
19 |
20 | PUBLIC FUNCTIONS |
21 | <None> |
22 | |
23 | PRIVATE PROCEDURES |
24 | <None> |
25 | |
26 | PRIVATE FUNCTIONS |
27 | <None> |
28 | |
29 | |
30 | HISTORY |
31 | sbag 09-09-03 |
32 |
33 | This file is owned by ENI and should not be modified by
34 | anybody other than the ENI team. Please contact
35 | Kiran Konada or Usha Arora if you have any questions regarding
36 | this file.
37 |
38 | Bug: 3070429
39 | Desc: CONFIG ITEMS WERE NOT GETTING CREATED IN THE STAR TABLE
40 |
41 | During purchase order, users can create a config. item.
42 | This item is created in mtl_system_items_b but was not
43 | getting propagated to the STAR table. This is because,
44 | while creation of the config items the item is directly
45 | inserted into mtl_system_items_b and the INV API is not
46 | used.
47 |
48 | This file is the wrapper file around the main file that
49 | inserts into the STAR table.
50 |
51 | Resolution:
52 | Added a new API, create_config_items that would be called
53 | when a config item is created.
54 |
55 | Dependency: Please refer to the bug
56 | CTO files CTOMCFGB.pls and CTOCCFGB.pls are dependent
57 | on the spec and body
58 |
59 +===========================================================================*/
60
61
62 type STAR_REC_TYPE is RECORD
63 (
64 inventory_item_id mtl_system_items_b.inventory_item_id%TYPE
65 , organization_id mtl_system_items_b.organization_id%TYPE
66 , column1 number -- for future use
67 , column2 number -- for future use
68 , column3 varchar2(150) -- for future use
69 , column4 varchar2(150) -- for future use
70 , column5 date -- for future use
71 );
72
73 Procedure CTO_CALL_TO_ENI(p_api_version NUMBER,
74 p_init_msg_list VARCHAR2 := 'F',
75 p_star_record CTO_ENI_WRAPPER.star_rec_type,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2);
79
80
81 END CTO_ENI_WRAPPER;