[Home] [Help]
PACKAGE: APPS.CSD_FLWSTS_TRAN_MILES_PVT
Source
1 PACKAGE CSD_FLWSTS_TRAN_MILES_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvflms.pls 120.0 2005/06/30 21:07:17 vkjain noship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: FLWSTS_TRAN_MILE_REC_TYPE */
6 /* description : Record used for flow status */
7 /* transition milestone rec */
8 /* */
9 /*--------------------------------------------------*/
10
11 TYPE FLWSTS_TRAN_MILE_REC_TYPE IS RECORD
12 (
13 flwsts_tran_mile_id NUMBER,
14 flwsts_tran_id NUMBER,
15 milestone_code VARCHAR2(30),
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_Flwsts_Tran_Mile */
26 /* description : procedure used to create */
27 /* FS transition milestone rec */
28 /* */
29 /*--------------------------------------------------*/
30 PROCEDURE Create_Flwsts_Tran_Mile
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_flwsts_tran_mile_rec IN FLWSTS_TRAN_MILE_REC_TYPE,
40 x_flwsts_tran_mile_id OUT NOCOPY NUMBER
41 );
42
43
44 /*--------------------------------------------------*/
45 /* procedure name: Update_Flwsts_Tran_Mile */
46 /* description : procedure used to update */
47 /* FS transition milestone rec */
48 /* */
49 /*--------------------------------------------------*/
50 PROCEDURE Update_Flwsts_Tran_Mile
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_flwsts_tran_mile_rec IN FLWSTS_TRAN_MILE_REC_TYPE,
60 x_obj_ver_number OUT NOCOPY NUMBER
61 );
62
63 /*--------------------------------------------------*/
64 /* procedure name: Delete_Flwsts_Tran_Mile */
65 /* description : procedure used to delete */
66 /* FS transition milestone rec */
67 /* */
68 /*--------------------------------------------------*/
69 PROCEDURE Delete_Flwsts_Tran_Mile
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_flwsts_tran_mile_id IN NUMBER
79 );
80
81 /*--------------------------------------------------*/
82 /* procedure name: Lock_Flwsts_Tran_Mile */
83 /* description : procedure used to lock */
84 /* FS transition milestone rec */
85 /* */
86 /*--------------------------------------------------*/
87 PROCEDURE Lock_Flwsts_Tran_Mile
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_flwsts_tran_mile_rec IN FLWSTS_TRAN_MILE_REC_TYPE
97 );
98
99 End CSD_FLWSTS_TRAN_MILES_PVT;