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