28: *
29: * ARGUMENTS
30: * IN:
31: * p_init_msg_list Initialize message stack if it is set to
32: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
33: * p_entity_attribute_rec Entity Attribute record.
34: * p_data_source_tbl PL/SQL Table for Data Source Setup.
35: * IN/OUT:
36: * OUT:
35: * IN/OUT:
36: * OUT:
37: * x_entity_attr_id Dictionary ID.
38: * x_return_status Return status after the call. The status can
39: * be FND_API.G_RET_STS_SUCCESS (success),
40: * FND_API.G_RET_STS_ERROR (error),
41: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
42: * x_msg_count Number of messages in message stack.
43: * x_msg_data Message text if x_msg_count is 1.
36: * OUT:
37: * x_entity_attr_id Dictionary ID.
38: * x_return_status Return status after the call. The status can
39: * be FND_API.G_RET_STS_SUCCESS (success),
40: * FND_API.G_RET_STS_ERROR (error),
41: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
42: * x_msg_count Number of messages in message stack.
43: * x_msg_data Message text if x_msg_count is 1.
44: *
37: * x_entity_attr_id Dictionary ID.
38: * x_return_status Return status after the call. The status can
39: * be FND_API.G_RET_STS_SUCCESS (success),
40: * FND_API.G_RET_STS_ERROR (error),
41: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
42: * x_msg_count Number of messages in message stack.
43: * x_msg_data Message text if x_msg_count is 1.
44: *
45: * NOTES
49: * 02-12-2002 Jianying Huang o Created.
50: */
51:
52: PROCEDURE Add_EntityAttribute (
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_entity_attribute_rec IN ENTITY_ATTRIBUTE_REC_TYPE,
55: p_data_source_tab IN DATA_SOURCE_TBL,
56: x_entity_attr_id OUT NOCOPY NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,
69: *
70: * ARGUMENTS
71: * IN:
72: * p_init_msg_list Initialize message stack if it is set to
73: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
74: * p_entity_name Entity Name
75: * p_attribute_name Attribute Name
76: * IN/OUT:
77: * OUT:
76: * IN/OUT:
77: * OUT:
78: * x_data_source_tbl PL/SQL Table for Data Source Setup.
79: * x_return_status Return status after the call. The status can
80: * be FND_API.G_RET_STS_SUCCESS (success),
81: * FND_API.G_RET_STS_ERROR (error),
82: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
83: * x_msg_count Number of messages in message stack.
84: * x_msg_data Message text if x_msg_count is 1.
77: * OUT:
78: * x_data_source_tbl PL/SQL Table for Data Source Setup.
79: * x_return_status Return status after the call. The status can
80: * be FND_API.G_RET_STS_SUCCESS (success),
81: * FND_API.G_RET_STS_ERROR (error),
82: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
83: * x_msg_count Number of messages in message stack.
84: * x_msg_data Message text if x_msg_count is 1.
85: *
78: * x_data_source_tbl PL/SQL Table for Data Source Setup.
79: * x_return_status Return status after the call. The status can
80: * be FND_API.G_RET_STS_SUCCESS (success),
81: * FND_API.G_RET_STS_ERROR (error),
82: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
83: * x_msg_count Number of messages in message stack.
84: * x_msg_data Message text if x_msg_count is 1.
85: *
86: * NOTES
90: * 02-12-2002 Jianying Huang o Created.
91: */
92:
93: PROCEDURE Get_EntityAttribute (
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_entity_name IN VARCHAR2,
96: p_attribute_name IN VARCHAR2,
97: x_data_source_tbl OUT NOCOPY DATA_SOURCE_TBL,
98: x_return_status OUT NOCOPY VARCHAR2,
110: *
111: * ARGUMENTS
112: * IN:
113: * p_init_msg_list Initialize message stack if it is set to
114: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
115: * p_entity_name Entity Name
116: * p_attribute_name Attribute Name
117: * IN/OUT:
118: * OUT:
116: * p_attribute_name Attribute Name
117: * IN/OUT:
118: * OUT:
119: * x_return_status Return status after the call. The status can
120: * be FND_API.G_RET_STS_SUCCESS (success),
121: * FND_API.G_RET_STS_ERROR (error),
122: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
123: * x_msg_count Number of messages in message stack.
124: * x_msg_data Message text if x_msg_count is 1.
117: * IN/OUT:
118: * OUT:
119: * x_return_status Return status after the call. The status can
120: * be FND_API.G_RET_STS_SUCCESS (success),
121: * FND_API.G_RET_STS_ERROR (error),
122: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
123: * x_msg_count Number of messages in message stack.
124: * x_msg_data Message text if x_msg_count is 1.
125: *
118: * OUT:
119: * x_return_status Return status after the call. The status can
120: * be FND_API.G_RET_STS_SUCCESS (success),
121: * FND_API.G_RET_STS_ERROR (error),
122: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
123: * x_msg_count Number of messages in message stack.
124: * x_msg_data Message text if x_msg_count is 1.
125: *
126: * NOTES
130: * 02-12-2002 Jianying Huang o Created.
131: */
132:
133: PROCEDURE Remove_EntityAttribute (
134: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135: p_entity_name IN VARCHAR2,
136: p_attribute_name IN VARCHAR2,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
150: *
151: * ARGUMENTS
152: * IN:
153: * p_init_msg_list Initialize message stack if it is set to
154: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
155: * p_entity_name Entity Name
156: * p_attribute_name Attribute Name
157: * IN/OUT:
158: * OUT:
156: * p_attribute_name Attribute Name
157: * IN/OUT:
158: * OUT:
159: * x_return_status Return status after the call. The status can
160: * be FND_API.G_RET_STS_SUCCESS (success),
161: * FND_API.G_RET_STS_ERROR (error),
162: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
163: * x_msg_count Number of messages in message stack.
164: * x_msg_data Message text if x_msg_count is 1.
157: * IN/OUT:
158: * OUT:
159: * x_return_status Return status after the call. The status can
160: * be FND_API.G_RET_STS_SUCCESS (success),
161: * FND_API.G_RET_STS_ERROR (error),
162: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
163: * x_msg_count Number of messages in message stack.
164: * x_msg_data Message text if x_msg_count is 1.
165: *
158: * OUT:
159: * x_return_status Return status after the call. The status can
160: * be FND_API.G_RET_STS_SUCCESS (success),
161: * FND_API.G_RET_STS_ERROR (error),
162: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
163: * x_msg_count Number of messages in message stack.
164: * x_msg_data Message text if x_msg_count is 1.
165: *
166: * NOTES
170: * 02-12-2002 Jianying Huang o Created.
171: */
172:
173: PROCEDURE Remove_EntityAttrDataSource (
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_entity_name IN VARCHAR2,
176: p_attribute_name IN VARCHAR2,
177: p_data_source_tbl IN DATA_SOURCE_TBL,
178: x_return_status OUT NOCOPY VARCHAR2,