eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on FND_API

Line 33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

29: -- -----------------------------------------------------------------
30: -- APIs for the inserting of data into security data model framework
31: -- -----------------------------------------------------------------
32: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

Line 34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

30: -- APIs for the inserting of data into security data model framework
31: -- -----------------------------------------------------------------
32: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
36: p_function_id IN igs_sc_grants.function_id%TYPE,
37: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
38: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,

Line 50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

46: x_return_message OUT NOCOPY VARCHAR2
47: );
48:
49: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

Line 51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

47: );
48:
49: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

59: x_return_message OUT NOCOPY VARCHAR2
60: );
61:
62: PROCEDURE Insert_Object_Group (p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
66: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
67: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,

Line 64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

60: );
61:
62: PROCEDURE Insert_Object_Group (p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
66: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
67: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
68: x_return_status OUT NOCOPY VARCHAR2,

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

69: x_return_message OUT NOCOPY VARCHAR2
70: );
71:
72: PROCEDURE Insert_Object_Attr (p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
76: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
77: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,

Line 74: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

70: );
71:
72: PROCEDURE Insert_Object_Attr (p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
76: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
77: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
78: p_active_flag IN VARCHAR2 DEFAULT 'Y',

Line 84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

80: x_return_message OUT NOCOPY VARCHAR2
81: );
82:
83: PROCEDURE Insert_Object_Attr_Method (p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
87: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
88: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,

Line 85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

81: );
82:
83: PROCEDURE Insert_Object_Attr_Method (p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
87: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
88: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
89: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

93: x_return_status OUT NOCOPY VARCHAR2,
94: x_return_message OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE Insert_Object_Func (p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
100: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
101: p_function_name IN igs_sc_obj_functns.function_name%TYPE,

Line 98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

94: x_return_message OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE Insert_Object_Func (p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
100: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
101: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
102: x_return_status OUT NOCOPY VARCHAR2,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

103: x_return_message OUT NOCOPY VARCHAR2
104: );
105:
106: PROCEDURE Insert_Object (p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,

Line 108: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

104: );
105:
106: PROCEDURE Insert_Object (p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109: p_object_id IN OUT NOCOPY igs_sc_objects.object_id%TYPE,
110: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
111: p_obj_name IN fnd_objects.obj_name%TYPE ,
112: p_database_object_name IN fnd_objects.database_object_name%TYPE ,

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

131: );
132:
133:
134: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

Line 136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

132:
133:
134: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

145: );
146:
147: PROCEDURE Insert_Local_Role (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_role_name IN VARCHAR2,
152: p_role_display_name IN VARCHAR2,
153: p_orig_system IN VARCHAR2,

Line 150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

146:
147: PROCEDURE Insert_Local_Role (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_role_name IN VARCHAR2,
152: p_role_display_name IN VARCHAR2,
153: p_orig_system IN VARCHAR2,
154: p_orig_system_id IN NUMBER,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

165: x_return_message OUT NOCOPY VARCHAR2
166: ) ;
167:
168: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

Line 170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

166: ) ;
167:
168: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_user_name IN wf_local_user_roles.user_name%TYPE,
172: p_role_name IN wf_local_user_roles.role_name%TYPE,
173: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
174: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

184: -- -----------------------------------------------------------------
185: -- APIs for the updating of data into security data model framework
186: -- -----------------------------------------------------------------
187: PROCEDURE Update_Local_Role (p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: p_role_name IN VARCHAR2,
191: p_role_display_name IN VARCHAR2,
192: p_orig_system IN VARCHAR2,

Line 189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

185: -- APIs for the updating of data into security data model framework
186: -- -----------------------------------------------------------------
187: PROCEDURE Update_Local_Role (p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: p_role_name IN VARCHAR2,
191: p_role_display_name IN VARCHAR2,
192: p_orig_system IN VARCHAR2,
193: p_orig_system_id IN NUMBER,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

204: x_return_message OUT NOCOPY VARCHAR2
205: );
206:
207: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

Line 209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

205: );
206:
207: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_user_name IN wf_local_user_roles.user_name%TYPE,
211: p_role_name IN wf_local_user_roles.role_name%TYPE,
212: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
213: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

220: x_return_message OUT NOCOPY VARCHAR2
221: );
222:
223: PROCEDURE Update_Grant (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

Line 225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

221: );
222:
223: PROCEDURE Update_Grant (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_grant_id IN igs_sc_grants.grant_id%TYPE,
227: p_function_id IN igs_sc_grants.function_id%TYPE,
228: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
229: p_grant_name IN igs_sc_grants.grant_name%TYPE,

Line 240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

236: x_return_message OUT NOCOPY VARCHAR2
237: );
238:
239: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

Line 241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

