[Home] [Help]
PACKAGE: APPS.WIP_REPETITIVE_ENTITY
Source
1 PACKAGE WIP_REPETITIVE_ENTITY AUTHID CURRENT_USER as
2 /* $Header: wiprents.pls 115.7 2002/11/29 15:27:23 rmahidha ship $ */
3
4 /*==========================================================================+
5 PROCEDURE
6 Create_Entity
7
8 PURPOSE
9 Create wip entity in table wip_entities and wip_repetitive_items.
10
11 EXCEPTIONS
12
13
14 NOTES
15
16 +==========================================================================*/
17
18 procedure create_entity(p_rowid IN OUT NOCOPY VARCHAR2,
19 p_wip_entity_id IN OUT NOCOPY NUMBER,
20 p_wip_entity_name VARCHAR2,
21 p_description VARCHAR2,
22 p_line_Id NUMBER,
23 p_organization_id NUMBER,
24 p_primary_item_id NUMBER,
25 p_alternate_bom_designator VARCHAR2,
26 p_alternate_routing_designator VARCHAR2,
27 p_class_code VARCHAR2,
28 p_wip_supply_type NUMBER,
29 p_completion_subinventory VARCHAR2,
30 p_completion_locator_id NUMBER,
31 p_load_distribution_priority NUMBER,
32 p_primary_line_flag NUMBER,
33 p_production_line_rate NUMBER,
34 p_overcompletion_toleran_type NUMBER,
35 p_overcompletion_toleran_value NUMBER,
36 p_attribute_category VARCHAR2,
37 p_attribute1 VARCHAR2,
38 p_attribute2 VARCHAR2,
39 p_attribute3 VARCHAR2,
40 p_attribute4 VARCHAR2,
41 p_attribute5 VARCHAR2,
42 p_attribute6 VARCHAR2,
43 p_attribute7 VARCHAR2,
44 p_attribute8 VARCHAR2,
45 p_attribute9 VARCHAR2,
46 p_attribute10 VARCHAR2,
47 p_attribute11 VARCHAR2,
48 p_attribute12 VARCHAR2,
49 p_attribute13 VARCHAR2,
50 p_attribute14 VARCHAR2,
51 p_attribute15 VARCHAR2);
52
53
54
55 /*==========================================================================+
56 PROCEDURE
57 Delete_Entity
58
59 PURPOSE
60 Delete wip entity in wip_repetitive_items. If the record being
61 deleted is the last instance in wip_repetitive_items, the entity
62 will be deleted in wip_entities.
63
64 EXCEPTIONS
65
66
67 NOTES
68
69 +==========================================================================*/
70
71 procedure delete_entity(p_wip_entity_id IN OUT NOCOPY NUMBER,
72 p_org_id NUMBER,
73 p_rowid VARCHAR2);
74
75
76
77 /*==========================================================================+
78 PROCEDURE
79 Update_Entity
80
81 PURPOSE
82 Update information in wip_repetitive_items.
83
84 EXCEPTIONS
85
86
87 NOTES
88
89 +==========================================================================*/
90
91 procedure update_entity(p_rowid VARCHAR2,
92 p_wip_entity_id NUMBER,
93 p_line_Id NUMBER,
94 p_organization_id NUMBER,
95 p_primary_item_id NUMBER,
96 p_alternate_bom_designator VARCHAR2,
97 p_alternate_routing_designator VARCHAR2,
98 p_class_code VARCHAR2,
99 p_wip_supply_type NUMBER,
100 p_completion_subinventory VARCHAR2,
101 p_completion_locator_id NUMBER,
102 p_load_distribution_priority NUMBER,
103 p_primary_line_flag NUMBER,
104 p_production_line_rate NUMBER,
105 p_overcompletion_toleran_type NUMBER,
106 p_overcompletion_toleran_value NUMBER,
107 p_attribute_category VARCHAR2,
108 p_attribute1 VARCHAR2,
109 p_attribute2 VARCHAR2,
110 p_attribute3 VARCHAR2,
111 p_attribute4 VARCHAR2,
112 p_attribute5 VARCHAR2,
113 p_attribute6 VARCHAR2,
114 p_attribute7 VARCHAR2,
115 p_attribute8 VARCHAR2,
116 p_attribute9 VARCHAR2,
117 p_attribute10 VARCHAR2,
118 p_attribute11 VARCHAR2,
119 p_attribute12 VARCHAR2,
120 p_attribute13 VARCHAR2,
121 p_attribute14 VARCHAR2,
122 p_attribute15 VARCHAR2);
123 end WIP_REPETITIVE_ENTITY;