1 package CTO_Configured_Item_GRP AUTHID CURRENT_USER AS
2 /* $Header: CTOGCFGS.pls 120.0.12020000.4 2013/03/29 10:06:05 abhissri ship $*/
3 /*----------------------------------------------------------------------------+
4 | Copyright (c) 2003 Oracle Corporation RedwoodShores, California, USA
5 | All rights reserved.
6 | Oracle Manufacturing
7 |
8 |FILE NAME : CTOGCFGS.pls
9 |
10 |DESCRIPTION : Contains modules to :
11 |
12 |
13 |HISTORY :
14 |
15 | 09-05-2003 Created by KKONADA
16 | Group API to be used by other products
17 | and internally for matching
18 |
19 | 10-10-2003 KKONADA
20 | Match_item_id
21 | gop_index are removed
22 |
23 | 10-21-2002 KKONADA
24 | removing parameter x_match_found as
25 | mutiple thsi result for multiple order lines doesnot make
26 | sense
27 |--------------------------------------------------------------------------------
28 */
29
30
31 TYPE number_arr_tbl_type IS TABLE OF number index by binary_integer;
32 TYPE char1_arr_tbl_type IS TABLE of varchar2(1) index by binary_integer;
33 TYPE char3_arr_tbl_type IS TABLE OF varchar2(3) index by binary_integer;
34 TYPE char30_arr_tbl_type IS TABLE OF varchar2(30) index by binary_integer;
35 TYPE char1000_arr_tbl_type IS TABLE of varchar2(1000) index by binary_integer;
36 TYPE char2000_arr_tbl_type IS TABLE of varchar2(2000) index by binary_integer;
37 TYPE date_arr_tbl_type IS TABLE OF date;
38
39 TYPE CTO_MATCH_REC_TYPE IS RECORD
40 (
41 CONFIG_ITEM_ID number_arr_tbl_type,
42 LINE_ID number_arr_tbl_type,
43 LINK_TO_LINE_ID number_arr_tbl_type,
44 ATO_LINE_ID number_arr_tbl_type,
45 TOP_MODEL_LINE_ID number_arr_tbl_type,
46 INVENTORY_ITEM_ID number_arr_tbl_type,
47 COMPONENT_CODE char1000_arr_tbl_type,
48 COMPONENT_SEQUENCE_ID number_arr_tbl_type ,
49 VALIDATION_ORG number_arr_tbl_type ,
50 QTY_PER_PARENT_MODEL number_arr_tbl_type , -- ordered qty per unit ,
51 --CTO passes and calcuated for GOp
52 ORDERED_QUANTITY number_arr_tbl_type ,--order qty passed by GOP
53 ORDER_QUANTITY_UOM char3_arr_tbl_type ,
54 PARENT_ATO_LINE_ID number_arr_tbl_type ,
55 GOP_PARENT_ATO_LINE_ID number_arr_tbl_type ,
56 PERFORM_MATCH char1_arr_tbl_type ,
57 PLAN_LEVEL number_arr_tbl_type ,
58 BOM_ITEM_TYPE number_arr_tbl_type ,
59 WIP_SUPPLY_TYPE char30_arr_tbl_type ,
60 OSS_ERROR_CODE number_arr_tbl_type ,
61 SHIP_FROM_ORG_ID number_arr_tbl_type ,--3503764, to get ship_from_org_id from ATP
62 Attribute_1 number_arr_tbl_type ,
63 Attribute_2 number_arr_tbl_type ,
64 Attribute_3 char2000_arr_tbl_type ,
65 Attribute_4 char2000_arr_tbl_type ,
66 Attribute_5 char2000_arr_tbl_type ,
67 Attribute_6 date_arr_tbl_type ,
68 Attribute_7 date_arr_tbl_type ,
69 Attribute_8 date_arr_tbl_type ,
70 Attribute_9 number_arr_tbl_type
71
72 );
73
74 TYPE TEMP_REC_TYPE IS RECORD
75 (
76 l_index number,
77 line_id number,
78 link_to_line_id number,
79 ato_line_id number,
80 top_model_line_id number,
81 parent_ato_line_id number,
82 gop_parent_ato_line_id number,
83 plan_level number,
84 bom_item_type number,
85 wip_supply_type number
86
87
88 );
89
90 TYPE TEMP_TAB_OF_REC_TYPE IS TABLE OF TEMP_REC_TYPE INDEX BY BINARY_INTEGER ;
91
92 --
93 -- bug 16352937
94 -- This is the old signature of the API that was overloaded
95 -- to add a new parameter to capture the hash value
96 --
97 PROCEDURE MATCH_CONFIGURED_ITEM
98 (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
101 p_commit IN VARCHAR2 default FND_API.G_FALSE,
102 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_Action IN VARCHAR2,
107 p_Source IN VARCHAR2 ,
108 p_cto_match_rec IN OUT NOCOPY CTO_MATCH_REC_TYPE
109 );
110
111
112
113 -- Start of comments
114 -- API name : MATCH_CONFIGURED_ITEM
115 -- Type : Group
116 -- Function :To match configured items
117 -- Pre-reqs :1. table BOMC_TO_ORDER_LINES_TEMP
118 -- Parameters :
119 -- IN : p_api_version IN NUMBER Required
120 -- p_init_msg_list IN VARCHAR2 Optional
121 -- Default = FND_API.G_FALSE
122 -- p_commit IN VARCHAR2 Optional
123 -- Default = FND_API.G_FALSE
124 -- Action IN VARCHAR2(30)
125 -- Source IN VARCHAR2(30)
126 -- p_cto_match_rec IN OUT CTO_MATCH_REC_TYPE .
127 -- .
128 -- OUT : x_return_status OUT VARCHAR2(1)
129 -- x_msg_count OUT NUMBER
130 -- x_msg_data OUT VARCHAR2(2000)
131 -- x_match_found OUT Varchar2(1) Y/N
132 -- .
133 -- Version : Current version 1.0
134 -- Changed....
135 --
136 -- Initial version 1.0
137 --
138 -- Notes : Note text
139 --
140 -- End of comments
141 PROCEDURE MATCH_CONFIGURED_ITEM
142 (
143 --std parameters
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
146 p_commit IN VARCHAR2 default FND_API.G_FALSE,
147 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 --program parameters
152 p_Action IN VARCHAR2,
153 p_Source IN VARCHAR2 ,
154 p_cto_match_rec IN OUT NOCOPY CTO_MATCH_REC_TYPE,
155 -- bug 16352937
156 -- Bugfix 16531547: hash_value should be a varchar variable.
157 -- x_hash_value OUT NOCOPY NUMBER
158 x_hash_value OUT NOCOPY VARCHAR2
159 );
160
161
162
163
164 END CTO_Configured_Item_GRP;