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_rule_id IN NUMBER
42: );
43:
44: procedure lock_restriction (
45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
50: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43:
44: procedure lock_restriction (
45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
50: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: ,p_rule_id IN NUMBER
81: );
82:
83: procedure update_restriction (
84: p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
89: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82:
83: procedure update_restriction (
84: p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
89: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: ,p_rule_id IN NUMBER
120: ) ;
121:
122: procedure delete_restriction (
123: p_api_version in NUMBER,
124: p_init_msg_list in varchar2 := fnd_api.g_false,
125: p_validation_level in number := fnd_api.g_valid_level_full,
126: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
128: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121:
122: procedure delete_restriction (
123: p_api_version in NUMBER,
124: p_init_msg_list in varchar2 := fnd_api.g_false,
125: p_validation_level in number := fnd_api.g_valid_level_full,
126: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
128: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
129: p_rule_id IN NUMBER,