PACKAGE: APPS.AHL_ENIGMA_ROUTE_OP_PUB

Source

1 PACKAGE AHL_ENIGMA_ROUTE_OP_PUB AS
2 /* $Header: AHLPEROS.pls 120.0.12010000.1 2008/11/24 09:17:27 bachandr noship $ */
3 
4 TYPE enigma_route_rec_type IS RECORD
5 (
6 ROUTE_ID               VARCHAR2(2000),
7 STATUS                 VARCHAR2(30),
8 ATA_CODE               VARCHAR2(30),
9 DESCRIPTION            VARCHAR2(2000),
10 REVISION_DATE          DATE,
11 ENIGMA_ID              VARCHAR2(2000),
12 CHANGE_FLAG            VARCHAR2(1),
13 PDF                    VARCHAR2(100)
14 );
15 
16 TYPE enigma_op_rec_type IS RECORD
17 (
18 OPERATION_ID      VARCHAR2(2000),
19 STATUS            VARCHAR2(30),
20 ATA_CODE          VARCHAR2(30),
21 DESCRIPTION       VARCHAR2(2000),
22 PARENT_ROUTE_ID   VARCHAR2(2000),
23 ENIGMA_ID         VARCHAR2(2000),
24 CHANGE_FLAG       VARCHAR2(1)
25 );
26 
27 TYPE enigma_op_tbl_type IS TABLE OF enigma_op_rec_type INDEX BY BINARY_INTEGER;
28 
29 PROCEDURE Process_Route_Operations
30    (
31         p_api_version          IN               NUMBER        := 1.0,
32         p_init_msg_list        IN               VARCHAR2      := FND_API.G_FALSE,
33         p_commit               IN               VARCHAR2      := FND_API.G_FALSE,
34         p_validation_level     IN               NUMBER        := FND_API.G_VALID_LEVEL_FULL,
35         p_module_type          IN               VARCHAR2,
36         p_context              IN               VARCHAR2,
37         p_pub_date             IN               DATE,
38         p_enigma_route_rec     IN               enigma_route_rec_type,
39         p_enigma_op_tbl        IN               enigma_op_tbl_type,
40         x_return_status        OUT    NOCOPY    VARCHAR2,
41         x_msg_count            OUT    NOCOPY    NUMBER,
42         x_msg_data             OUT    NOCOPY    VARCHAR2
43    );
44 
45 END AHL_ENIGMA_ROUTE_OP_PUB;