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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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;
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:
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
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,
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,
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);
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,
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,
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);