237: );
238:
239: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,

Line 254: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

250: x_return_message OUT NOCOPY VARCHAR2
251: );
252:
253: PROCEDURE Update_Object_Group (p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
255: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
256: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
257: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
258: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,

Line 255: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

251: );
252:
253: PROCEDURE Update_Object_Group (p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
255: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
256: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
257: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
258: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,

Line 264: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

260: x_return_message OUT NOCOPY VARCHAR2
261: );
262:
263: PROCEDURE Update_Object_Attr_Method (p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
267: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
268: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,

Line 265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

261: );
262:
263: PROCEDURE Update_Object_Attr_Method (p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
267: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
268: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
269: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

274: x_return_message OUT NOCOPY VARCHAR2
275: );
276:
277: PROCEDURE Update_Object_Func (p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
281: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
282: p_function_name IN igs_sc_obj_functns.function_name%TYPE,

Line 279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

275: );
276:
277: PROCEDURE Update_Object_Func (p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
281: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
282: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
283: x_return_status OUT NOCOPY VARCHAR2,

Line 288: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

284: x_return_message OUT NOCOPY VARCHAR2
285: );
286:
287: PROCEDURE Update_Object_Attr (p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
289: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
290: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
291: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
292: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,

Line 289: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

285: );
286:
287: PROCEDURE Update_Object_Attr (p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
289: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
290: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
291: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
292: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
293: p_active_flag IN VARCHAR2 DEFAULT 'Y',

Line 299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

295: x_return_message OUT NOCOPY VARCHAR2
296: );
297:
298: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

Line 300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

296: );
297:
298: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

Line 312: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

308: x_return_message OUT NOCOPY VARCHAR2
309: );
310:
311: PROCEDURE Update_Object (p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_object_id IN igs_sc_objects.object_id%TYPE,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,

Line 313: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

309: );
310:
311: PROCEDURE Update_Object (p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_object_id IN igs_sc_objects.object_id%TYPE,
315: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
316: p_obj_name IN fnd_objects.obj_name%TYPE ,
317: p_database_object_name IN fnd_objects.database_object_name%TYPE ,

Line 341: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

337: -- -----------------------------------------------------------------
338: -- APIs for the deleting of data into security data model framework
339: -- -----------------------------------------------------------------
340: PROCEDURE Delete_Object_Group (p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
342: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
343: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_return_message OUT NOCOPY VARCHAR2

Line 342: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

338: -- APIs for the deleting of data into security data model framework
339: -- -----------------------------------------------------------------
340: PROCEDURE Delete_Object_Group (p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
342: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
343: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_return_message OUT NOCOPY VARCHAR2
346: );

Line 349: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

345: x_return_message OUT NOCOPY VARCHAR2
346: );
347:
348: PROCEDURE Delete_Object (p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
350: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
351: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
352: p_object_id IN igs_sc_objects.object_id%TYPE,
353: x_return_status OUT NOCOPY VARCHAR2,

Line 350: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

346: );
347:
348: PROCEDURE Delete_Object (p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
350: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
351: p_obj_group_id IN igs_sc_objects.obj_group_id%TYPE,
352: p_object_id IN igs_sc_objects.object_id%TYPE,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_return_message OUT NOCOPY VARCHAR2

Line 358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

354: x_return_message OUT NOCOPY VARCHAR2
355: );
356:
357: PROCEDURE Delete_Object_Attr (p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
359: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
360: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_return_message OUT NOCOPY VARCHAR2

Line 359: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

355: );
356:
357: PROCEDURE Delete_Object_Attr (p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
359: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
360: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_return_message OUT NOCOPY VARCHAR2
363: );

Line 366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

362: x_return_message OUT NOCOPY VARCHAR2
363: );
364:
365: PROCEDURE Delete_Object_Attr_Method (p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
368: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
369: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,

Line 367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

363: );
364:
365: PROCEDURE Delete_Object_Attr_Method (p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
367: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
368: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
369: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_return_message OUT NOCOPY VARCHAR2

Line 375: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

371: x_return_message OUT NOCOPY VARCHAR2
372: );
373:
374: PROCEDURE Delete_Object_Func (p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_return_message OUT NOCOPY VARCHAR2

Line 376: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

372: );
373:
374: PROCEDURE Delete_Object_Func (p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_return_message OUT NOCOPY VARCHAR2
380: );

Line 383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

