1 PACKAGE PA_LIFECYCLE_USAGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: PALCUPKS.pls 115.0 2002/10/21 09:30:52 amksingh noship $ */
3
4 -- Start of comments
5 -- API name : INSERT_ROW
6 -- Type : Table Handler
7 -- Pre-reqs : None.
8 -- Purpose : Insert data in pa_lifecycle_usages table
9 -- Parameters :
10 -- X_LIFECYCLE_USAGE_ID IN NUMBER Required
11 -- X_RECORD_VERSION_NUMBER IN NUMBER Optional Default 1.0
12 -- X_LIFECYCLE_ID IN NUMBER Required
13 -- X_USAGE_TYPE IN NUMBER Required
14 --
15 -- History :
16 -- 15-OCT-02 amksingh Created
17 -- End of comments
18
19 PROCEDURE INSERT_ROW (
20 X_LIFECYCLE_USAGE_ID in NUMBER,
21 X_RECORD_VERSION_NUMBER in NUMBER := 1,
22 X_LIFECYCLE_ID in NUMBER,
23 X_USAGE_TYPE in VARCHAR2
24 );
25
26 -- Start of comments
27 -- API name : LOCK_ROW
28 -- Type : Table Handler
29 -- Pre-reqs : None.
30 -- Purpose : Locks row before updation and deletion in pa_lifecycle_usages table
31 -- Parameters :
32 -- X_LIFECYCLE_USAGE_ID IN NUMBER Required
33 -- X_RECORD_VERSION_NUMBER IN NUMBER Required
34 -- X_LIFECYCLE_ID IN NUMBER Required
35 -- X_USAGE_TYPE IN NUMBER Required
36 --
37 -- History :
38 -- 15-OCT-02 amksingh Created
39 -- End of comments
40
41 PROCEDURE LOCK_ROW (
42 X_LIFECYCLE_USAGE_ID in NUMBER,
43 X_RECORD_VERSION_NUMBER in NUMBER,
44 X_LIFECYCLE_ID in NUMBER,
45 X_USAGE_TYPE in VARCHAR2
46 );
47
48 -- Start of comments
49 -- API name : UPDATE_ROW
50 -- Type : Table Handler
51 -- Pre-reqs : None.
52 -- Purpose : Updates row in pa_lifecycle_usages table
53 -- Parameters :
54 -- X_LIFECYCLE_USAGE_ID IN NUMBER Required
55 -- X_RECORD_VERSION_NUMBER IN NUMBER Required
56 -- X_LIFECYCLE_ID IN NUMBER Required
57 -- X_USAGE_TYPE IN NUMBER Required
58 --
59 -- History :
60 -- 15-OCT-02 amksingh Created
61 -- End of comments
62
63 PROCEDURE UPDATE_ROW (
64 X_LIFECYCLE_USAGE_ID in NUMBER,
65 X_RECORD_VERSION_NUMBER in NUMBER,
66 X_LIFECYCLE_ID in NUMBER,
67 X_USAGE_TYPE in VARCHAR2
68 );
69
70 -- Start of comments
71 -- API name : UPDATE_ROW
72 -- Type : Table Handler
73 -- Pre-reqs : None.
74 -- Purpose : Deletes row in pa_lifecycle_usages table
75 -- Parameters :
76 -- X_LIFECYCLE_USAGE_ID IN NUMBER Required
77 --
78 -- History :
79 -- 15-OCT-02 amksingh Created
80 -- End of comments
81
82 PROCEDURE DELETE_ROW (
83 X_LIFECYCLE_USAGE_ID in NUMBER
84 );
85
86 END PA_LIFECYCLE_USAGES_PKG;