[Home] [Help]
PACKAGE: APPS.AS_STATUS_PUB
Source
1 PACKAGE as_status_pub AUTHID CURRENT_USER AS
2 /* $Header: asxpstas.pls 115.3 2003/01/28 23:13:28 geliu ship $ */
3
4
5 -- Start of Comments
6 --
7 -- Record Type Name : STATUS_Rec_Type
8 -- Type : Global
9 -- Notes :
10 -- The record type has default values as g_miss values and is used as
11 -- an input parameter for both the procedures create and update status code
12 --
13 -- End of Comments
14
15 TYPE STATUS_Rec_Type IS RECORD
16 (
17 STATUS_CODE VARCHAR2(30),
18 LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
19 LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
20 CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
21 CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
22 LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
23 ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
24 LEAD_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
25 OPP_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
26 OPP_OPEN_STATUS_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
27 OPP_DECISION_DATE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
28 STATUS_RANK NUMBER DEFAULT FND_API.G_MISS_NUM,
29 FORECAST_ROLLUP_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
30 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31 ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32 ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33 ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34 ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35 ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36 ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37 ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38 ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39 ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40 ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41 ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42 ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43 ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44 ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45 ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46 MEANING VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
47 DESCRIPTION VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
48 WIN_LOSS_INDICATOR VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
49
50 G_MISS_STATUS_REC AS_STATUS_PUB.STATUS_Rec_Type;
51
52 -- Start of Comments
53 --
54 -- API Name : create_status
55 -- Type : Public
56 -- Parameters : Standard API Parameters and the p_status_rec
57 -- record type parameter are the parameters for this procedure.
58 --
59 -- End of Comments
60
61 PROCEDURE create_status (
62 p_api_version_number IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
64 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
65 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
66 p_status_rec IN STATUS_Rec_Type DEFAULT G_MISS_STATUS_REC,
67 x_return_status OUT VARCHAR2,
68 x_msg_count OUT NUMBER,
69 x_msg_data OUT VARCHAR2);
70
71 -- Start of Comments
72 --
73 -- API Name : update_status
74 -- Type : Public
75 -- Parameters : Standard API Parameters and the p_status_rec
76 -- record type parameter are the parameters for this procedure.
77 --
78 -- End of Comments
79
80 PROCEDURE update_status (
81 p_api_version_number IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
83 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
84 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
85 p_status_rec IN STATUS_Rec_Type DEFAULT G_MISS_STATUS_REC,
86 x_return_status OUT VARCHAR2,
87 x_msg_count OUT NUMBER,
88 x_msg_data OUT VARCHAR2);
89
90 END as_status_pub;