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_locale_rec Style record.
34: * IN/OUT:
35: * OUT:
36: * p_style_fmt_locale_id style_fmt_locale id
34: * IN/OUT:
35: * OUT:
36: * p_style_fmt_locale_id style_fmt_locale 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_locale_id style_fmt_locale 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_locale_id style_fmt_locale 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_locale (
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
55: p_style_fmt_locale_id OUT NOCOPY NUMBER,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
68: *
69: * ARGUMENTS
70: * IN:
71: * p_init_msg_list Initialize message stack if it is set to
72: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
73: * p_style_fmt_locale_rec Style format locale record.
74: * IN/OUT:
75: * p_object_version_number Used for locking the being updated record.
76: * OUT:
74: * IN/OUT:
75: * p_object_version_number Used for locking the being updated record.
76: * OUT:
77: * x_return_status Return status after the call. The status can
78: * be FND_API.G_RET_STS_SUCCESS (success),
79: * FND_API.G_RET_STS_ERROR (error),
80: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
81: * x_msg_count Number of messages in message stack.
82: * x_msg_data Message text if x_msg_count is 1.
75: * p_object_version_number Used for locking the being updated record.
76: * OUT:
77: * x_return_status Return status after the call. The status can
78: * be FND_API.G_RET_STS_SUCCESS (success),
79: * FND_API.G_RET_STS_ERROR (error),
80: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
81: * x_msg_count Number of messages in message stack.
82: * x_msg_data Message text if x_msg_count is 1.
83: *
76: * OUT:
77: * x_return_status Return status after the call. The status can
78: * be FND_API.G_RET_STS_SUCCESS (success),
79: * FND_API.G_RET_STS_ERROR (error),
80: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
81: * x_msg_count Number of messages in message stack.
82: * x_msg_data Message text if x_msg_count is 1.
83: *
84: * NOTES
89: *
90: */
91:
92: PROCEDURE update_style_fmt_locale (
93: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
94: p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
95: p_object_version_number IN OUT NOCOPY NUMBER,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
108: *
109: * ARGUMENTS
110: * IN:
111: * p_init_msg_list Initialize message stack if it is set to
112: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
113: * p_style_fmt_locale_code Style Code.
114: * IN/OUT:
115: * OUT:
116: * x_style_fmt_locale_rec Style format local record.
114: * IN/OUT:
115: * OUT:
116: * x_style_fmt_locale_rec Style format local record.
117: * x_return_status Return status after the call. The status can
118: * be FND_API.G_RET_STS_SUCCESS (success),
119: * FND_API.G_RET_STS_ERROR (error),
120: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
121: * x_msg_count Number of messages in message stack.
122: * x_msg_data Message text if x_msg_count is 1.
115: * OUT:
116: * x_style_fmt_locale_rec Style format local record.
117: * x_return_status Return status after the call. The status can
118: * be FND_API.G_RET_STS_SUCCESS (success),
119: * FND_API.G_RET_STS_ERROR (error),
120: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
121: * x_msg_count Number of messages in message stack.
122: * x_msg_data Message text if x_msg_count is 1.
123: *
116: * x_style_fmt_locale_rec Style format local record.
117: * x_return_status Return status after the call. The status can
118: * be FND_API.G_RET_STS_SUCCESS (success),
119: * FND_API.G_RET_STS_ERROR (error),
120: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
121: * x_msg_count Number of messages in message stack.
122: * x_msg_data Message text if x_msg_count is 1.
123: *
124: * NOTES
129: *
130: */
131:
132: PROCEDURE get_style_fmt_locale_rec (
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_style_fmt_locale_id IN NUMBER,
135: x_style_fmt_locale_rec OUT NOCOPY STYLE_FMT_LOCALE_REC_TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,