[Home] [Help]
PACKAGE: APPS.ENG_REV_COMPONENT_UTIL
Source
1 PACKAGE ENG_Rev_Component_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGUCMPS.pls 115.12 2002/12/12 18:05:09 akumar ship $ */
3
4 -- Attributes global constants
5
6 G_SUPPLY_SUBINVENTORY CONSTANT NUMBER := 1;
7 G_OP_LEAD_TIME_PERCENT CONSTANT NUMBER := 2;
8 G_REVISED_ITEM_SEQUENCE CONSTANT NUMBER := 3;
9 G_COST_FACTOR CONSTANT NUMBER := 4;
10 G_REQUIRED_FOR_REVENUE CONSTANT NUMBER := 5;
11 G_HIGH_QUANTITY CONSTANT NUMBER := 6;
12 G_COMPONENT_SEQUENCE CONSTANT NUMBER := 7;
13 G_PROGRAM_APPLICATION CONSTANT NUMBER := 8;
14 G_WIP_SUPPLY_TYPE CONSTANT NUMBER := 9;
15 G_SUPPLY_LOCATOR CONSTANT NUMBER := 10;
16 G_BOM_ITEM_TYPE CONSTANT NUMBER := 11;
17 G_OPERATION_SEQ_NUM CONSTANT NUMBER := 12;
18 G_COMPONENT_ITEM CONSTANT NUMBER := 13;
19 G_LAST_UPDATE_DATE CONSTANT NUMBER := 14;
20 G_LAST_UPDATED_BY CONSTANT NUMBER := 15;
21 G_CREATION_DATE CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 18;
24 G_ITEM_NUM CONSTANT NUMBER := 19;
25 G_COMPONENT_QUANTITY CONSTANT NUMBER := 20;
26 G_COMPONENT_YIELD_FACTOR CONSTANT NUMBER := 21;
27 G_COMPONENT_REMARKS CONSTANT NUMBER := 22;
28 G_EFFECTIVITY_DATE CONSTANT NUMBER := 23;
29 G_CHANGE_NOTICE CONSTANT NUMBER := 24;
30 G_IMPLEMENTATION_DATE CONSTANT NUMBER := 25;
31 G_DISABLE_DATE CONSTANT NUMBER := 26;
32 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 27;
33 G_ATTRIBUTE1 CONSTANT NUMBER := 28;
34 G_ATTRIBUTE2 CONSTANT NUMBER := 29;
35 G_ATTRIBUTE3 CONSTANT NUMBER := 30;
36 G_ATTRIBUTE4 CONSTANT NUMBER := 31;
37 G_ATTRIBUTE5 CONSTANT NUMBER := 32;
38 G_ATTRIBUTE6 CONSTANT NUMBER := 33;
39 G_ATTRIBUTE7 CONSTANT NUMBER := 34;
40 G_ATTRIBUTE8 CONSTANT NUMBER := 35;
41 G_ATTRIBUTE9 CONSTANT NUMBER := 36;
42 G_ATTRIBUTE10 CONSTANT NUMBER := 37;
43 G_ATTRIBUTE11 CONSTANT NUMBER := 38;
44 G_ATTRIBUTE12 CONSTANT NUMBER := 39;
45 G_ATTRIBUTE13 CONSTANT NUMBER := 40;
46 G_ATTRIBUTE14 CONSTANT NUMBER := 41;
47 G_ATTRIBUTE15 CONSTANT NUMBER := 42;
48 G_PLANNING_FACTOR CONSTANT NUMBER := 43;
49 G_QUANTITY_RELATED CONSTANT NUMBER := 44;
50 G_SO_BASIS CONSTANT NUMBER := 45;
51 G_OPTIONAL CONSTANT NUMBER := 46;
52 G_MUTUALLY_EXCLUSIVE_OPT CONSTANT NUMBER := 47;
53 G_INCLUDE_IN_COST_ROLLUP CONSTANT NUMBER := 48;
54 G_CHECK_ATP CONSTANT NUMBER := 49;
55 G_SHIPPING_ALLOWED CONSTANT NUMBER := 50;
56 G_REQUIRED_TO_SHIP CONSTANT NUMBER := 51;
57 G_INCLUDE_ON_SHIP_DOCS CONSTANT NUMBER := 52;
58 G_INCLUDE_ON_BILL_DOCS CONSTANT NUMBER := 53;
59 G_LOW_QUANTITY CONSTANT NUMBER := 54;
60 G_ACD_TYPE CONSTANT NUMBER := 55;
61 G_OLD_COMPONENT_SEQUENCE CONSTANT NUMBER := 56;
62 G_BILL_SEQUENCE CONSTANT NUMBER := 57;
63 G_REQUEST CONSTANT NUMBER := 58;
64 G_PROGRAM CONSTANT NUMBER := 59;
65 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 60;
66 G_PICK_COMPONENTS CONSTANT NUMBER := 61;
67 G_MAX_ATTR_ID CONSTANT NUMBER := 62;
68
69
70 -- PROCEDURE Convert_Miss_To_Null
71
72 PROCEDURE Convert_Miss_To_Null
73 ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
74 , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
75 , x_Rev_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
76 , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
77 );
78
79 -- Function Query_Row
80
81 PROCEDURE Query_Row
82 ( p_Component_Item_Id IN NUMBER
83 , p_Operation_Sequence_Number IN NUMBER
84 , p_Effectivity_Date IN DATE
85 , p_Bill_Sequence_Id IN NUMBER
86 , p_from_end_item_number IN VARCHAR2 := NULL
87 , x_Rev_Component_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
88 , x_Rev_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
89 , x_Return_Status OUT NOCOPY VARCHAR2
90 );
91
92 -- Procedure lock_Row
93 --
94
95 PROCEDURE Lock_Row
96 ( x_return_status OUT NOCOPY VARCHAR2
97 , p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
98 , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
99 , x_err_text OUT NOCOPY VARCHAR2
100 );
101
102
103 PROCEDURE Create_New_Bill( p_assembly_item_id IN NUMBER
104 , p_organization_id IN NUMBER
105 , p_pending_from_ecn IN VARCHAR2
106 , p_bill_sequence_id IN NUMBER
107 , p_common_bill_sequence_id IN NUMBER
108 , p_assembly_type IN NUMBER
109 , p_last_update_date IN DATE
110 , p_last_updated_by IN NUMBER
111 , p_creation_date IN DATE
112 , p_created_by IN NUMBER
113 , p_revised_item_seq_id IN NUMBER
114 , p_original_system_reference IN VARCHAR2
115 );
116
117
118 PROCEDURE Perform_Writes( p_rev_component_rec IN
119 Bom_Bo_Pub.Rev_Component_Rec_Type
120 , p_rev_comp_unexp_rec IN
121 Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
122 , x_Mesg_Token_Tbl OUT NOCOPY
123 Error_Handler.Mesg_Token_Tbl_Type
124 , x_Return_Status OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE Cancel_Component( p_component_sequence_id IN NUMBER
128 , p_cancel_comments IN VARCHAR2
129 , p_user_id IN NUMBER
130 , p_login_id IN NUMBER
131 );
132
133 END ENG_Rev_Component_Util;