[Home] [Help]
PACKAGE: APPS.CSD_FLWSTS_TRANS_PVT
Source
1 PACKAGE CSD_FLWSTS_TRANS_PVT as
2 /* $Header: csdvflts.pls 120.0 2005/06/30 21:09:23 vkjain noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: FLWSTS_TRAN_REC_TYPE */
6 /* description : Record used for flow status */
7 /* transitions rec */
8 /* */
9 /*--------------------------------------------------*/
10
11 TYPE FLWSTS_TRAN_REC_TYPE IS RECORD
12 (
13 flwsts_tran_id NUMBER,
14 repair_type_id NUMBER,
15 from_flow_status_id NUMBER,
16 to_flow_status_id NUMBER,
17 wf_item_type VARCHAR2(30),
18 wf_process_name VARCHAR2(80),
19 reason_required_flag VARCHAR2(1),
20 capture_activity_flag VARCHAR2(1),
21 allow_all_resp_flag VARCHAR2(1),
22 description VARCHAR2(2000),
23 object_version_number NUMBER,
24 created_by NUMBER,
25 creation_date DATE,
26 last_updated_by NUMBER,
27 last_update_date DATE,
28 last_update_login NUMBER
29 );
30
31 /*--------------------------------------------------*/
32 /* procedure name: Create_Flwsts_Tran */
33 /* description : procedure used to create */
34 /* Flow Status transition */
35 /* */
36 /*--------------------------------------------------*/
37 PROCEDURE Create_Flwsts_Tran
38 (
39 p_api_version IN NUMBER,
40 p_commit IN VARCHAR2,
41 p_init_msg_list IN VARCHAR2,
42 p_validation_level IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_flwsts_tran_rec IN FLWSTS_TRAN_REC_TYPE,
47 x_flwsts_tran_id OUT NOCOPY NUMBER
48 );
49
50
51 /*--------------------------------------------------*/
52 /* procedure name: Update_Flwsts_Tran */
53 /* description : procedure used to update */
54 /* Flow Status transition */
55 /* */
56 /*--------------------------------------------------*/
57 PROCEDURE Update_Flwsts_Tran
58 (
59 p_api_version IN NUMBER,
60 p_commit IN VARCHAR2,
61 p_init_msg_list IN VARCHAR2,
62 p_validation_level IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_flwsts_tran_rec IN FLWSTS_TRAN_REC_TYPE,
67 x_obj_ver_number OUT NOCOPY NUMBER
68 );
69
70 /*--------------------------------------------------*/
71 /* procedure name: Delete_Flwsts_Tran */
72 /* description : procedure used to delete */
73 /* Flow Status transition */
74 /* */
75 /*--------------------------------------------------*/
76 PROCEDURE Delete_Flwsts_Tran
77 (
78 p_api_version IN NUMBER,
79 p_commit IN VARCHAR2,
80 p_init_msg_list IN VARCHAR2,
81 p_validation_level IN NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_flwsts_tran_id IN NUMBER
86 );
87
88 /*--------------------------------------------------*/
89 /* procedure name: Lock_Flwsts_Tran */
90 /* description : procedure used to lock */
91 /* Flow Status transition */
92 /* */
93 /*--------------------------------------------------*/
94 PROCEDURE Lock_Flwsts_Tran
95 (
96 p_api_version IN NUMBER,
97 p_commit IN VARCHAR2,
98 p_init_msg_list IN VARCHAR2,
99 p_validation_level IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_flwsts_tran_rec IN FLWSTS_TRAN_REC_TYPE
104 );
105
106 End CSD_FLWSTS_TRANS_PVT;