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