3:
4: procedure insert_restriction
5: (
6: p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
8: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
9: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4: procedure insert_restriction
5: (
6: p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
8: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
9: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12: ,p_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43: );
44:
45: procedure lock_restriction (
46: p_api_version IN NUMBER
47: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
48: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
49: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
51: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44:
45: procedure lock_restriction (
46: p_api_version IN NUMBER
47: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
48: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
49: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
51: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52: ,p_rowid IN VARCHAR2
83: );
84:
85: procedure update_restriction (
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
88: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
89: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84:
85: procedure update_restriction (
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
88: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
89: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: ,p_rowid IN VARCHAR2
123: ) ;
124:
125: procedure delete_restriction (
126: p_api_version in NUMBER,
127: p_init_msg_list in varchar2 := fnd_api.g_false,
128: p_validation_level in number := fnd_api.g_valid_level_full,
129: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
131: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
124:
125: procedure delete_restriction (
126: p_api_version in NUMBER,
127: p_init_msg_list in varchar2 := fnd_api.g_false,
128: p_validation_level in number := fnd_api.g_valid_level_full,
129: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
131: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
132: p_rowid IN VARCHAR2,