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_style_fmt_variation_rec Style record.
34: * IN/OUT:
35: * OUT:
36: * p_style_fmt_variation_id style_fmt_variation id
34: * IN/OUT:
35: * OUT:
36: * p_style_fmt_variation_id style_fmt_variation id
37: * x_return_status Return status after the call. The status can
38: * be FND_API.G_RET_STS_SUCCESS (success),
39: * FND_API.G_RET_STS_ERROR (error),
40: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
41: * x_msg_count Number of messages in message stack.
42: * x_msg_data Message text if x_msg_count is 1.
35: * OUT:
36: * p_style_fmt_variation_id style_fmt_variation id
37: * x_return_status Return status after the call. The status can
38: * be FND_API.G_RET_STS_SUCCESS (success),
39: * FND_API.G_RET_STS_ERROR (error),
40: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
41: * x_msg_count Number of messages in message stack.
42: * x_msg_data Message text if x_msg_count is 1.
43: *
36: * p_style_fmt_variation_id style_fmt_variation id
37: * x_return_status Return status after the call. The status can
38: * be FND_API.G_RET_STS_SUCCESS (success),
39: * FND_API.G_RET_STS_ERROR (error),
40: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
41: * x_msg_count Number of messages in message stack.
42: * x_msg_data Message text if x_msg_count is 1.
43: *
44: * NOTES
49: *
50: */
51:
52: PROCEDURE create_style_fmt_variation (
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_style_fmt_variation_rec IN STYLE_FMT_VARIATION_REC_TYPE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2
67: *
68: * ARGUMENTS
69: * IN:
70: * p_init_msg_list Initialize message stack if it is set to
71: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
72: * p_style_fmt_variation_rec Style record.
73: * IN/OUT:
74: * p_object_version_number Used for locking the being updated record.
75: * OUT:
73: * IN/OUT:
74: * p_object_version_number Used for locking the being updated record.
75: * OUT:
76: * x_return_status Return status after the call. The status can
77: * be FND_API.G_RET_STS_SUCCESS (success),
78: * FND_API.G_RET_STS_ERROR (error),
79: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
80: * x_msg_count Number of messages in message stack.
81: * x_msg_data Message text if x_msg_count is 1.
74: * p_object_version_number Used for locking the being updated record.
75: * OUT:
76: * x_return_status Return status after the call. The status can
77: * be FND_API.G_RET_STS_SUCCESS (success),
78: * FND_API.G_RET_STS_ERROR (error),
79: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
80: * x_msg_count Number of messages in message stack.
81: * x_msg_data Message text if x_msg_count is 1.
82: *
75: * OUT:
76: * x_return_status Return status after the call. The status can
77: * be FND_API.G_RET_STS_SUCCESS (success),
78: * FND_API.G_RET_STS_ERROR (error),
79: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
80: * x_msg_count Number of messages in message stack.
81: * x_msg_data Message text if x_msg_count is 1.
82: *
83: * NOTES
88: *
89: */
90:
91: PROCEDURE update_style_fmt_variation (
92: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
93: p_style_fmt_variation_rec IN STYLE_FMT_VARIATION_REC_TYPE,
94: p_object_version_number IN OUT NOCOPY NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
107: *
108: * ARGUMENTS
109: * IN:
110: * p_init_msg_list Initialize message stack if it is set to
111: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
112: * p_style_fmt_variation_code Style Code.
113: * IN/OUT:
114: * OUT:
115: * x_style_fmt_variation_rec Style record.
113: * IN/OUT:
114: * OUT:
115: * x_style_fmt_variation_rec Style record.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.
114: * OUT:
115: * x_style_fmt_variation_rec Style record.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.
122: *
115: * x_style_fmt_variation_rec Style record.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.
122: *
123: * NOTES
128: *
129: */
130:
131: PROCEDURE get_style_fmt_variation_rec (
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_style_format_code IN VARCHAR2,
134: p_variation_number IN NUMBER,
135: x_style_fmt_variation_rec OUT NOCOPY STYLE_FMT_VARIATION_REC_TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,