DBA Data[Home] [Help]

PACKAGE BODY: APPS.CTO_ENI_WRAPPER

Source


1 Package Body CTO_ENI_WRAPPER AS
2 /* $Header: CTOENIIB.pls 120.0 2005/05/25 05:25:11 appldev noship $  */
3 
4 /*===========================================================================+
5  |  Copyright (c) 2003 Oracle Corporation Belmont, California, USA           |
6  |                       All rights reserved                                 |
7  +===========================================================================+
8  |                                                                           |
9  | FILENAME                                                                  |
10  |      CTOENIIB.pls                                                        |
11  |                                                                           |
12  | DESCRIPTION                                                               |
13  | Stubbed version of the package. This version will be called for all
14  | non-dbi customers
15  |                                                                           |
16  | PUBLIC PROCEDURES                                                         |
17  |      CTO_ENI_WRAPPER
18  |
19  | PUBLIC FUNCTIONS                                                          |
20  |      <None>                                                               |
21  |                                                                           |
22  | PRIVATE PROCEDURES                                                        |
23  |      <None>                                                               |
24  |                                                                           |
25  | PRIVATE FUNCTIONS                                                         |
26  |      <None>                                                               |
27  |                                                                           |
28  |                                                                           |
29  | HISTORY                                                                   |
30  |  sbag                  09-09-03                                           |
31  |
32  |                   This file is owned by ENI and should not be modified by
33  |		     anybody other than the ENI team. Please contact
34  |                   Kiran Konada or Usha Arora if you have any questions regarding
35  |                   this file.
36  |
37  |                   Bug: 3070429
38  |                   Desc: CONFIG ITEMS WERE NOT GETTING CREATED IN THE STAR TABLE
39  |
40  |		     During purchase order, users can create a config. item.
41  |		     This item is created in mtl_system_items_b but was not
42  |		     getting propagated to the STAR table. This is because,
43  |                   while creation of the config items the item is directly
44  |                   inserted into mtl_system_items_b and the INV API is not
45  |                   used.
46  |
47  |                   This file is the wrapper file around the main file that
48  |                   inserts into the STAR table.
49  |
50  |                   Resolution:
51  |                   Added a new API, create_config_items that would be called
52  |                   when a config item is created.
53  |
54  |	             Dependency: Please refer to the bug
55  |                   CTO files CTOMCFGB.pls and CTOCCFGB.pls are dependent
56  |                   on the spec and body
57  |
58  |                   This is stubbed version.
59  |                   Body with actual call to ENi procedure would be in branch
60  |                   Stubbed main version is created for CTO pre-req's to be applied
61  |                   on releases till 11.5.3 where ENI product doesnot exist
62  |
63  |                   branch version would only go as part of DBi family pack
64  |                   branch version would not be part of DM family pack
65  |
66  +===========================================================================*/
67 
68 Procedure CTO_CALL_TO_ENI(p_api_version NUMBER,
69                           p_init_msg_list VARCHAR2 := 'F',
70                           p_star_record CTO_ENI_WRAPPER.star_rec_type,
71                           x_return_status OUT NOCOPY VARCHAR2,
72                           x_msg_count OUT NOCOPY NUMBER,
73                           x_msg_data OUT NOCOPY VARCHAR2)
74 IS
75 
76 BEGIN
77 
78      X_RETURN_STATUS := 'S';
79 
80 END;
81 
82 END CTO_ENI_WRAPPER;
83