1 PACKAGE pa_status_lists_pvt AS
2 /* $Header: PACISLVS.pls 120.1 2005/08/19 16:18:44 mwasowic noship $ */
3
4
5 -- --------------------------------------------------------------------------
6 -- FUNCTION
7 -- check_status_list_inuse
8 -- PURPOSE
9 -- This function checks whether the given status List is in use or not.
10 -- If in use it returns 'VIEW' otherwise it returns 'DELETE'.
11 --
12 -- HISTORY
13 -- 16-JAN-04 rasinha Created
14 --
15
16 FUNCTION check_status_list_inuse( P_STATUS_LIST_ID NUMBER)
17 RETURN VARCHAR2;
18
19 --
20 -- PROCEDURE
21 -- CreateStatusList
22 -- PURPOSE
23 -- This procedure inserts a row into the pa_status_lists table.
24 --
25 -- HISTORY
26 -- 16-JAN-04 rasinha Created
27 --
28
29 PROCEDURE CreateStatusList (
30 P_RECORD_VERSION_NUMBER IN NUMBER,
31 P_STATUS_LIST_ID IN NUMBER,
32 P_STATUS_TYPE IN VARCHAR2,
33 P_NAME IN VARCHAR2,
34 P_START_DATE_ACTIVE IN DATE,
35 P_END_DATE_ACTIVE IN DATE,
36 P_DESCRIPTION IN VARCHAR2,
37 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
38 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
39 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
40 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
41 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.user_id,
42 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45 );
46
47 --
48 -- PROCEDURE
49 -- UpdateStatusList
50 -- PURPOSE
51 -- This procedure updates a row in the pa_role_controls table.
52 --
53 -- HISTORY
54 -- 08-AUG-00 jwhite Created
55 --
56
57 PROCEDURE UpdateStatusList (
58 P_RECORD_VERSION_NUMBER IN NUMBER,
59 P_STATUS_LIST_ID IN NUMBER,
60 P_STATUS_TYPE IN VARCHAR2,
61 P_NAME IN VARCHAR2,
62 P_START_DATE_ACTIVE IN DATE,
63 P_END_DATE_ACTIVE IN DATE,
64 P_DESCRIPTION IN VARCHAR2,
65 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
66 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
67 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.user_id,
68 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71 );
72
73 --
74 -- PROCEDURE
75 -- DeleteStatusList
76 -- PURPOSE
77 -- This procedure deletes a row in the pa_status_lists table.
78 -- If a row is deleted, this API returns (S)uccess for the
79 -- x_return_status.
80 --
81 -- HISTORY
82 -- 16-JAN-04 rasinha Created
83 --
84
85 PROCEDURE DeleteStatusList (
86 P_STATUS_LIST_ID IN NUMBER,
87 P_RECORD_VERSION_NUMBER IN NUMBER,
88 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
90 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91 );
92
93
94 END pa_status_lists_pvt;