PACKAGE: APPS.AHL_APPR_SPACE_UNAVL_PUB

Source

1 PACKAGE AHL_APPR_SPACE_UNAVL_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPSUAS.pls 115.6 2003/11/04 10:43:13 rroy noship $ */
3 
4 -----------------------------------------------------------
5 -- PACKAGE
6 --    AHL_SPACE_UNAVL_PUB
7 --
8 -- PURPOSE
9 --    This package is a Public API for managing Space Unavailable information in
10 --    Advanced Services Online.  It contains specification for pl/sql records and tables
11 --
12 --    AHL_SPACE_UNAVIALABLE_VL:
13 --    Process_Space_Restriction (see below for specification)
14 --
15 --
16 -- NOTES
17 --
18 --
19 -- HISTORY
20 -- 17-Apr-2002    ssurapan      Created.
21 -----------------------------------------------------------
22 
23 -------------------------------------
24 -----          SPACE UNAVAILABILITY            -----
25 -------------------------------------
26 -- Record for AHL_SPACE_UNAVAILABLE_VL
27 TYPE Space_Restriction_Rec IS RECORD (
28    space_unavailability_id      NUMBER,
29    last_update_date             DATE,
30    last_updated_by              NUMBER,
31    creation_date                DATE,
32    created_by                   NUMBER,
33    last_update_login            NUMBER,
34    object_version_number        NUMBER,
35    organization_id              NUMBER,
36    org_name                     VARCHAR2(240),
37    department_id                NUMBER,
38    dept_description             VARCHAR2(240),
39    space_id                     NUMBER,
40    space_name                   VARCHAR2(30),
41    start_date                   DATE,
42    end_date                     DATE,
43    description                  VARCHAR2(2000),
44    attribute_category           VARCHAR2(30),
45    attribute1                   VARCHAR2(150),
46    attribute2                   VARCHAR2(150),
47    attribute3                   VARCHAR2(150),
48    attribute4                   VARCHAR2(150),
49    attribute5                   VARCHAR2(150),
50    attribute6                   VARCHAR2(150),
51    attribute7                   VARCHAR2(150),
52    attribute8                   VARCHAR2(150),
53    attribute9                   VARCHAR2(150),
54    attribute10                  VARCHAR2(150),
55    attribute11                  VARCHAR2(150),
56    attribute12                  VARCHAR2(150),
57    attribute13                  VARCHAR2(150),
58    attribute14                  VARCHAR2(150),
59    attribute15                  VARCHAR2(150),
60    operation_flag               VARCHAR2(1)
61 );
62 
63 --Declare table type
64 TYPE space_restriction_tbl IS TABLE OF Space_Restriction_Rec
65 INDEX BY BINARY_INTEGER;
66 
67 --------------------------------------------------------------------
68 -- PROCEDURE
69 --    Process_Space_Restriction
70 --
71 -- PURPOSE
72 --    Process Space Restriction Record
73 --
74 -- PARAMETERS
75 --    p_x_space_restriction_tbl: the table representing space_restriction_tbl
76 --
77 -- NOTES
78 --------------------------------------------------------------------
79 PROCEDURE Process_Space_Restriction (
80    p_api_version             IN      NUMBER,
81    p_init_msg_list           IN      VARCHAR2  := FND_API.g_false,
82    p_commit                  IN      VARCHAR2  := FND_API.g_false,
83    p_validation_level        IN      NUMBER    := FND_API.g_valid_level_full,
84    p_module_type             IN      VARCHAR2  := 'JSP',
85    p_x_space_restriction_tbl IN  OUT NOCOPY Space_Restriction_Tbl,
86    x_return_status               OUT NOCOPY VARCHAR2,
87    x_msg_count                   OUT NOCOPY NUMBER,
88    x_msg_data                    OUT NOCOPY VARCHAR2
89 );
90 
91 
92 END AHL_APPR_SPACE_UNAVL_PUB;