34: -- create rows in AMS_CUSTOM_SETUP_ATTR
35: -- Parameters
36: -- IN:
37: -- p_api_version IN NUMBER
38: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
39: -- p_commit IN VARCHAR2 := FND_API.g_false
40: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
41: --
42: -- p_setup_attr_rec IN setup_attr_rec_type
35: -- Parameters
36: -- IN:
37: -- p_api_version IN NUMBER
38: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
39: -- p_commit IN VARCHAR2 := FND_API.g_false
40: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
41: --
42: -- p_setup_attr_rec IN setup_attr_rec_type
43: --
36: -- IN:
37: -- p_api_version IN NUMBER
38: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
39: -- p_commit IN VARCHAR2 := FND_API.g_false
40: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
41: --
42: -- p_setup_attr_rec IN setup_attr_rec_type
43: --
44: -- OUT:
50: ------------------------------------------------------------------------------
51: PROCEDURE create_setup_attr
52: (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
51: PROCEDURE create_setup_attr
52: (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
52: (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
71: -- update rows in AMS_CUSTOM_SETUP_ATTR
72: -- Parameters
73: -- IN:
74: -- p_api_version IN NUMBER
75: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
76: -- p_commit IN VARCHAR2 := FND_API.g_false
77: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
78: --
79: -- p_setup_attr_rec IN setup_attr_rec_type
72: -- Parameters
73: -- IN:
74: -- p_api_version IN NUMBER
75: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
76: -- p_commit IN VARCHAR2 := FND_API.g_false
77: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
78: --
79: -- p_setup_attr_rec IN setup_attr_rec_type
80: --
73: -- IN:
74: -- p_api_version IN NUMBER
75: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
76: -- p_commit IN VARCHAR2 := FND_API.g_false
77: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
78: --
79: -- p_setup_attr_rec IN setup_attr_rec_type
80: --
81: -- OUT:
85: ------------------------------------------------------------------------------
86: PROCEDURE update_setup_attr
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT NOCOPY VARCHAR2,
86: PROCEDURE update_setup_attr
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
105: -- validate the record
106: -- Parameters
107: -- IN:
108: -- p_api_version IN NUMBER
109: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
110: -- p_validation_mode IN VARCHAR2
111: --
112: -- p_setup_attr_rec IN setup_attr_rec_type
113: --
118: ------------------------------------------------------------------------------
119: PROCEDURE validate_setup_attr
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
124:
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
119: PROCEDURE validate_setup_attr
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
124:
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,