[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_GROUPS_PVT
Source
1 PACKAGE CSD_REPAIR_GROUPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: csdvrpgs.pls 115.8 2002/11/15 22:43:40 swai noship $ */
3
4 ----------------------------------------------------
5 -- Record name : REPAIR_ORDER_GROUP_REC
6 -- description : Group Repair Order Record
7 --
8 ----------------------------------------------------
9 TYPE REPAIR_ORDER_GROUP_REC IS RECORD
10 (
11 repair_group_id NUMBER,
12 incident_id NUMBER,
13 repair_group_number VARCHAR2(30),
14 repair_type_id NUMBER,
15 wip_entity_id NUMBER,
16 inventory_item_id NUMBER,
17 unit_of_measure VARCHAR2(3),
18 group_quantity NUMBER,
19 repair_order_quantity NUMBER,
20 rma_quantity NUMBER,
21 received_quantity NUMBER,
22 approved_quantity NUMBER,
23 submitted_quantity NUMBER,
24 completed_quantity NUMBER,
25 released_quantity NUMBER,
26 shipped_quantity NUMBER,
27 created_by NUMBER,
28 creation_date DATE,
29 last_updated_by NUMBER,
30 last_update_date DATE,
31 last_update_login NUMBER,
32 context VARCHAR2(240),
33 attribute1 VARCHAR2(100),
34 attribute2 VARCHAR2(100),
35 attribute3 VARCHAR2(100),
36 attribute4 VARCHAR2(100),
37 attribute5 VARCHAR2(100),
38 attribute6 VARCHAR2(100),
39 attribute7 VARCHAR2(100),
40 attribute8 VARCHAR2(100),
41 attribute9 VARCHAR2(100),
42 attribute10 VARCHAR2(100),
43 attribute11 VARCHAR2(100),
44 attribute12 VARCHAR2(100),
45 attribute13 VARCHAR2(100),
46 attribute14 VARCHAR2(100),
47 attribute15 VARCHAR2(100),
48 security_group_id NUMBER,
49 object_version_number NUMBER,
50 group_txn_status VARCHAR2(30),
51 group_approval_status VARCHAR2(30),
52 repair_mode VARCHAR2(30)
53 );
54
55 ----------------------------------------------------
56 -- procedure name: create_repair_groups
57 -- description : procedure used to create
58 -- group repair orders
59 --
60 ----------------------------------------------------
61
62 PROCEDURE CREATE_REPAIR_GROUPS
63 ( p_api_version IN NUMBER,
64 p_commit IN VARCHAR2,
65 p_init_msg_list IN VARCHAR2,
66 p_validation_level IN NUMBER,
67 x_repair_order_group_rec IN OUT NOCOPY CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC,
68 x_repair_group_id OUT NOCOPY NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2 );
72
73
74 ----------------------------------------------------
75 -- procedure name: update_repair_groups
76 -- description : procedure used to update
77 -- group repair orders
78 --
79 ----------------------------------------------------
80
81 PROCEDURE UPDATE_REPAIR_GROUPS
82 ( p_api_version IN NUMBER,
83 p_commit IN VARCHAR2,
84 p_init_msg_list IN VARCHAR2,
85 p_validation_level IN NUMBER,
86 x_repair_order_group_rec IN OUT NOCOPY CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2 );
90
91 ----------------------------------------------------
92 -- procedure name: delete_repair_groups
93 -- description : procedure used to delete
94 -- group repair orders
95 --
96 ----------------------------------------------------
97
98 PROCEDURE DELETE_REPAIR_GROUPS
99 ( p_api_version IN NUMBER,
100 p_commit IN VARCHAR2,
101 p_init_msg_list IN VARCHAR2,
102 p_validation_level IN NUMBER,
103 p_repair_group_id IN NUMBER,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2 );
107
108 ----------------------------------------------------
109 -- procedure name: lock_repair_groups
110 -- description : procedure used to lock
111 -- group repair orders
112 --
113 ----------------------------------------------------
114
115 PROCEDURE LOCK_REPAIR_GROUPS
116 ( p_api_version IN NUMBER,
117 p_commit IN VARCHAR2,
118 p_init_msg_list IN VARCHAR2,
119 p_validation_level IN NUMBER,
120 p_repair_order_group_rec IN REPAIR_ORDER_GROUP_REC,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2 );
124
125
126 -----------------------------------------------------------
127 -- procedure name: apply_to_group
128 -- description : procedure used to update promise_date
129 -- approval_req_flag,resource for all the
130 -- repair orders of the group.
131 -----------------------------------------------------------
132
133 PROCEDURE APPLY_TO_GROUP
134 ( p_api_version IN NUMBER,
135 p_commit IN VARCHAR2,
136 p_init_msg_list IN VARCHAR2,
137 p_validation_level IN NUMBER,
138 p_repair_group_id IN NUMBER,
139 p_promise_date IN DATE,
140 p_resource_id IN NUMBER,
141 p_approval_required_flag IN VARCHAR2,
142 x_object_version_number OUT NOCOPY NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2 );
146
147
148 END CSD_REPAIR_GROUPS_PVT;
149