1 PACKAGE AHL_ENIGMA_ROUTE_OP_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPEROS.pls 120.3.12020000.2 2012/12/07 00:15:30 sareepar ship $ */
3
4 TYPE route_op_asso_tbl_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
5
6 TYPE enigma_route_rec_type IS RECORD
7 (
8 --ROUTE_ID VARCHAR2(2000), -- old
9 ENIGMA_ROUTE_ID VARCHAR2(80), -- new
10 STATUS VARCHAR2(30),
11 ATA_CODE VARCHAR2(30),
12 DESCRIPTION VARCHAR2(2000),
13 REVISION_DATE DATE,
14 --ENIGMA_ID VARCHAR2(2000), -- old
15 ENIGMA_DOC_ID VARCHAR2(80), -- new
16 --CHANGE_FLAG VARCHAR2(1), -- old
17 DML_OPERATION VARCHAR2(2), -- new
18 -- PDF VARCHAR2(100), -- old
19 PDF_FILE_NAME VARCHAR2(100), -- new
20 OP_ASSO_TBL route_op_asso_tbl_type
21 );
22
23
24
25 TYPE enigma_op_rec_type IS RECORD
26 (
27 --OPERATION_ID VARCHAR2(2000), -- old
28 ENIGMA_OP_ID VARCHAR2(80), -- new
29 STATUS VARCHAR2(30),
30 ATA_CODE VARCHAR2(30),
31 DESCRIPTION VARCHAR2(2000),
32 --PARENT_ROUTE_ID VARCHAR2(2000),
33 --ENIGMA_ID VARCHAR2(2000), -- old
34 ENIGMA_DOC_ID VARCHAR2(80), -- new
35 --CHANGE_FLAG VARCHAR2(1) -- old
36 DML_OPERATION VARCHAR2(1), -- new
37 OPERATOR VARCHAR2(30), -- new
38 EQUIPMENT VARCHAR2(30), -- new
39 OEM_DOC_TYPE VARCHAR2(30), -- new
40 CHAPTER_SECTION_SUBJECT VARCHAR2(30), -- new
41 AMTOSS_Function VARCHAR2(30), -- new
42 OP_SEQ VARCHAR2(30), -- new
43 CONFIG_LETTER VARCHAR2(30) -- new
44 );
45
46 TYPE enigma_route_tbl_type IS TABLE OF enigma_route_rec_type INDEX BY BINARY_INTEGER;
47 TYPE enigma_op_tbl_type IS TABLE OF enigma_op_rec_type INDEX BY BINARY_INTEGER;
48
49 --TYPE enigma_op_tbl_type IS TABLE OF enigma_op_rec_type INDEX BY BINARY_INTEGER; -- old
50
51 PROCEDURE Process_Route_Operations
52 (
53 p_api_version IN NUMBER := 1.0,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57 p_module_type IN VARCHAR2,
58 p_context IN VARCHAR2,
59 p_pub_date IN DATE,
60 p_operator IN VARCHAR2, --added 30-04-10
61 p_model IN VARCHAR2, --added 30-04-10
62 p_enigma_route_tbl IN enigma_route_tbl_type, --modified 30-04-10
63 --p_enigma_op_tbl IN enigma_op_tbl_type, -- old
64 p_enigma_op_tbl IN enigma_op_tbl_type, -- modified 30-04-10
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 END AHL_ENIGMA_ROUTE_OP_PUB;