[Home] [Help]
PACKAGE: APPS.PA_STATUS_LISTS_PUB
Source
1 PACKAGE pa_status_lists_pub AUTHID CURRENT_USER AS
2 /* $Header: PACISLPS.pls 120.1 2005/08/19 16:18:35 mwasowic noship $ */
3
4 --
5 -- PROCEDURE
6 -- CreateStatusList
7 -- PURPOSE
8 -- This procedure inserts a row into the pa_status_lists table.
9 --
10 -- HISTORY
11 -- 16-JAN-04 rasinha Created
12 --
13
14 PROCEDURE CreateStatusList (
15 P_RECORD_VERSION_NUMBER IN NUMBER,
16 P_STATUS_LIST_ID IN NUMBER,
17 P_STATUS_TYPE IN VARCHAR2,
18 P_NAME IN VARCHAR2,
19 P_START_DATE_ACTIVE IN DATE,
20 P_END_DATE_ACTIVE IN DATE,
21 P_DESCRIPTION IN VARCHAR2,
22 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
23 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
24 P_CREATION_DATE IN DATE DEFAULT SYSDATE,
25 P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
26 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30 );
31
32 --
33 -- PROCEDURE
34 -- UpdateStatusList
35 -- PURPOSE
36 -- This procedure updates a row in the pa_status_lists table.
37 --
38 -- HISTORY
39 -- 16-JAN-04 rasinha Created
40 --
41
42 PROCEDURE UpdateStatusList (
43 P_RECORD_VERSION_NUMBER IN NUMBER,
44 P_STATUS_LIST_ID IN NUMBER,
45 P_STATUS_TYPE IN VARCHAR2,
46 P_NAME IN VARCHAR2,
47 P_START_DATE_ACTIVE IN DATE,
48 P_END_DATE_ACTIVE IN DATE,
49 P_DESCRIPTION IN VARCHAR2,
50 P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
51 P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
52 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
53 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56 );
57
58 --
59 -- PROCEDURE
60 -- DeleteStatusList
61 -- PURPOSE
62 -- This procedure deletes a row in the pa_status_lists table.
63 -- If a row is deleted, this API returns (S)uccess for the
64 -- x_return_status.
65 --
66 -- HISTORY
67 -- 16-JAN-04 rasinha Created
68 --
69
70 PROCEDURE DeleteStatusList (
71 P_STATUS_LIST_ID IN NUMBER,
72 P_RECORD_VERSION_NUMBER IN NUMBER,
73 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
75 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 );
77
78
79 END pa_status_lists_pub;