[Home] [Help]
PACKAGE: APPS.CSD_GROUP_JOB_PVT
Source
1 PACKAGE CSD_GROUP_JOB_PVT AUTHID CURRENT_USER AS
2 /* $Header: csdvjobs.pls 115.6 2002/11/08 20:30:29 sangigup noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: JOB_PARAMETER_REC */
6 /* description : Record used for product txn */
7 /* */
8 /*--------------------------------------------------*/
9
10 TYPE JOB_PARAMETER_REC IS RECORD
11 ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12 repair_group_id NUMBER := FND_API.G_MISS_NUM,
13 incident_id NUMBER := FND_API.G_MISS_NUM,
14 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15 organization_id NUMBER := FND_API.G_MISS_NUM,
16 job_type NUMBER := FND_API.G_MISS_NUM,
17 routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18 alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19 job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21 start_date DATE := FND_API.G_MISS_DATE,
22 completion_date DATE := FND_API.G_MISS_DATE,
23 quantity_received NUMBER := FND_API.G_MISS_NUM,
24 quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25 item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26 last_update_date DATE := FND_API.G_MISS_DATE,
27 creation_date DATE := FND_API.G_MISS_DATE,
28 last_updated_by NUMBER := FND_API.G_MISS_NUM,
29 created_by NUMBER := FND_API.G_MISS_NUM,
30 last_update_login NUMBER := FND_API.G_MISS_NUM,
31 object_version_number NUMBER := FND_API.G_MISS_NUM,
32 process_id NUMBER := FND_API.G_MISS_NUM);
33
34 /*-----------------------------------------------------------------*/
35 /* procedure name: create_job_parameters */
36 /* description : procedure used to create */
37 /* RMA/sales orders for all groups */
38 /*-----------------------------------------------------------------*/
39
40 PROCEDURE create_job_parameters
41 ( p_api_version IN NUMBER,
42 p_commit IN VARCHAR2 := fnd_api.g_false,
43 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45 p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
46 x_group_job_id OUT NOCOPY NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2);
50
51 /*-----------------------------------------------------------------*/
52 /* procedure name: update_job_parameters */
53 /* description : procedure used to create */
54 /* RMA/sales orders for all groups */
55 /*-----------------------------------------------------------------*/
56
57 PROCEDURE update_job_parameters
58 ( p_api_version IN NUMBER,
59 p_commit IN VARCHAR2 := fnd_api.g_false,
60 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62 p_job_parameter_rec IN OUT NOCOPY 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
67 /*-----------------------------------------------------------------*/
68 /* procedure name: lock_job_parameters */
69 /* description : procedure used to create */
70 /* RMA/sales orders for all groups */
71 /*-----------------------------------------------------------------*/
72
73 PROCEDURE lock_job_parameters
74 ( p_api_version IN NUMBER,
75 p_commit IN VARCHAR2 := fnd_api.g_false,
76 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
78 p_job_parameter_rec IN JOB_PARAMETER_REC,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2);
82
83 ------------------------------------------------
84 -- Procedure : UPDATE_RO_ORDERS
85 -- Purpose : To update Repair Orders with the
86 -- status and qty in wip
87 --
88 ------------------------------------------------
89 PROCEDURE UPDATE_RO_ORDERS(p_api_version in number,
90 p_commit in varchar2,
91 p_init_msg_list in varchar2,
92 p_validation_level in number,
93 p_repair_line_id in number,
94 x_return_status OUT NOCOPY varchar2,
95 x_msg_count OUT NOCOPY number,
96 x_msg_data OUT NOCOPY varchar2);
97
98 ---------------------------------------------------------
99 -- Procedure : UPDATE_RO_GROUP
100 -- Purpose : To update group repair orders
101 -- with the status and qty submitted to wip
102 --
103 ---------------------------------------------------------
104 PROCEDURE UPDATE_RO_GROUP(p_api_version in number,
105 p_commit in varchar2,
106 p_init_msg_list in varchar2,
107 p_validation_level in number,
108 p_repair_group_id in number,
109 p_quantity_submitted in number,
110 p_wip_entity_id in number,
111 x_return_status OUT NOCOPY varchar2,
112 x_msg_count OUT NOCOPY number,
113 x_msg_data OUT NOCOPY varchar2);
114
115 ----------------------------------------------
116 -- Procedure : CREATE_JOB_ALL_GROUPS
117 -- Purpose : To create Jobs for all Groups
118 --
119 ----------------------------------------------
120
121 PROCEDURE CREATE_JOB_ALL_GROUPS
122 ( p_api_version IN NUMBER,
123 p_commit IN VARCHAR2 := fnd_api.g_false,
124 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
126 p_incident_id IN NUMBER,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2 );
130
131 ----------------------------------------------
132 -- Procedure : CREATE_JOB_ONE_GROUPS
133 -- Purpose : To create Jobs for one Groups
134 --
135 ----------------------------------------------
136
137 PROCEDURE CREATE_JOB_ONE_GROUP
138 ( p_api_version IN NUMBER,
139 p_commit IN VARCHAR2 := fnd_api.g_false,
140 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
141 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
142 p_repair_group_id IN Number,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2 );
146
147 END CSD_GROUP_JOB_PVT ;
148