[Home] [Help]
PACKAGE: APPS.E_REV_ITEM_INT_PKG
Source
1 PACKAGE E_REV_ITEM_INT_PKG AUTHID CURRENT_USER as
2 /* $Header: bompiris.pls 120.1 2005/06/21 03:24:59 appldev ship $ */
3
4 PROCEDURE After_Delete(X_revised_item_sequence_id NUMBER);
5
6 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
7 X_Change_Notice VARCHAR2,
8 X_Organization_Id NUMBER,
9 X_Last_Update_Date DATE,
10 X_Last_Updated_By NUMBER,
11 X_Creation_Date DATE,
12 X_Created_By NUMBER,
13 X_Last_Update_Login NUMBER,
14 X_Scheduled_Date DATE,
15 X_Mrp_Active NUMBER,
16 X_Update_Wip NUMBER,
17 X_Use_Up NUMBER,
18 X_Use_Up_Item_Id NUMBER,
19 X_Revised_Item_Sequence_Id NUMBER,
20 X_Alternate_Bom_Designator VARCHAR2,
21 X_Category_Set_Id NUMBER,
22 X_Structure_Id NUMBER,
23 X_Item_From VARCHAR2,
24 X_Item_To VARCHAR2,
25 X_Category_From VARCHAR2,
26 X_Category_To VARCHAR2,
27 X_Increment_Rev NUMBER,
28 X_Item_Type VARCHAR2,
29 X_Use_Up_Plan_Name VARCHAR2,
30 X_Alternate_Selection_Code NUMBER,
31 X_Base_Item_Id NUMBER,
32 X_Submit_Request BOOLEAN,
33 X_model_item_access NUMBER,
34 X_planning_item_access NUMBER,
35 X_std_item_access NUMBER,
36 X_impl_code NUMBER,
37 X_report_code NUMBER,
38 X_delete_code NUMBER,
39 X_From_End_Item_Unit_Number VARCHAR2,
40 X_req_id IN OUT NOCOPY NUMBER
41 );
42
43 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
44 X_Change_Notice VARCHAR2,
45 X_Organization_Id NUMBER,
46 X_Scheduled_Date DATE,
47 X_Mrp_Active NUMBER,
48 X_Update_Wip NUMBER,
49 X_Use_Up NUMBER,
50 X_Use_Up_Item_Id NUMBER,
51 X_Revised_Item_Sequence_Id NUMBER,
52 X_Alternate_Bom_Designator VARCHAR2,
53 X_Category_Set_Id NUMBER,
54 X_Structure_Id NUMBER,
55 X_Item_From VARCHAR2,
56 X_Item_To VARCHAR2,
57 X_Category_From VARCHAR2,
58 X_Category_To VARCHAR2,
59 X_Increment_Rev NUMBER,
60 X_Item_Type VARCHAR2,
61 X_Use_Up_Plan_Name VARCHAR2,
62 X_Alternate_Selection_Code NUMBER,
63 X_Base_Item_Id NUMBER,
64 X_From_End_Item_Unit_Number VARCHAR2
65 );
66
67 PROCEDURE Update_Row(X_Rowid VARCHAR2,
68 X_Change_Notice VARCHAR2,
69 X_Organization_Id NUMBER,
70 X_Last_Update_Date DATE,
71 X_Last_Updated_By NUMBER,
72 X_Last_Update_Login NUMBER,
73 X_Scheduled_Date DATE,
74 X_Mrp_Active NUMBER,
75 X_Update_Wip NUMBER,
76 X_Use_Up NUMBER,
77 X_Use_Up_Item_Id NUMBER,
78 X_Revised_Item_Sequence_Id NUMBER,
79 X_Alternate_Bom_Designator VARCHAR2,
80 X_Category_Set_Id NUMBER,
81 X_Structure_Id NUMBER,
82 X_Item_From VARCHAR2,
83 X_Item_To VARCHAR2,
84 X_Category_From VARCHAR2,
85 X_Category_To VARCHAR2,
86 X_Increment_Rev NUMBER,
87 X_Item_Type VARCHAR2,
88 X_Use_Up_Plan_Name VARCHAR2,
89 X_Alternate_Selection_Code NUMBER,
90 X_Base_Item_Id NUMBER,
91 X_Submit_Request BOOLEAN,
92 X_model_item_access NUMBER,
93 X_planning_item_access NUMBER,
94 X_std_item_access NUMBER,
95 X_impl_code NUMBER,
96 X_report_code NUMBER,
97 X_delete_code NUMBER,
98 X_From_End_Item_Unit_Number VARCHAR2,
99 X_req_id IN OUT NOCOPY NUMBER
100 );
101 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
102
103 /* ERES
104 Need to declare this proc in the spec in order that it can be
105 invoked directly from the client code in an eSignature scenario
106 ==============================================================*/
107 PROCEDURE Call_Mass_Change (X_change_notice in varchar2,
108 X_org_id in NUMBER,
109 X_model_item_access in NUMBER,
110 X_planning_item_access in NUMBER,
111 X_std_item_access in NUMBER,
112 X_impl_code in NUMBER,
113 X_report_code in NUMBER,
114 X_delete_code in NUMBER,
115 X_req_id IN OUT NOCOPY NUMBER
116 );
117
118 END E_REV_ITEM_INT_PKG;