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