DBA Data[Home] [Help]

APPS.JTF_LOC_AREAS_PVT dependencies on FND_API

Line 37: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

Line 38: -- p_commit IN VARCHAR2 := FND_API.g_false

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: --

Line 39: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

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:

Line 53: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 54: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 55: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 73: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

Line 74: -- p_commit IN VARCHAR2 := FND_API.g_false

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'

Line 75: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

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: --

Line 88: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 89: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 108: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

Line 109: -- p_commit IN VARCHAR2 := FND_API.g_false

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: --

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 123: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 141: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

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: --

Line 154: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 173: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

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: --

Line 174: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

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:

Line 186: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,