DBA Data[Home] [Help]

APPS.IGS_SC_GRANTS_PVT dependencies on FND_API

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 46: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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

Line 71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 72: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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',

Line 73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 86: p_commit 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,

Line 87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 88: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 89: p_disable_security IN VARCHAR2 := FND_API.G_FALSE,

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

Line 98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 99: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 101: p_conc_program_flag IN VARCHAR2 := FND_API.G_FALSE,

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