[Home] [Help]
PACKAGE: APPS.CSD_RT_TRANS_PVT
Source
1 PACKAGE CSD_RT_TRANS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvrtts.pls 120.0 2005/06/30 21:11:24 vkjain noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: RT_TRAN_REC_TYPE */
6 /* description : Record used for repair type */
7 /* transitions rec */
8 /* */
9 /*--------------------------------------------------*/
10
11 TYPE RT_TRAN_REC_TYPE IS RECORD
12 (
13 rt_tran_id NUMBER,
14 from_repair_type_id NUMBER,
15 to_repair_type_id NUMBER,
16 common_flow_status_id NUMBER,
17 reason_required_flag VARCHAR2(1),
18 capture_activity_flag VARCHAR2(1),
19 allow_all_resp_flag VARCHAR2(1),
20 description VARCHAR2(2000),
21 object_version_number NUMBER,
22 created_by NUMBER,
23 creation_date DATE,
24 last_updated_by NUMBER,
25 last_update_date DATE,
26 last_update_login NUMBER
27 );
28
29 /*--------------------------------------------------*/
30 /* procedure name: Create_Rt_Tran */
31 /* description : procedure used to create */
32 /* repair type transition */
33 /* */
34 /*--------------------------------------------------*/
35 PROCEDURE Create_Rt_Tran
36 (
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 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_rt_tran_rec IN RT_TRAN_REC_TYPE,
45 x_rt_tran_id OUT NOCOPY NUMBER
46 );
47
48
49 /*--------------------------------------------------*/
50 /* procedure name: Update_Rt_Tran */
51 /* description : procedure used to update */
52 /* repair type transition */
53 /* */
54 /*--------------------------------------------------*/
55 PROCEDURE Update_Rt_Tran
56 (
57 p_api_version IN NUMBER,
58 p_commit IN VARCHAR2,
59 p_init_msg_list IN VARCHAR2,
60 p_validation_level IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_rt_tran_rec IN RT_TRAN_REC_TYPE,
65 x_obj_ver_number OUT NOCOPY NUMBER
66 );
67
68 /*--------------------------------------------------*/
69 /* procedure name: Delete_Rt_Tran */
70 /* description : procedure used to delete */
71 /* repair type transition */
72 /* */
73 /*--------------------------------------------------*/
74 PROCEDURE Delete_Rt_Tran
75 (
76 p_api_version IN NUMBER,
77 p_commit IN VARCHAR2,
78 p_init_msg_list IN VARCHAR2,
79 p_validation_level IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_rt_tran_id IN NUMBER
84 );
85
86 /*--------------------------------------------------*/
87 /* procedure name: Lock_Rt_Tran */
88 /* description : procedure used to lock */
89 /* repair type transition */
90 /* */
91 /*--------------------------------------------------*/
92 PROCEDURE Lock_Rt_Tran
93 (
94 p_api_version IN NUMBER,
95 p_commit IN VARCHAR2,
96 p_init_msg_list IN VARCHAR2,
97 p_validation_level IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_rt_tran_rec IN RT_TRAN_REC_TYPE
102 );
103
104 End CSD_RT_TRANS_PVT;