PACKAGE: APPS.INL_SIMULATION_PVT

Source

1 PACKAGE INL_SIMULATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: INLVSIMS.pls 120.1 2011/01/05 16:54:14 acferrei noship $ */
3 
4 g_module_name VARCHAR2(100) := 'INL_SIMULATION_PVT';
5 g_pkg_name CONSTANT VARCHAR2(30) := 'INL_SIMULATION_PVT';
6 
7 TYPE from_association_rec IS RECORD(
8      from_parent_table_name VARCHAR2(30),
9      from_parent_table_id NUMBER);
10 
11 TYPE from_association_tbl IS TABLE OF from_association_rec INDEX BY BINARY_INTEGER;
12 
13 TYPE simulation_rec IS RECORD(
14      simulation_id NUMBER,
15      firmed_flag VARCHAR2(1),
16      parent_table_name VARCHAR2(30),
17      parent_table_id NUMBER,
18      parent_table_revision_num NUMBER,
19      version_num NUMBER,
20      vendor_id NUMBER,
21      vendor_site_id NUMBER,
22      freight_code VARCHAR2(25),
23      org_id NUMBER,
24      attribute_category VARCHAR2(30),
25      attribute1 VARCHAR2(150),
26      attribute2 VARCHAR2(150),
27      attribute3 VARCHAR2(150),
28      attribute4 VARCHAR2(150),
29      attribute5 VARCHAR2(150),
30      attribute6 VARCHAR2(150),
31      attribute7 VARCHAR2(150),
32      attribute8 VARCHAR2(150),
33      attribute9 VARCHAR2(150),
34      attribute10 VARCHAR2(150),
35      attribute11 VARCHAR2(150),
36      attribute12 VARCHAR2(150),
37      attribute13 VARCHAR2(150),
38      attribute14 VARCHAR2(150),
39      attribute15 VARCHAR2(150));
40 
41 TYPE simulation_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
42 
43 PROCEDURE Create_Simulation (p_api_version IN NUMBER,
44                              p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45                              p_commit IN VARCHAR2 := FND_API.G_FALSE,
46                              p_simulation_rec IN OUT NOCOPY simulation_rec,
47                              x_return_status OUT NOCOPY VARCHAR2,
48                              x_msg_count OUT NOCOPY NUMBER,
49                              x_msg_data OUT NOCOPY VARCHAR2);
50 
51 PROCEDURE Copy_Simulation (p_api_version   IN NUMBER,
52                            p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53                            p_commit        IN VARCHAR2 := FND_API.G_FALSE,
54                            p_simulation_id IN  NUMBER,
55                            x_return_status OUT NOCOPY VARCHAR2,
56                            x_msg_count     OUT NOCOPY NUMBER,
57                            x_msg_data      OUT NOCOPY VARCHAR2);
58 
59 
60 PROCEDURE Purge_Simulations(p_api_version IN NUMBER,
61                             p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62                             p_commit IN VARCHAR2 := FND_API.G_FALSE,
63                             p_org_id IN NUMBER,
64                             p_simulation_table IN simulation_id_tbl,
65                             x_return_status OUT NOCOPY VARCHAR2,
66                             x_msg_count OUT NOCOPY NUMBER,
67                             x_msg_data OUT NOCOPY VARCHAR2);
68 
69 END INL_SIMULATION_PVT;