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