DBA Data[Home] [Help]

APPS.JTF_LOC_HIERARCHIES_PVT dependencies on FND_API

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

42: -- create a row in JTF_LOC_HIERARCHIES_B
43: -- Parameters
44: -- IN:
45: -- p_api_version IN NUMBER
46: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
47: -- p_commit IN VARCHAR2 := FND_API.g_false
48: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
49: --
50: -- p_loc_hier_rec IN loc_hier_rec_type

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

43: -- Parameters
44: -- IN:
45: -- p_api_version IN NUMBER
46: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
47: -- p_commit IN VARCHAR2 := FND_API.g_false
48: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
49: --
50: -- p_loc_hier_rec IN loc_hier_rec_type
51: --

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

44: -- IN:
45: -- p_api_version IN NUMBER
46: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
47: -- p_commit IN VARCHAR2 := FND_API.g_false
48: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
49: --
50: -- p_loc_hier_rec IN loc_hier_rec_type
51: --
52: -- OUT:

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

57: ------------------------------------------------------------------------------
58: PROCEDURE create_hierarchy
59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

58: PROCEDURE create_hierarchy
59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
67: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

78: -- update a row in JTF_LOC_HIERARCHIES_B
79: -- Parameters
80: -- IN:
81: -- p_api_version IN NUMBER
82: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
83: -- p_commit IN VARCHAR2 := FND_API.g_false
84: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
85: --
86: -- p_loc_hier_rec IN loc_hier_rec_type

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

79: -- Parameters
80: -- IN:
81: -- p_api_version IN NUMBER
82: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
83: -- p_commit IN VARCHAR2 := FND_API.g_false
84: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
85: --
86: -- p_loc_hier_rec IN loc_hier_rec_type
87: --

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

80: -- IN:
81: -- p_api_version IN NUMBER
82: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
83: -- p_commit IN VARCHAR2 := FND_API.g_false
84: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
85: --
86: -- p_loc_hier_rec IN loc_hier_rec_type
87: --
88: -- OUT:

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

92: ------------------------------------------------------------------------------
93: PROCEDURE update_hierarchy
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97: p_commit IN VARCHAR2 := FND_API.g_false,
98: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
99:
100: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

93: PROCEDURE update_hierarchy
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97: p_commit IN VARCHAR2 := FND_API.g_false,
98: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
99:
100: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97: p_commit IN VARCHAR2 := FND_API.g_false,
98: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
99:
100: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
102: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

112: -- delete a row in JTF_LOC_HIERARCHIES_B
113: -- Parameters
114: -- IN:
115: -- p_api_version IN NUMBER
116: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
117: -- p_commit IN VARCHAR2 := FND_API.g_false
118: --
119: -- p_hier_id IN NUMBER
120: -- p_object_version IN NUMBER

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

113: -- Parameters
114: -- IN:
115: -- p_api_version IN NUMBER
116: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
117: -- p_commit IN VARCHAR2 := FND_API.g_false
118: --
119: -- p_hier_id IN NUMBER
120: -- p_object_version IN NUMBER
121: --

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

126: ------------------------------------------------------------------------------
127: PROCEDURE delete_hierarchy
128: (
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
131: p_commit IN VARCHAR2 := FND_API.g_false,
132:
133: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

127: PROCEDURE delete_hierarchy
128: (
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
131: p_commit IN VARCHAR2 := FND_API.g_false,
132:
133: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
135: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

146: -- delete a row in JTF_LOC_HIERARCHIES_B
147: -- Parameters
148: -- IN:
149: -- p_api_version IN NUMBER
150: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
151: --
152: -- p_hier_id IN NUMBER
153: -- p_object_version IN NUMBER
154: --

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

159: ------------------------------------------------------------------------------
160: PROCEDURE lock_hierarchy
161: (
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
164:
165: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
166: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
167: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

178: -- validate a record before inserting or updating JTF_LOC_HIERARCHIES_B
179: -- Parameters
180: -- IN:
181: -- p_api_version IN NUMBER
182: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
184: --
185: -- p_loc_hier_rec IN loc_hier_rec_type
186: --

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

179: -- Parameters
180: -- IN:
181: -- p_api_version IN NUMBER
182: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
183: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
184: --
185: -- p_loc_hier_rec IN loc_hier_rec_type
186: --
187: -- OUT:

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

191: ------------------------------------------------------------------------------
192: PROCEDURE validate_hierarchy
193: (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197:
198: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
199: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

192: PROCEDURE validate_hierarchy
193: (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197:
198: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
199: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
200: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,