[Home] [Help]
PACKAGE: APPS.CMP_CONTROLLER
Source
1 PACKAGE CMP_Controller AS
2 /* $Header: ENGCCMPS.pls 120.0 2005/05/26 19:04:47 appldev noship $ */
3
4 -- Global Record Type:
5 -- The ECO form declares a revised component controller record of this type
6 -- to send in user-entered information that requires processing.
7
8 TYPE Controller_CMP_Rec_Type IS RECORD
9 ( Change_Notice VARCHAR2(10) := NULL
10 , Organization_Code VARCHAR2(3) := NULL
11 , Revised_Item_Name VARCHAR2(700) := NULL
12 , New_Item_Revision VARCHAR2(3) := NULL
13 , Scheduled_Date DATE := NULL
14 , Disable_Date DATE := NULL
15 , Operation_Sequence_Number NUMBER := NULL
16 , Old_Operation_Sequence_Number NUMBER := NULL
17 , Old_Effectivity_Date DATE := NULL
18 , Old_from_end_item_unit_number VARCHAR2(30) := NULL
19 , New_Operation_Sequence_Number NUMBER := NULL
20 , Component_Item_Name VARCHAR2(700) := NULL
21 , Alternate_BOM_Code VARCHAR2(10) := NULL
22 , ACD_Type NUMBER := NULL
23 , Item_Sequence_Number NUMBER := NULL
24 , Component_Quantity NUMBER := NULL
25 , Planning_Factor NUMBER := NULL
26 , Component_Yield_Factor NUMBER := NULL
27 , Include_In_Cost_Rollup NUMBER := NULL
28 , Wip_Supply NUMBER := NULL
29 , So_Basis NUMBER := NULL
30 , Optional NUMBER := NULL
31 , Mutually_Exclusive NUMBER := NULL
32 , Check_Atp NUMBER := NULL
33 , Shipping_Allowed NUMBER := NULL
34 , Required_To_Ship NUMBER := NULL
35 , Required_For_Revenue NUMBER := NULL
36 , Include_On_Ship_Docs NUMBER := NULL
37 , Quantity_Related NUMBER := NULL
38 , Supply_Subinventory VARCHAR2(10) := NULL
39 , Supply_Locator VARCHAR2(81) := NULL
40 , Low_Quantity NUMBER := NULL
41 , High_Quantity NUMBER := NULL
42 , Component_Remarks VARCHAR2(240) := NULL
43 , cancel_comments VARCHAR2(240) := NULL
44 , Attribute_category VARCHAR2(30) := NULL
45 , Attribute1 VARCHAR2(150) := NULL
46 , Attribute2 VARCHAR2(150) := NULL
47 , Attribute3 VARCHAR2(150) := NULL
48 , Attribute4 VARCHAR2(150) := NULL
49 , Attribute5 VARCHAR2(150) := NULL
50 , Attribute6 VARCHAR2(150) := NULL
51 , Attribute7 VARCHAR2(150) := NULL
52 , Attribute8 VARCHAR2(150) := NULL
53 , Attribute9 VARCHAR2(150) := NULL
54 , Attribute10 VARCHAR2(150) := NULL
55 , Attribute11 VARCHAR2(150) := NULL
56 , Attribute12 VARCHAR2(150) := NULL
57 , Attribute13 VARCHAR2(150) := NULL
58 , Attribute14 VARCHAR2(150) := NULL
59 , Attribute15 VARCHAR2(150) := NULL
60 , From_End_Item_Unit_Number VARCHAR2(30) := NULL
61 , To_End_Item_Unit_Number VARCHAR2(30) := NULL
62 , Return_Status VARCHAR2(1) := NULL
63 , Transaction_Type VARCHAR2(30) := NULL
64 , Organization_Id NUMBER := NULL
65 , Component_Item_Id NUMBER := NULL
66 , Old_Component_Sequence_Id NUMBER := NULL
67 , Component_Sequence_Id NUMBER := NULL
68 , Bill_Sequence_Id NUMBER := NULL
69 , Pick_Components NUMBER := NULL
70 , Supply_Locator_Id NUMBER := NULL
71 , Revised_Item_Sequence_Id NUMBER := NULL
72 , Bom_Item_Type NUMBER := NULL
73 , Revised_Item_Id NUMBER := NULL
74 , Include_On_Bill_Docs NUMBER := NULL
75 , Enforce_Int_Requirements VARCHAR2(80) := NULL
76 , Enforce_Int_Requirements_Code NUMBER := NULL
77 , Basis_Type NUMBER := NULL
78 );
79
80 -- Procedure Initialize_Record
81
82 PROCEDURE Initialize_Record
83 ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
84 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
85 , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
86 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
87 , x_return_status OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE Validate_And_Write
91 ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
92 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
93 , p_record_status IN VARCHAR2
94 , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
95 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
96 , x_return_status OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE Delete_Row
100 ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
101 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
102 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
103 , x_return_status OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Change_Attribute
107 ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
108 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
109 , p_record_status IN VARCHAR2
110 , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
111 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
112 , x_return_status OUT NOCOPY VARCHAR2
113 );
114
115 /*PROCEDURE Lock_Row
116 ( x_return_status OUT NOCOPY VARCHAR2
117 , x_err_text OUT NOCOPY VARCHAR2
118 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
119 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
120 );
121 */
122
123 END CMP_Controller;