30: -- create rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
31: -- Parameters
32: -- IN:
33: -- p_api_version IN NUMBER
34: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
35: -- p_commit IN VARCHAR2 := FND_API.g_false
36: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
37: --
38: -- p_cust_setup_rec IN cust_setup_rec_type
31: -- Parameters
32: -- IN:
33: -- p_api_version IN NUMBER
34: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
35: -- p_commit IN VARCHAR2 := FND_API.g_false
36: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
37: --
38: -- p_cust_setup_rec IN cust_setup_rec_type
39: --
32: -- IN:
33: -- p_api_version IN NUMBER
34: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
35: -- p_commit IN VARCHAR2 := FND_API.g_false
36: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
37: --
38: -- p_cust_setup_rec IN cust_setup_rec_type
39: --
40: -- OUT:
46: ------------------------------------------------------------------------------
47: PROCEDURE create_cust_setup
48: (
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51: p_commit IN VARCHAR2 := FND_API.g_false,
52: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
53:
54: x_return_status OUT NOCOPY VARCHAR2,
47: PROCEDURE create_cust_setup
48: (
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51: p_commit IN VARCHAR2 := FND_API.g_false,
52: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
53:
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
48: (
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51: p_commit IN VARCHAR2 := FND_API.g_false,
52: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
53:
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
66: -- update rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
67: -- Parameters
68: -- IN:
69: -- p_api_version IN NUMBER
70: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
71: -- p_commit IN VARCHAR2 := FND_API.g_false
72: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
73: --
74: -- p_cust_setup_rec IN cust_setup_rec_type
67: -- Parameters
68: -- IN:
69: -- p_api_version IN NUMBER
70: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
71: -- p_commit IN VARCHAR2 := FND_API.g_false
72: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
73: --
74: -- p_cust_setup_rec IN cust_setup_rec_type
75: --
68: -- IN:
69: -- p_api_version IN NUMBER
70: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
71: -- p_commit IN VARCHAR2 := FND_API.g_false
72: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
73: --
74: -- p_cust_setup_rec IN cust_setup_rec_type
75: --
76: -- OUT:
80: ------------------------------------------------------------------------------
81: PROCEDURE update_cust_setup
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
85: p_commit IN VARCHAR2 := FND_API.g_false,
86: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
87:
88: x_return_status OUT NOCOPY VARCHAR2,
81: PROCEDURE update_cust_setup
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
85: p_commit IN VARCHAR2 := FND_API.g_false,
86: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
87:
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
85: p_commit IN VARCHAR2 := FND_API.g_false,
86: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
87:
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
99: -- delete rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
100: -- Parameters
101: -- IN:
102: -- p_api_version IN NUMBER
103: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
104: -- p_commit IN VARCHAR2 := FND_API.g_false
105: --
106: -- p_custom_setup_id IN NUMBER
107: -- p_object_version IN NUMBER
100: -- Parameters
101: -- IN:
102: -- p_api_version IN NUMBER
103: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
104: -- p_commit IN VARCHAR2 := FND_API.g_false
105: --
106: -- p_custom_setup_id IN NUMBER
107: -- p_object_version IN NUMBER
108: --
113: ------------------------------------------------------------------------------
114: PROCEDURE delete_cust_setup
115: (
116: p_api_version IN NUMBER,
117: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
114: PROCEDURE delete_cust_setup
115: (
116: p_api_version IN NUMBER,
117: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
132: -- lock rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
133: -- Parameters
134: -- IN:
135: -- p_api_version IN NUMBER
136: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
137: --
138: -- p_custom_setup_id IN NUMBER
139: -- p_object_version IN NUMBER
140: --
145: ------------------------------------------------------------------------------
146: PROCEDURE lock_cust_setup
147: (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
163: -- validate the record
164: -- Parameters
165: -- IN:
166: -- p_api_version IN NUMBER
167: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
168: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
169: --
170: -- p_cust_setup_rec IN cust_setup_rec_type
171: --
164: -- Parameters
165: -- IN:
166: -- p_api_version IN NUMBER
167: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
168: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
169: --
170: -- p_cust_setup_rec IN cust_setup_rec_type
171: --
172: -- OUT:
176: ------------------------------------------------------------------------------
177: PROCEDURE validate_cust_setup
178: (
179: p_api_version IN NUMBER,
180: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
181: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
177: PROCEDURE validate_cust_setup
178: (
179: p_api_version IN NUMBER,
180: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
181: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: