28: -- Main procedure
29: -- ------------------------------------------------------------------
30: PROCEDURE generate_grant(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_object_name IN VARCHAR2,
36: p_function_type IN VARCHAR2,
29: -- ------------------------------------------------------------------
30: PROCEDURE generate_grant(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_object_name IN VARCHAR2,
36: p_function_type IN VARCHAR2,
37: x_where_clause OUT NOCOPY VARCHAR2,
30: PROCEDURE generate_grant(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_object_name IN VARCHAR2,
36: p_function_type IN VARCHAR2,
37: x_where_clause OUT NOCOPY VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2,
41: );
42:
43: PROCEDURE construct_grant(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
48: p_grant_id IN NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2,
42:
43: PROCEDURE construct_grant(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
48: p_grant_id IN NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
43: PROCEDURE construct_grant(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
48: p_grant_id IN NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2
67:
68:
69: PROCEDURE populate_user_attrib(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_attrib_id IN NUMBER := NULL,
75: p_user_id IN NUMBER := NULL,
68:
69: PROCEDURE populate_user_attrib(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_attrib_id IN NUMBER := NULL,
75: p_user_id IN NUMBER := NULL,
76: p_all_attribs IN VARCHAR2 :='N',
69: PROCEDURE populate_user_attrib(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_attrib_id IN NUMBER := NULL,
75: p_user_id IN NUMBER := NULL,
76: p_all_attribs IN VARCHAR2 :='N',
77: x_return_status OUT NOCOPY VARCHAR2,
81:
82:
83: PROCEDURE unlock_all_grants(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
82:
83: PROCEDURE unlock_all_grants(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
90: p_obj_group_id IN NUMBER,
83: PROCEDURE unlock_all_grants(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
90: p_obj_group_id IN NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
90: p_obj_group_id IN NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,
90: p_obj_group_id IN NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2
94: );
95:
96: PROCEDURE lock_all_grants(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
101: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
102: p_obj_group_id IN NUMBER,
95:
96: PROCEDURE lock_all_grants(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
101: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
102: p_obj_group_id IN NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2,
96: PROCEDURE lock_all_grants(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
101: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
102: p_obj_group_id IN NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
101: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,
102: p_obj_group_id IN NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2