1 PACKAGE CSP_RESOURCE_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspgtres.pls 115.5 2002/11/26 06:39:07 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_RESOURCE_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:CSP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CSP_INV_LOC_ASSIGNMENT_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- RESOURCE_ID
25 -- ORGANIZATION_ID
26 -- SUBINVENTORY_CODE
27 -- LOCATOR_ID
28 -- RESOURCE_TYPE
29 -- EFFECTIVE_DATE_START
30 -- EFFECTIVE_DATE_END
31 -- DEFAULT_CODE
32 --
33 -- Required:
34 -- Defaults:
35 -- Note: This is automatic generated record definition, it includes all columns
36 -- defined in the table, developer must manually add or delete some of the attributes.
37 --
38 -- End of Comments
39
40 TYPE CSP_Rec_Type IS RECORD
41 (
42 CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44 CREATION_DATE DATE := FND_API.G_MISS_DATE,
45 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50 SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52 RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53 EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54 EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55 DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
56 );
57
58 G_MISS_CSP_REC CSP_Rec_Type;
59 TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type
60 INDEX BY BINARY_INTEGER;
61 G_MISS_CSP_TBL CSP_Tbl_Type;
62
63 TYPE CSP_sort_rec_type IS RECORD
64 (
65 -- Please define your own sort by record here.
66 CREATED_BY NUMBER := NULL
67 );
68
69 -- *******************************************************
70 -- Start of Comments
71 -- *******************************************************
72 -- API Name: Create_resource
73 -- Type : Public
74 -- Pre-Req :
75 -- Parameters:
76 -- IN
77 -- p_api_version_number IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80 -- P_CSP_Rec IN CSP_Rec_Type Required
81 --
82 -- OUT:
83 -- x_return_status OUT NOCOPY VARCHAR2
84 -- x_msg_count OUT NOCOPY NUMBER
85 -- x_msg_data OUT NOCOPY VARCHAR2
86 -- Version : Current version 1.0
87 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
88 -- and basic operation, developer must manually add parameters and business logic as necessary.
89 --
90 -- End of Comments
91 --
92 Procedure ASSIGN_RESOURCE_INV_LOC (
93 P_Api_Version_Number IN NUMBER
94 ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
95 ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
96 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97 ,p_action_code IN NUMBER
98 ,px_CSP_INV_LOC_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
99 ,p_CREATED_BY IN NUMBER
100 ,p_CREATION_DATE IN DATE
101 ,p_LAST_UPDATED_BY IN NUMBER
102 ,p_LAST_UPDATE_DATE IN DATE
103 ,p_LAST_UPDATE_LOGIN IN NUMBER
104 ,p_RESOURCE_ID IN NUMBER
105 ,p_ORGANIZATION_ID IN NUMBER
106 ,p_SUBINVENTORY_CODE IN VARCHAR2
107 ,p_LOCATOR_ID IN NUMBER
108 ,p_RESOURCE_TYPE IN VARCHAR2
109 ,p_EFFECTIVE_DATE_START IN DATE
110 ,p_EFFECTIVE_DATE_END IN DATE
111 ,p_DEFAULT_CODE IN VARCHAR2
112 ,p_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL
113 ,p_ATTRIBUTE1 IN VARCHAR2 := NULL
114 ,p_ATTRIBUTE2 IN VARCHAR2 := NULL
115 ,p_ATTRIBUTE3 IN VARCHAR2 := NULL
116 ,p_ATTRIBUTE4 IN VARCHAR2 := NULL
117 ,p_ATTRIBUTE5 IN VARCHAR2 := NULL
118 ,p_ATTRIBUTE6 IN VARCHAR2 := NULL
119 ,p_ATTRIBUTE7 IN VARCHAR2 := NULL
120 ,p_ATTRIBUTE8 IN VARCHAR2 := NULL
121 ,p_ATTRIBUTE9 IN VARCHAR2 := NULL
122 ,p_ATTRIBUTE10 IN VARCHAR2 := NULL
123 ,p_ATTRIBUTE11 IN VARCHAR2 := NULL
124 ,p_ATTRIBUTE12 IN VARCHAR2 := NULL
125 ,p_ATTRIBUTE13 IN VARCHAR2 := NULL
126 ,p_ATTRIBUTE14 IN VARCHAR2 := NULL
127 ,p_ATTRIBUTE15 IN VARCHAR2 := NULL
128 ,x_return_status OUT NOCOPY VARCHAR2
129 ,x_msg_count OUT NOCOPY NUMBER
130 ,x_msg_data OUT NOCOPY VARCHAR2
131 );
132
133
134 PROCEDURE Validate_Assignment_Record (
135 p_resource_id IN NUMBER
136 ,p_resource_type IN VARCHAR2
137 ,p_organization_id IN NUMBER
138 ,p_subinventory_code IN VARCHAR2
139 ,p_default_code IN VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 );
142
143 End CSP_RESOURCE_PUB;