[Home] [Help]
PACKAGE: APPS.CSD_RO_SERVICE_CODES_PVT
Source
1 PACKAGE CSD_RO_SERVICE_CODES_PVT as
2 /* $Header: csdvrscs.pls 120.1 2006/09/19 23:12:53 rfieldma noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: RO_SERVICE_CODE_REC_TYPE */
6 /* description : Record used for ro service code rec*/
7 /* */
8 /*--------------------------------------------------*/
9
10 TYPE RO_SERVICE_CODE_REC_TYPE IS RECORD
11 (
12 ro_service_code_id NUMBER,
13 object_version_number NUMBER,
14 repair_line_id NUMBER,
15 service_code_id NUMBER,
16 source_type_code VARCHAR2(30),
17 source_solution_id NUMBER,
18 applicable_flag VARCHAR2(1),
19 applied_to_est_flag VARCHAR2(1),
20 applied_to_work_flag VARCHAR2(1),
21 attribute_category VARCHAR2(30),
22 attribute1 VARCHAR2(150),
23 attribute2 VARCHAR2(150),
24 attribute3 VARCHAR2(150),
25 attribute4 VARCHAR2(150),
26 attribute5 VARCHAR2(150),
27 attribute6 VARCHAR2(150),
28 attribute7 VARCHAR2(150),
29 attribute8 VARCHAR2(150),
30 attribute9 VARCHAR2(150),
31 attribute10 VARCHAR2(150),
32 attribute11 VARCHAR2(150),
33 attribute12 VARCHAR2(150),
34 attribute13 VARCHAR2(150),
35 attribute14 VARCHAR2(150),
36 attribute15 VARCHAR2(150),
37 service_item_id NUMBER -- rfieldma, 4666403
38 );
39
40 /*--------------------------------------------------*/
41 /* procedure name: Create_RO_Service_Code */
42 /* description : procedure used to create */
43 /* ro service code */
44 /* */
45 /*--------------------------------------------------*/
46 PROCEDURE Create_RO_Service_Code
47 (
48 p_api_version IN NUMBER,
49 p_commit IN VARCHAR2,
50 p_init_msg_list IN VARCHAR2,
51 p_validation_level IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_ro_service_code_rec IN RO_SERVICE_CODE_REC_TYPE,
56 x_ro_service_code_id OUT NOCOPY NUMBER
57 );
58
59
60 /*--------------------------------------------------*/
61 /* procedure name: Update_RO_Service_Code */
62 /* description : procedure used to update */
63 /* ro service code */
64 /* */
65 /*--------------------------------------------------*/
66 PROCEDURE Update_RO_Service_Code
67 (
68 p_api_version IN NUMBER,
69 p_commit IN VARCHAR2,
70 p_init_msg_list IN VARCHAR2,
71 p_validation_level IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_ro_service_code_rec IN RO_SERVICE_CODE_REC_TYPE,
76 x_obj_ver_number OUT NOCOPY NUMBER
77 );
78
79 /*--------------------------------------------------*/
80 /* procedure name: Delete_RO_Service_Code */
81 /* description : procedure used to delete */
82 /* ro service code */
83 /* */
84 /*--------------------------------------------------*/
85 PROCEDURE Delete_RO_Service_Code
86 (
87 p_api_version IN NUMBER,
88 p_commit IN VARCHAR2,
89 p_init_msg_list IN VARCHAR2,
90 p_validation_level IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_ro_service_code_id IN NUMBER
95 );
96
97 /*--------------------------------------------------*/
98 /* procedure name: Lock_RO_Service_Code */
99 /* description : procedure used to lock */
100 /* ro service code */
101 /* */
102 /*--------------------------------------------------*/
103 PROCEDURE Lock_RO_Service_Code
104 (
105 p_api_version IN NUMBER,
106 p_commit IN VARCHAR2,
107 p_init_msg_list IN VARCHAR2,
108 p_validation_level IN NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_ro_service_code_rec IN RO_SERVICE_CODE_REC_TYPE
113 );
114
115 End CSD_RO_SERVICE_CODES_PVT;