[Home] [Help]
PACKAGE: APPS.ENG_REVISED_ITEMS_PKG
Source
1 PACKAGE ENG_REVISED_ITEMS_PKG as
2 /* $Header: engprvis.pls 120.3 2006/07/07 13:42:08 pdutta noship $ */
3
4 FUNCTION Get_High_Rev_ECO (x_organization_id NUMBER,
5 x_revised_item_id NUMBER,
6 x_new_item_revision VARCHAR2) RETURN VARCHAR2;
7
8
9 FUNCTION Get_BOM_Lists_Seq_Id RETURN NUMBER;
10
11
12 PROCEDURE Insert_BOM_Lists (x_revised_item_id NUMBER,
13 x_sequence_id NUMBER,
14 x_bill_sequence_id NUMBER);
15
16
17 PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER);
18
19
20 PROCEDURE Delete_Details (x_organization_id NUMBER,
21 x_revised_item_id NUMBER,
22 x_revised_item_sequence_id NUMBER,
23 x_bill_sequence_id NUMBER,
24 x_change_notice VARCHAR2);
25
26
27 PROCEDURE Create_BOM (x_assembly_item_id NUMBER,
28 x_organization_id NUMBER,
29 x_alternate_BOM_designator VARCHAR2,
30 x_userid NUMBER,
31 x_change_notice VARCHAR2,
32 x_revised_item_sequence_id NUMBER,
33 x_bill_sequence_id NUMBER,
34 x_assembly_type NUMBER,
35 x_structure_type_id NUMBER);
36
37
38 PROCEDURE Insert_Current_Scheduled_Dates (x_change_notice VARCHAR2,
39 x_organization_id NUMBER,
40 x_revised_item_id NUMBER,
41 x_scheduled_date DATE,
42 x_revised_item_sequence_id NUMBER,
43 x_requestor_id NUMBER,
44 x_userid NUMBER);
45
46
47 PROCEDURE Delete_Item_Revisions (x_change_notice VARCHAR2,
48 x_organization_id NUMBER,
49 x_inventory_item_id NUMBER,
50 x_revised_item_sequence_id NUMBER);
51
52
53 PROCEDURE Insert_Item_Revisions (x_inventory_item_id NUMBER,
54 x_organization_id NUMBER,
55 x_revision VARCHAR2,
56 x_userid NUMBER,
57 x_change_notice VARCHAR2,
58 x_scheduled_date DATE,
59 x_revised_item_sequence_id NUMBER,
60 x_revision_description VARCHAR2 := NULL,
61 p_new_revision_label VARCHAR2 DEFAULT NULL,
62 p_new_revision_reason_code VARCHAR2 DEFAULT NULL,
63 p_from_revision_id NUMBER DEFAULT NULL);
64
65 PROCEDURE Insert_Item_Revisions (x_inventory_item_id NUMBER,
66 x_organization_id NUMBER,
67 x_revision VARCHAR2,
68 x_userid NUMBER,
69 x_change_notice VARCHAR2,
70 x_scheduled_date DATE,
71 x_revised_item_sequence_id NUMBER,
72 x_revision_description VARCHAR2 := NULL,
73 p_new_revision_label VARCHAR2 DEFAULT NULL,
74 p_new_revision_reason_code VARCHAR2 DEFAULT NULL,
75 p_from_revision_id NUMBER DEFAULT NULL,
76 x_new_revision_id IN OUT NOCOPY NUMBER);
77
78 PROCEDURE Update_Item_Revisions (x_revision VARCHAR2,
79 x_scheduled_date DATE,
80 x_change_notice VARCHAR2,
81 x_organization_id NUMBER,
82 x_inventory_item_id NUMBER,
83 x_revised_item_sequence_id NUMBER,
84 x_revision_description VARCHAR2 := NULL);
85
86
87 PROCEDURE Update_Inventory_Components (x_change_notice VARCHAR2,
88 x_bill_sequence_id NUMBER,
89 x_revised_item_sequence_id NUMBER,
90 x_scheduled_date DATE,
91 x_from_end_item_unit_number VARCHAR2 DEFAULT NULL);
92
93
94 -- Added for bug 3496165
95 /********************************************************************
96 * API Name : UPDATE_REVISION_CHANGE_NOTICE
97 * Parameters IN : p_revision_id, p_change_notice
98 * Parameters OUT: None
99 * Purpose : Updates the value of change_notice in the
100 * mtl_item_revisions_b/_tl table with the value passed as parameter
101 * for the row specified.
102 *********************************************************************/
103 PROCEDURE UPDATE_REVISION_CHANGE_NOTICE ( p_revision_id IN NUMBER
104 , p_change_notice IN VARCHAR2);
105
106 PROCEDURE Query_Target_Revised_Item (
107 p_api_version IN NUMBER := 1.0
108 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
109 -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111 , x_return_status OUT NOCOPY VARCHAR2
112 , x_msg_count OUT NOCOPY NUMBER
113 , x_msg_data OUT NOCOPY VARCHAR2
114 , p_change_id IN NUMBER
115 , p_organization_id IN NUMBER
116 , p_revised_item_id IN NUMBER
117 , p_revision_id IN NUMBER
118 , x_revised_item_seq_id OUT NOCOPY NUMBER
119 );
120
121 PROCEDURE Get_Component_Intf_Change_Dtls (
122 p_api_version IN NUMBER := 1.0
123 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
124 -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_msg_count OUT NOCOPY NUMBER
128 , x_msg_data OUT NOCOPY VARCHAR2
129 , p_change_id IN NUMBER
130 , p_change_notice IN VARCHAR2
131 , p_organization_id IN NUMBER
132 , p_revised_item_id IN NUMBER
133 , p_bill_sequence_id IN NUMBER
134 , p_component_item_id IN NUMBER
135 , p_effectivity_date IN DATE := NULL
136 , p_from_end_item_unit_number IN NUMBER := NULL
137 , p_from_end_item_rev_id IN NUMBER := NULL
138 , p_old_component_sequence_id IN NUMBER := NULL
139 , p_transaction_type IN VARCHAR2
140 , x_revised_item_sequence_id OUT NOCOPY NUMBER
141 , x_component_sequence_id OUT NOCOPY NUMBER
142 , x_acd_type OUT NOCOPY NUMBER
143 , x_change_transaction_type OUT NOCOPY VARCHAR2
144 ) ;
145
146 -- Bug 4290411
147 /********************************************************************
148 * API Name : Check_Rev_Comp_Editable
149 * Parameters IN : p_component_sequence_id
150 * Parameters OUT: x_rev_comp_editable_flag
151 * Purpose : The API is called from bom explosion to check if
152 * revised component is editable.
153 * This api does not check change header status/workflow
154 * and user access as PW already handles this.
155 *********************************************************************/
156 PROCEDURE Check_Rev_Comp_Editable (
157 p_component_sequence_id IN NUMBER
158 , x_rev_comp_editable_flag OUT NOCOPY VARCHAR2 -- FND_API.G_TRUE, FND_API.G_FALSE
159 );
160
161 END ENG_REVISED_ITEMS_PKG ;