1 PACKAGE BODY CSD_GROUP_JOB_PVT AS
2 /* $Header: csdvjobb.pls 120.0 2005/05/24 17:16:34 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_GROUP_JOB_PVT';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvjobb.pls';
6 g_debug NUMBER := 0;
7 /*-----------------------------------------------------------------*/
8 /* procedure name: create_job_parameters */
9 /* description : procedure used to create */
10 /* RMA/sales orders for all groups */
11 /*-----------------------------------------------------------------*/
12
13 PROCEDURE create_job_parameters
14 ( p_api_version IN NUMBER,
15 p_commit IN VARCHAR2,
16 p_init_msg_list IN VARCHAR2,
17 p_validation_level IN NUMBER,
18 p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
19 x_group_job_id OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2
23 ) IS
24
25 BEGIN
26 null;
27 END create_job_parameters;
28
29
30 /*-----------------------------------------------------------------*/
31 /* procedure name: update_job_parameters */
32 /* description : procedure used to update */
33 /* RMA/sales orders for all groups */
34 /*-----------------------------------------------------------------*/
35
36 PROCEDURE update_job_parameters
37 ( p_api_version IN NUMBER,
38 p_commit IN VARCHAR2,
39 p_init_msg_list IN VARCHAR2,
40 p_validation_level IN NUMBER,
41 p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 ) IS
46
47 BEGIN
48 null;
49 END update_job_parameters;
50
51 /*-----------------------------------------------------------------*/
52 /* procedure name: lock_job_parameters */
53 /* description : procedure used to lock */
54 /* RMA/sales orders for all groups */
55 /*-----------------------------------------------------------------*/
56
57 PROCEDURE lock_job_parameters
58 ( p_api_version IN NUMBER,
59 p_commit IN VARCHAR2,
60 p_init_msg_list IN VARCHAR2,
61 p_validation_level IN NUMBER,
62 p_job_parameter_rec IN JOB_PARAMETER_REC,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 ) IS
67
68 BEGIN
69 null;
70 END lock_job_parameters;
71
72 -----------------------------------------------------
73 -- Procedure : UPDATE_RO_ORDERS
74 -- Purpose : To update repair orders with status
75 -- and qty in wip
76 --
77 ----------------------------------------------------
78 PROCEDURE UPDATE_RO_ORDERS(p_api_version in Number,
79 p_commit in Varchar2,
80 p_init_msg_list in Varchar2,
81 p_validation_level in number,
82 p_repair_line_id in number,
83 x_return_status OUT NOCOPY varchar2,
84 x_msg_count OUT NOCOPY number,
85 x_msg_data OUT NOCOPY varchar2) IS
86
87
88 BEGIN
89 null;
90 END UPDATE_RO_ORDERS;
91
92 -------------------------------------------------------
93 -- Procedure : UPDATE_RO_GROUP
94 -- Purpose : To update repair order groups with
95 -- status and quantity submitted to wip
96 --
97 ------------------------------------------------------
98 PROCEDURE UPDATE_RO_GROUP(p_api_version in number,
99 p_commit in varchar2,
100 p_init_msg_list in varchar2,
101 p_validation_level in number,
102 p_repair_group_id in number,
103 p_quantity_submitted in number,
104 p_wip_entity_id in number,
105 x_return_status OUT NOCOPY varchar2,
106 x_msg_count OUT NOCOPY number,
107 x_msg_data OUT NOCOPY varchar2) IS
108
109
110 BEGIN
111 null;
112 END UPDATE_RO_GROUP;
113 ----------------------------------------------
114 -- Procedure : CREATE_JOB_ALL_GROUPS
115 -- Purpose : To create Jobs for all Groups
116 --
117 ----------------------------------------------
118
119 PROCEDURE CREATE_JOB_ALL_GROUPS
120 ( p_api_version IN NUMBER,
121 p_commit IN VARCHAR2,
122 p_init_msg_list IN VARCHAR2,
123 p_validation_level IN NUMBER,
124 p_incident_id IN NUMBER,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2
128 ) IS
129
130
131 BEGIN
132 null;
133 END CREATE_JOB_ALL_GROUPS ;
134
135 ----------------------------------------------
136 -- Procedure : CREATE_JOB_ONE_GROUP
137 -- Purpose : To create Jobs for one Groups
138 ----------------------------------------------
139
140
141 PROCEDURE CREATE_JOB_ONE_GROUP
142 ( p_api_version IN NUMBER,
143 p_commit IN VARCHAR2,
144 p_init_msg_list IN VARCHAR2,
145 p_validation_level IN NUMBER,
146 p_repair_group_id IN NUMBER,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2
150 ) IS
151
152 BEGIN
153 null;
154 END CREATE_JOB_ONE_GROUP;
155
156 END CSD_GROUP_JOB_PVT ;