379: x_return_message OUT NOCOPY VARCHAR2
380: );
381:
382: PROCEDURE Delete_Object_Attr_Val (p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
386: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
387: x_return_status OUT NOCOPY VARCHAR2,

Line 384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

380: );
381:
382: PROCEDURE Delete_Object_Attr_Val (p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
384: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
385: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
386: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_return_message OUT NOCOPY VARCHAR2

Line 392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

388: x_return_message OUT NOCOPY VARCHAR2
389: );
390:
391: PROCEDURE Delete_User_Attr (p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_return_message OUT NOCOPY VARCHAR2

Line 393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

389: );
390:
391: PROCEDURE Delete_User_Attr (p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_return_message OUT NOCOPY VARCHAR2
397: );

Line 400: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

396: x_return_message OUT NOCOPY VARCHAR2
397: );
398:
399: PROCEDURE Delete_User_Attr_Val (p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
401: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
403: p_user_id IN NUMBER,
404: x_return_status OUT NOCOPY VARCHAR2,

Line 401: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

397: );
398:
399: PROCEDURE Delete_User_Attr_Val (p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
401: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
403: p_user_id IN NUMBER,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_return_message OUT NOCOPY VARCHAR2

Line 409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

405: x_return_message OUT NOCOPY VARCHAR2
406: );
407:
408: PROCEDURE Delete_Grant (p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
411: p_grant_id IN igs_sc_grants.grant_id%TYPE,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_return_message OUT NOCOPY VARCHAR2

Line 410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

406: );
407:
408: PROCEDURE Delete_Grant (p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
410: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
411: p_grant_id IN igs_sc_grants.grant_id%TYPE,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_return_message OUT NOCOPY VARCHAR2
414: );

Line 417: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

413: x_return_message OUT NOCOPY VARCHAR2
414: );
415:
416: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
418: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
420: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
421: x_return_status OUT NOCOPY VARCHAR2,

Line 418: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

414: );
415:
416: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
418: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
420: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_return_message OUT NOCOPY VARCHAR2

Line 426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

422: x_return_message OUT NOCOPY VARCHAR2
423: );
424:
425: PROCEDURE Delete_Local_Role (p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
427: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
428: x_return_status OUT NOCOPY VARCHAR2,
429: x_return_message OUT NOCOPY VARCHAR2
430: );

Line 427: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

423: );
424:
425: PROCEDURE Delete_Local_Role (p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
427: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
428: x_return_status OUT NOCOPY VARCHAR2,
429: x_return_message OUT NOCOPY VARCHAR2
430: );
431:

Line 433: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

429: x_return_message OUT NOCOPY VARCHAR2
430: );
431:
432: PROCEDURE Delete_Local_User_Role (p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_return_message OUT NOCOPY VARCHAR2
437: );

Line 434: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

430: );
431:
432: PROCEDURE Delete_Local_User_Role (p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_return_message OUT NOCOPY VARCHAR2
437: );
438: -- -----------------------------------------------------------------

Line 442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

438: -- -----------------------------------------------------------------
439: -- Other APIs to be used for Security purposes.
440: -- -----------------------------------------------------------------
441: PROCEDURE Lock_Grant (p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
444: p_grant_id IN igs_sc_grants.grant_id%TYPE,
445: x_return_status OUT NOCOPY VARCHAR2,
446: x_return_message OUT NOCOPY VARCHAR2

Line 443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

439: -- Other APIs to be used for Security purposes.
440: -- -----------------------------------------------------------------
441: PROCEDURE Lock_Grant (p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
444: p_grant_id IN igs_sc_grants.grant_id%TYPE,
445: x_return_status OUT NOCOPY VARCHAR2,
446: x_return_message OUT NOCOPY VARCHAR2
447: );

Line 450: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

446: x_return_message OUT NOCOPY VARCHAR2
447: );
448:
449: PROCEDURE Unlock_Grant (p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
451: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
452: p_grant_id IN igs_sc_grants.grant_id%TYPE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_return_message OUT NOCOPY VARCHAR2

Line 451: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

447: );
448:
449: PROCEDURE Unlock_Grant (p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
451: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
452: p_grant_id IN igs_sc_grants.grant_id%TYPE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_return_message OUT NOCOPY VARCHAR2
455: );

Line 481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

477: p_database_object_name IN VARCHAR2 );
478:
479: PROCEDURE enable_upgrade_mode (
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_data OUT NOCOPY VARCHAR2

Line 482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

478:
479: PROCEDURE enable_upgrade_mode (
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_data OUT NOCOPY VARCHAR2
486: );

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

489: PROCEDURE change_seq ;
490:
491: PROCEDURE Generate_SQL_file(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_commit IN VARCHAR2 := FND_API.G_FALSE,
495: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,

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

490:
491: PROCEDURE Generate_SQL_file(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_commit IN VARCHAR2 := FND_API.G_FALSE,
495: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,

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

491: PROCEDURE Generate_SQL_file(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_commit IN VARCHAR2 := FND_API.G_FALSE,
495: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,
499: p_dirpath IN VARCHAR2,