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.IBC_DATA_SECURITY_PVT dependencies on FND_OBJECTS

Line 33: FROM fnd_objects

29: pk2_column_type,
30: pk3_column_type,
31: pk4_column_type,
32: pk5_column_type
33: FROM fnd_objects
34: WHERE object_id = p_object_id;
35:
36: -- ------------------------------------------------------------
37: -- Internal Function to be used when building a SQL statement

Line 290: * from FND_OBJECTS

286: END get_object_grant_group_info;
287:
288: /*#
289: * Given the object name it returns corrsponding object id
290: * from FND_OBJECTS
291: *
292: * @param p_object_name Object Name in FND_OBJECTS
293: * @return Object Id
294: *

Line 292: * @param p_object_name Object Name in FND_OBJECTS

288: /*#
289: * Given the object name it returns corrsponding object id
290: * from FND_OBJECTS
291: *
292: * @param p_object_name Object Name in FND_OBJECTS
293: * @return Object Id
294: *
295: * @rep:displayname get_object_id
296: *

Line 304: FROM fnd_objects

300: ) RETURN NUMBER AS
301: l_result NUMBER;
302: CURSOR c_object_id(p_object_name VARCHAR2) IS
303: SELECT object_id
304: FROM fnd_objects
305: WHERE obj_name = p_object_name;
306: BEGIN
307: OPEN c_object_id(p_object_name);
308: FETCH c_object_id INTO l_result;

Line 343: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

339: /*#
340: * It sets inheritance type of an instance already existing in data
341: * security inheritance tree.
342: *
343: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
344: * for this particular instance
345: * @param p_instance_pk1_value value 1 for instance's primary key
346: * @param p_instance_pk2_value value 2 for instance's primary key
347: * @param p_instance_pk3_value value 3 for instance's primary key

Line 551: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

547: * It removes an instance from data security inheritance tree. This procedure
548: * should be called when the directory node gets removed from the system as well,
549: * to keep inheritance information accurate.
550: *
551: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
552: * for this particular instance
553: * @param p_instance_pk1_value value 1 for instance's primary key
554: * @param p_instance_pk2_value value 2 for instance's primary key
555: * @param p_instance_pk3_value value 3 for instance's primary key

Line 745: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

741: * inheritance link between an instance (child) and its container (parent).
742: * This procedure must be called for each container (i.e. directory node)
743: * create to define a hierarchy of containment and inheritance
744: *
745: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
746: * for this particular instance
747: * @param p_instance_pk1_value value 1 for instance's primary key
748: * @param p_instance_pk2_value value 2 for instance's primary key
749: * @param p_instance_pk3_value value 3 for instance's primary key

Line 752: * @param p_container_object_id ID for object definition id found in FND_OBJECTS

748: * @param p_instance_pk2_value value 2 for instance's primary key
749: * @param p_instance_pk3_value value 3 for instance's primary key
750: * @param p_instance_pk4_value value 4 for instance's primary key
751: * @param p_instance_pk5_value value 5 for instance's primary key
752: * @param p_container_object_id ID for object definition id found in FND_OBJECTS
753: * for the container
754: * @param p_container_pk1_value value 1 for container's primary key
755: * @param p_container_pk2_value value 2 for container's primary key
756: * @param p_container_pk3_value value 3 for container's primary key

Line 1145: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

1141: * This procedure must be called for each container (i.e. directory node)
1142: * create to define a hierarchy of containment and inheritance.
1143: * This is overloaded of establish_inheritance without inheritance type parm.
1144: *
1145: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
1146: * for this particular instance
1147: * @param p_instance_pk1_value value 1 for instance's primary key
1148: * @param p_instance_pk2_value value 2 for instance's primary key
1149: * @param p_instance_pk3_value value 3 for instance's primary key

Line 1152: * @param p_container_object_id ID for object definition id found in FND_OBJECTS

1148: * @param p_instance_pk2_value value 2 for instance's primary key
1149: * @param p_instance_pk3_value value 3 for instance's primary key
1150: * @param p_instance_pk4_value value 4 for instance's primary key
1151: * @param p_instance_pk5_value value 5 for instance's primary key
1152: * @param p_container_object_id ID for object definition id found in FND_OBJECTS
1153: * for the container
1154: * @param p_container_pk1_value value 1 for container's primary key
1155: * @param p_container_pk2_value value 2 for container's primary key
1156: * @param p_container_pk3_value value 3 for container's primary key

Line 1222: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

1218: * It Resets all permissions, and makes the instance to inherit
1219: * all permissions from parent. This procedure gets called when
1220: * in the UI the user selects "Inherit"
1221: *
1222: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
1223: * for this particular instance
1224: * @param p_instance_pk1_value value 1 for instance's primary key
1225: * @param p_instance_pk2_value value 2 for instance's primary key
1226: * @param p_instance_pk3_value value 3 for instance's primary key

Line 1473: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

1469: * on "Override", and it is useful so even though the user doesn't
1470: * make any other modification, the inheritance is already broken
1471: * and can be saved as such.
1472: *
1473: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
1474: * for this particular instance
1475: * @param p_instance_pk1_value value 1 for instance's primary key
1476: * @param p_instance_pk2_value value 2 for instance's primary key
1477: * @param p_instance_pk3_value value 3 for instance's primary key

Line 1830: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

1826: /*#
1827: * Grants a permission on a particular object instance (or contained objects)
1828: * to a user.
1829: *
1830: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
1831: * for this particular instance
1832: * @param p_instance_pk1_value value 1 for instance's primary key
1833: * @param p_instance_pk2_value value 2 for instance's primary key
1834: * @param p_instance_pk3_value value 3 for instance's primary key

Line 1847: * @param p_container_object_id ID for object definition id found in FND_OBJECTS

1843: * means ANYBODY
1844: * @param p_grantee_resource_id Resource Id
1845: * @param p_grantee_resource_type Resource Type. Resource receiving permission
1846: * if not especified it means ANYBODY
1847: * @param p_container_object_id ID for object definition id found in FND_OBJECTS
1848: * for the container
1849: * @param p_container_pk1_value value 1 for container's primary key
1850: * @param p_container_pk2_value value 2 for container's primary key
1851: * @param p_container_pk3_value value 3 for container's primary key

Line 2420: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

2416: /*#
2417: * Grants a permission on a particular object instance (or contained objects)
2418: * to a user.
2419: *
2420: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
2421: * for this particular instance
2422: * @param p_instance_pk1_value value 1 for instance's primary key
2423: * @param p_instance_pk2_value value 2 for instance's primary key
2424: * @param p_instance_pk3_value value 3 for instance's primary key

Line 2434: * @param p_container_object_id ID for object definition id found in FND_OBJECTS

2430: * being granted
2431: * @param p_permission_code Permission being granted
2432: * @param p_grantee_user_id User receiving permission, If not especified it
2433: * means ANYBODY
2434: * @param p_container_object_id ID for object definition id found in FND_OBJECTS
2435: * for the container
2436: * @param p_container_pk1_value value 1 for container's primary key
2437: * @param p_container_pk2_value value 2 for container's primary key
2438: * @param p_container_pk3_value value 3 for container's primary key

Line 2518: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

2514: * Grants a permission on a particular object instance
2515: * (or contained objects) to ANYBODY (if p_grantee_resource_id and
2516: * type are not passed) or a particular resource.
2517: *
2518: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
2519: * for this particular instance
2520: * @param p_instance_pk1_value value 1 for instance's primary key
2521: * @param p_instance_pk2_value value 2 for instance's primary key
2522: * @param p_instance_pk3_value value 3 for instance's primary key

Line 2533: * @param p_container_object_id ID for object definition id found in FND_OBJECTS

2529: * @param p_permission_code Permission being granted
2530: * @param p_grantee_resource_id Resource Id
2531: * @param p_grantee_resource_type Resource Type. Resource receiving permission
2532: * if not especified it means ANYBODY
2533: * @param p_container_object_id ID for object definition id found in FND_OBJECTS
2534: * for the container
2535: * @param p_container_pk1_value value 1 for container's primary key
2536: * @param p_container_pk2_value value 2 for container's primary key
2537: * @param p_container_pk3_value value 3 for container's primary key

Line 2617: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

2613: /*#
2614: * Revokes a especific permission already given, do not confuse this
2615: * with a grant to RESTRICT a permission.
2616: *
2617: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
2618: * for this particular instance
2619: * @param p_instance_pk1_value value 1 for instance's primary key
2620: * @param p_instance_pk2_value value 2 for instance's primary key
2621: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3130: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

3126: /*#
3127: * Revokes a especific permission already given, do not confuse this
3128: * with a grant to RESTRICT a permission.
3129: *
3130: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
3131: * for this particular instance
3132: * @param p_instance_pk1_value value 1 for instance's primary key
3133: * @param p_instance_pk2_value value 2 for instance's primary key
3134: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3203: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

3199: /*#
3200: * Revokes a especific permission already given, do not confuse this
3201: * with a grant to RESTRICT a permission.
3202: *
3203: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
3204: * for this particular instance
3205: * @param p_instance_pk1_value value 1 for instance's primary key
3206: * @param p_instance_pk2_value value 2 for instance's primary key
3207: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3278: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

3274: /*#
3275: * Checks whether an user has a particular permission on an
3276: * object instance
3277: *
3278: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
3279: * for this particular instance
3280: * @param p_instance_pk1_value value 1 for instance's primary key
3281: * @param p_instance_pk2_value value 2 for instance's primary key
3282: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3468: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

3464: /*#
3465: * Returns the list of permissions a user has on an object instance
3466: * as a string (comma separated and bracket delimited)
3467: *
3468: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
3469: * for this particular instance
3470: * @param p_instance_pk1_value value 1 for instance's primary key
3471: * @param p_instance_pk2_value value 2 for instance's primary key
3472: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3475: * @param p_container_object_id ID for container. Found in FND_OBJECTS

3471: * @param p_instance_pk2_value value 2 for instance's primary key
3472: * @param p_instance_pk3_value value 3 for instance's primary key
3473: * @param p_instance_pk4_value value 4 for instance's primary key
3474: * @param p_instance_pk5_value value 5 for instance's primary key
3475: * @param p_container_object_id ID for container. Found in FND_OBJECTS
3476: * @param p_container_pk1_value value 1 for container's primary key
3477: * @param p_container_pk2_value value 2 for container's primary key
3478: * @param p_container_pk3_value value 3 for container's primary key
3479: * @param p_container_pk4_value value 4 for container's primary key

Line 3683: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

3679:
3680: /*#
3681: * Returns the list of permissions a user has on an object instance
3682: *
3683: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
3684: * for this particular instance
3685: * @param p_instance_pk1_value value 1 for instance's primary key
3686: * @param p_instance_pk2_value value 2 for instance's primary key
3687: * @param p_instance_pk3_value value 3 for instance's primary key

Line 3690: * @param p_container_object_id ID for container. Found in FND_OBJECTS

3686: * @param p_instance_pk2_value value 2 for instance's primary key
3687: * @param p_instance_pk3_value value 3 for instance's primary key
3688: * @param p_instance_pk4_value value 4 for instance's primary key
3689: * @param p_instance_pk5_value value 5 for instance's primary key
3690: * @param p_container_object_id ID for container. Found in FND_OBJECTS
3691: * @param p_container_pk1_value value 1 for container's primary key
3692: * @param p_container_pk2_value value 2 for container's primary key
3693: * @param p_container_pk3_value value 3 for container's primary key
3694: * @param p_container_pk4_value value 4 for container's primary key

Line 4048: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

4044: * Procedure to obtain a list of users which has a particular
4045: * permission on a object's instance. The result is returned comma
4046: * separated.
4047: *
4048: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
4049: * for this particular instance
4050: * @param p_instance_pk1_value value 1 for instance's primary key
4051: * @param p_instance_pk2_value value 2 for instance's primary key
4052: * @param p_instance_pk3_value value 3 for instance's primary key

Line 4399: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

4395: * returns the list of grantee user ids who have a specific permission
4396: * on a given object instance. This doesn't include permissions given
4397: * to everybody (no grantee in particular) nor "RESTRICT" grants.
4398: *
4399: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
4400: * for this particular instance
4401: * @param p_instance_pk1_value value 1 for instance's primary key
4402: * @param p_instance_pk2_value value 2 for instance's primary key
4403: * @param p_instance_pk3_value value 3 for instance's primary key

Line 4653: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS

4649: * Returns information about inheritance, particularly the type of
4650: * inheritance, and if in fact this instance has its own permissions
4651: * or is still inheriting from parent container.
4652: *
4653: * @param p_instance_object_id ID for object definition id found in FND_OBJECTS
4654: * for this particular instance
4655: * @param p_instance_pk1_value value 1 for instance's primary key
4656: * @param p_instance_pk2_value value 2 for instance's primary key
4657: * @param p_instance_pk3_value value 3 for instance's primary key

Line 4660: * @param p_container_object_id ID for container. Found in FND_OBJECTS

4656: * @param p_instance_pk2_value value 2 for instance's primary key
4657: * @param p_instance_pk3_value value 3 for instance's primary key
4658: * @param p_instance_pk4_value value 4 for instance's primary key
4659: * @param p_instance_pk5_value value 5 for instance's primary key
4660: * @param p_container_object_id ID for container. Found in FND_OBJECTS
4661: * @param p_container_pk1_value value 1 for container's primary key
4662: * @param p_container_pk2_value value 2 for container's primary key
4663: * @param p_container_pk3_value value 3 for container's primary key
4664: * @param p_container_pk4_value value 4 for container's primary key