[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_MILESTONES_PVT
Source
1 PACKAGE CSD_REPAIR_MILESTONES_PVT as
2 /* $Header: csdvroms.pls 120.0 2005/07/14 18:57:46 vkjain noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: REPAIR_MILESTONE_REC_TYPE */
6 /* description : Record used for repair */
7 /* milestone rec */
8 /* */
9 /*--------------------------------------------------*/
10
11 TYPE REPAIR_MILESTONE_REC_TYPE IS RECORD
12 (
13 repair_milestone_id NUMBER,
14 repair_line_id NUMBER,
15 milestone_code VARCHAR2(30),
16 milestone_date DATE,
17 object_version_number NUMBER,
18 created_by NUMBER,
19 creation_date DATE,
20 last_updated_by NUMBER,
21 last_update_date DATE,
22 last_update_login NUMBER
23 );
24
25 /*--------------------------------------------------*/
26 /* procedure name: Create_Repair_Milestone */
27 /* description : procedure used to create */
28 /* repair milestone */
29 /* */
30 /*--------------------------------------------------*/
31 PROCEDURE Create_Repair_Milestone
32 (
33 p_api_version IN NUMBER,
34 p_commit IN VARCHAR2,
35 p_init_msg_list IN VARCHAR2,
36 p_validation_level IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_repair_milestone_rec IN REPAIR_MILESTONE_REC_TYPE,
41 x_repair_milestone_id OUT NOCOPY NUMBER
42 );
43
44
45 /*--------------------------------------------------*/
46 /* procedure name: Update_Repair_Milestone */
47 /* description : procedure used to update */
48 /* repair milestone */
49 /* */
50 /*--------------------------------------------------*/
51 PROCEDURE Update_Repair_Milestone
52 (
53 p_api_version IN NUMBER,
54 p_commit IN VARCHAR2,
55 p_init_msg_list IN VARCHAR2,
56 p_validation_level IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_repair_milestone_rec IN REPAIR_MILESTONE_REC_TYPE,
61 x_obj_ver_number OUT NOCOPY NUMBER
62 );
63
64 /*--------------------------------------------------*/
65 /* procedure name: Delete_Repair_Milestone */
66 /* description : procedure used to delete */
67 /* repair milestone */
68 /* */
69 /*--------------------------------------------------*/
70 PROCEDURE Delete_Repair_Milestone
71 (
72 p_api_version IN NUMBER,
73 p_commit IN VARCHAR2,
74 p_init_msg_list IN VARCHAR2,
75 p_validation_level IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_repair_milestone_id IN NUMBER
80 );
81
82 /*--------------------------------------------------*/
83 /* procedure name: Lock_Repair_Milestone */
84 /* description : procedure used to lock */
85 /* repair milestone */
86 /* */
87 /*--------------------------------------------------*/
88 PROCEDURE Lock_Repair_Milestone
89 (
90 p_api_version IN NUMBER,
91 p_commit IN VARCHAR2,
92 p_init_msg_list IN VARCHAR2,
93 p_validation_level IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_repair_milestone_rec IN REPAIR_MILESTONE_REC_TYPE
98 );
99
100 End CSD_REPAIR_MILESTONES_PVT;