26: *
27: * ARGUMENTS
28: * IN:
29: * p_init_msg_list Initialize message stack if it is set to
30: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
31: * p_style_rec Style record.
32: * IN/OUT:
33: * OUT:
34: * x_return_status Return status after the call. The status can
31: * p_style_rec Style record.
32: * IN/OUT:
33: * OUT:
34: * x_return_status Return status after the call. The status can
35: * be FND_API.G_RET_STS_SUCCESS (success),
36: * FND_API.G_RET_STS_ERROR (error),
37: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
38: * x_msg_count Number of messages in message stack.
39: * x_msg_data Message text if x_msg_count is 1.
32: * IN/OUT:
33: * OUT:
34: * x_return_status Return status after the call. The status can
35: * be FND_API.G_RET_STS_SUCCESS (success),
36: * FND_API.G_RET_STS_ERROR (error),
37: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
38: * x_msg_count Number of messages in message stack.
39: * x_msg_data Message text if x_msg_count is 1.
40: *
33: * OUT:
34: * x_return_status Return status after the call. The status can
35: * be FND_API.G_RET_STS_SUCCESS (success),
36: * FND_API.G_RET_STS_ERROR (error),
37: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
38: * x_msg_count Number of messages in message stack.
39: * x_msg_data Message text if x_msg_count is 1.
40: *
41: * NOTES
46: *
47: */
48:
49: PROCEDURE create_style (
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_style_rec IN STYLE_REC_TYPE,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2
64: *
65: * ARGUMENTS
66: * IN:
67: * p_init_msg_list Initialize message stack if it is set to
68: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
69: * p_style_rec Style record.
70: * IN/OUT:
71: * p_object_version_number Used for locking the being updated record.
72: * OUT:
70: * IN/OUT:
71: * p_object_version_number Used for locking the being updated record.
72: * OUT:
73: * x_return_status Return status after the call. The status can
74: * be FND_API.G_RET_STS_SUCCESS (success),
75: * FND_API.G_RET_STS_ERROR (error),
76: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
77: * x_msg_count Number of messages in message stack.
78: * x_msg_data Message text if x_msg_count is 1.
71: * p_object_version_number Used for locking the being updated record.
72: * OUT:
73: * x_return_status Return status after the call. The status can
74: * be FND_API.G_RET_STS_SUCCESS (success),
75: * FND_API.G_RET_STS_ERROR (error),
76: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
77: * x_msg_count Number of messages in message stack.
78: * x_msg_data Message text if x_msg_count is 1.
79: *
72: * OUT:
73: * x_return_status Return status after the call. The status can
74: * be FND_API.G_RET_STS_SUCCESS (success),
75: * FND_API.G_RET_STS_ERROR (error),
76: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
77: * x_msg_count Number of messages in message stack.
78: * x_msg_data Message text if x_msg_count is 1.
79: *
80: * NOTES
85: *
86: */
87:
88: PROCEDURE update_style (
89: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
90: p_style_rec IN STYLE_REC_TYPE,
91: p_object_version_number IN OUT NOCOPY NUMBER,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
104: *
105: * ARGUMENTS
106: * IN:
107: * p_init_msg_list Initialize message stack if it is set to
108: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
109: * p_style_code Style Code.
110: * IN/OUT:
111: * OUT:
112: * x_style_rec Style record.
110: * IN/OUT:
111: * OUT:
112: * x_style_rec Style record.
113: * x_return_status Return status after the call. The status can
114: * be FND_API.G_RET_STS_SUCCESS (success),
115: * FND_API.G_RET_STS_ERROR (error),
116: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: * x_msg_count Number of messages in message stack.
118: * x_msg_data Message text if x_msg_count is 1.
111: * OUT:
112: * x_style_rec Style record.
113: * x_return_status Return status after the call. The status can
114: * be FND_API.G_RET_STS_SUCCESS (success),
115: * FND_API.G_RET_STS_ERROR (error),
116: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: * x_msg_count Number of messages in message stack.
118: * x_msg_data Message text if x_msg_count is 1.
119: *
112: * x_style_rec Style record.
113: * x_return_status Return status after the call. The status can
114: * be FND_API.G_RET_STS_SUCCESS (success),
115: * FND_API.G_RET_STS_ERROR (error),
116: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: * x_msg_count Number of messages in message stack.
118: * x_msg_data Message text if x_msg_count is 1.
119: *
120: * NOTES
125: *
126: */
127:
128: PROCEDURE get_style_rec (
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_style_code IN VARCHAR2,
131: x_style_rec OUT NOCOPY STYLE_REC_TYPE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,