[Home] [Help]
PACKAGE: APPS.GMD_SUBSTITUTION_PUB
Source
1 PACKAGE GMD_SUBSTITUTION_PUB AS
2 /* $Header: GMDPSUBS.pls 120.0.12000000.1 2007/01/31 16:16:27 appldev noship $ */
3
4 m_api_version CONSTANT NUMBER := 1;
5 m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_SUBSTITUTION_PUB';
6
7 /* define record and table type to specify the column that needs to
8 updated */
9 TYPE update_table_rec_type IS RECORD
10 (
11 p_col_to_update VARCHAR2(240)
12 , p_value VARCHAR2(240)
13 );
14
15 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
16
17 TYPE gmd_substitution_hdr_rec_type IS RECORD
18 (
19 SUBSTITUTION_NAME gmd_item_substitution_hdr_b.substitution_name%TYPE
20 , SUBSTITUTION_DESCRIPTION gmd_item_substitution_hdr_tl.substitution_description%TYPE
21 , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22 , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23 , ORIGINAL_ITEM_NO VARCHAR2(1000)
24 , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25 , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26 , START_DATE DATE := trunc(SYSDATE)
27 , END_DATE DATE
28 , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29 , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30 , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31 , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32 , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33 , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34 , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35 , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36 , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37 , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38 , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39 , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40 , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41 , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42 , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43 , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44 , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45 , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46 , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47 , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48 , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49 , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50 , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51 , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52 , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53 , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54 , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55 , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56 , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57 , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58 , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59 , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60 , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61 , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62 , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63 , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64 , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65 , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
66 );
67
68 TYPE gmd_substitution_dtl_rec_type IS RECORD
69 (
70 INVENTORY_ITEM_ID gmd_item_substitution_dtl.inventory_item_id%TYPE
71 , ITEM_NO VARCHAR2(1000)
72 , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73 , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74 , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75 , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76 , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77 , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78 , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
79 );
80
81 TYPE gmd_fmsubstitution_rec_type IS RECORD
82 (
83 FORMULA_ID gmd_formula_substitution.formula_id%TYPE
84 , FORMULA_NO fm_form_mst_b.formula_no%TYPE
85 , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86 , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87 , CREATED_BY gmd_formula_substitution.created_by%TYPE
88 , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89 , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90 , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91 );
92
93 TYPE gmd_formula_substitution_tab IS TABLE OF gmd_fmsubstitution_rec_type
94 INDEX BY BINARY_INTEGER;
95
96 -- Creation of substitution header, detail and formula association
97 PROCEDURE Create_substitution
98 (
99 p_api_version IN NUMBER
100 , p_init_msg_list IN VARCHAR2
101 , p_commit IN VARCHAR2
102 , p_substitution_hdr_rec IN gmd_substitution_hdr_rec_type
103 , p_substitution_dtl_rec IN gmd_substitution_dtl_rec_type
104 , p_formula_substitution_tbl IN gmd_formula_substitution_tab
105 , x_message_count OUT NOCOPY NUMBER
106 , x_message_list OUT NOCOPY VARCHAR2
107 , x_return_status OUT NOCOPY VARCHAR2
108 );
109
110 -- Creation of formula association
111 PROCEDURE Create_formula_association
112 (
113 p_api_version IN NUMBER
114 , p_init_msg_list IN VARCHAR2
115 , p_commit IN VARCHAR2
116 , p_substitution_id IN NUMBER Default NULL
117 , p_substitution_name IN VARCHAR2 Default NULL
118 , p_substitution_version IN NUMBER Default NULL
119 , p_formula_substitution_tbl IN gmd_formula_substitution_tab
120 , x_message_count OUT NOCOPY NUMBER
121 , x_message_list OUT NOCOPY VARCHAR2
122 , x_return_status OUT NOCOPY VARCHAR2
123 );
124
125 -- Update of substitution header
126 PROCEDURE Update_substitution_header
127 ( p_api_version IN NUMBER
128 , p_init_msg_list IN VARCHAR2
129 , p_commit IN VARCHAR2
130 , p_substitution_id IN NUMBER Default NULL
131 , p_substitution_name IN VARCHAR2 Default NULL
132 , p_substitution_version IN NUMBER Default NULL
133 , p_update_table IN update_tbl_type
134 , x_message_count OUT NOCOPY NUMBER
135 , x_message_list OUT NOCOPY VARCHAR2
136 , x_return_status OUT NOCOPY VARCHAR2
137 );
138
139 -- Update of substitution lines
140 PROCEDURE Update_substitution_detail
141 ( p_api_version IN NUMBER
142 , p_init_msg_list IN VARCHAR2
143 , p_commit IN VARCHAR2
144 , p_substitution_line_id IN NUMBER Default NULL
145 , p_substitution_id IN NUMBER Default NULL
146 , p_substitution_name IN VARCHAR2 Default NULL
147 , p_substitution_version IN NUMBER Default NULL
148 , p_update_table IN update_tbl_type
149 , x_message_count OUT NOCOPY NUMBER
150 , x_message_list OUT NOCOPY VARCHAR2
151 , x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 -- Deletion of formula association
155 PROCEDURE Delete_formula_association
156 ( p_api_version IN NUMBER
157 , p_init_msg_list IN VARCHAR2
158 , p_commit IN VARCHAR2
159 , p_formula_substitution_id IN NUMBER Default NULL
160 , p_substitution_id IN NUMBER Default NULL
161 , p_substitution_name IN VARCHAR2 Default NULL
162 , p_substitution_version IN NUMBER Default NULL
163 , p_formula_id IN NUMBER Default NULL
164 , p_formula_no IN VARCHAR2 Default NULL
165 , p_formula_vers IN NUMBER Default NULL
166 , x_message_count OUT NOCOPY NUMBER
167 , x_message_list OUT NOCOPY VARCHAR2
168 , x_return_status OUT NOCOPY VARCHAR2
169 );
170
171
172 END GMD_SUBSTITUTION_PUB;