33: -- create a row in JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
34: -- Parameters
35: -- IN:
36: -- p_api_version IN NUMBER
37: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
38: -- p_commit IN VARCHAR2 := FND_API.g_false
39: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
40: --
41: -- p_loc_area_rec IN loc_area_rec_type
34: -- Parameters
35: -- IN:
36: -- p_api_version IN NUMBER
37: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
38: -- p_commit IN VARCHAR2 := FND_API.g_false
39: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
40: --
41: -- p_loc_area_rec IN loc_area_rec_type
42: --
35: -- IN:
36: -- p_api_version IN NUMBER
37: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
38: -- p_commit IN VARCHAR2 := FND_API.g_false
39: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
40: --
41: -- p_loc_area_rec IN loc_area_rec_type
42: --
43: -- OUT:
49: ------------------------------------------------------------------------------
50: PROCEDURE create_loc_area
51: (
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
54: p_commit IN VARCHAR2 := FND_API.g_false,
55: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
56:
57: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50: PROCEDURE create_loc_area
51: (
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
54: p_commit IN VARCHAR2 := FND_API.g_false,
55: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
56:
57: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
51: (
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
54: p_commit IN VARCHAR2 := FND_API.g_false,
55: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
56:
57: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
59: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69: -- update a row in JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
70: -- Parameters
71: -- IN:
72: -- p_api_version IN NUMBER
73: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
74: -- p_commit IN VARCHAR2 := FND_API.g_false
75: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
76: --
77: -- p_loc_area_rec IN loc_area_rec_type
70: -- Parameters
71: -- IN:
72: -- p_api_version IN NUMBER
73: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
74: -- p_commit IN VARCHAR2 := FND_API.g_false
75: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
76: --
77: -- p_loc_area_rec IN loc_area_rec_type
78: -- p_remove_flag IN VARCHAR2 := 'N'
71: -- IN:
72: -- p_api_version IN NUMBER
73: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
74: -- p_commit IN VARCHAR2 := FND_API.g_false
75: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
76: --
77: -- p_loc_area_rec IN loc_area_rec_type
78: -- p_remove_flag IN VARCHAR2 := 'N'
79: --
84: ------------------------------------------------------------------------------
85: PROCEDURE update_loc_area
86: (
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
89: p_commit IN VARCHAR2 := FND_API.g_false,
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91:
92: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: PROCEDURE update_loc_area
86: (
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
89: p_commit IN VARCHAR2 := FND_API.g_false,
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91:
92: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
86: (
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
89: p_commit IN VARCHAR2 := FND_API.g_false,
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91:
92: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
94: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: -- delete a row from JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
105: -- Parameters
106: -- IN:
107: -- p_api_version IN NUMBER
108: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
109: -- p_commit IN VARCHAR2 := FND_API.g_false
110: --
111: -- p_loc_area_id IN NUMBER
112: -- p_object_version IN NUMBER
105: -- Parameters
106: -- IN:
107: -- p_api_version IN NUMBER
108: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
109: -- p_commit IN VARCHAR2 := FND_API.g_false
110: --
111: -- p_loc_area_id IN NUMBER
112: -- p_object_version IN NUMBER
113: --
118: ------------------------------------------------------------------------------
119: PROCEDURE delete_loc_area
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124:
125: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
126: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
119: PROCEDURE delete_loc_area
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124:
125: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
126: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
127: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
137: -- lock a row form JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
138: -- Parameters
139: -- IN:
140: -- p_api_version IN NUMBER
141: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
142: --
143: -- p_loc_area_id IN NUMBER
144: -- p_object_version IN NUMBER
145: --
150: ------------------------------------------------------------------------------
151: PROCEDURE lock_loc_area
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
155:
156: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
157: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
158: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
169: -- JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
170: -- Parameters
171: -- IN:
172: -- p_api_version IN NUMBER
173: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
174: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
175: --
176: -- p_loc_area_rec IN loc_area_rec_type
177: --
170: -- Parameters
171: -- IN:
172: -- p_api_version IN NUMBER
173: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
174: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
175: --
176: -- p_loc_area_rec IN loc_area_rec_type
177: --
178: -- OUT:
182: ------------------------------------------------------------------------------
183: PROCEDURE validate_loc_area
184: (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188:
189: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
183: PROCEDURE validate_loc_area
184: (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188:
189: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
191: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,