[Home] [Help]
PACKAGE: APPS.CTO_CONFIGURED_ITEM_GRP
Source
1 package CTO_Configured_Item_GRP AUTHID CURRENT_USER AS
2 /* $Header: CTOGCFGS.pls 115.5 2004/04/27 20:04:11 kkonada noship $*/
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
94
95 -- Start of comments
96 -- API name : MATCH_CONFIGURED_ITEM
97 -- Type : Group
98 -- Function :To match configured items
99 -- Pre-reqs :1. table BOMC_TO_ORDER_LINES_TEMP
100 -- Parameters :
101 -- IN : p_api_version IN NUMBER Required
102 -- p_init_msg_list IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Optional
105 -- Default = FND_API.G_FALSE
106 -- Action IN VARCHAR2(30)
107 -- Source IN VARCHAR2(30)
108 -- p_cto_match_rec IN OUT CTO_MATCH_REC_TYPE .
109 -- .
110 -- OUT : x_return_status OUT VARCHAR2(1)
111 -- x_msg_count OUT NUMBER
112 -- x_msg_data OUT VARCHAR2(2000)
113 -- x_match_found OUT Varchar2(1) Y/N
114 -- .
115 -- Version : Current version 1.0
116 -- Changed....
117 --
118 -- Initial version 1.0
119 --
120 -- Notes : Note text
121 --
122 -- End of comments
123 PROCEDURE MATCH_CONFIGURED_ITEM
124 (
125 --std parameters
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
128 p_commit IN VARCHAR2 default FND_API.G_FALSE,
129 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133
134 --program parameters
135 p_Action IN VARCHAR2,
136 p_Source IN VARCHAR2 ,
137
138 p_cto_match_rec IN OUT NOCOPY CTO_MATCH_REC_TYPE
139
140 );
141
142
143
144
145 END CTO_Configured_Item_GRP;