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.BIS_DELEGATION_PUB dependencies on FND_GRANTS

Line 23: -- Constants for the FND_GRANTS when used for PMV delegation

19: REM | |
20: REM +=======================================================================+
21: */
22: --
23: -- Constants for the FND_GRANTS when used for PMV delegation
24: g_c_program_name CONSTANT FND_GRANTS.program_name%TYPE := 'BIS_PMV_GRANTS';
25: -- Exceptions
26: g_e_INVALID_DATES EXCEPTION; -- either or both dates not
27: g_e_INVALID_DELEGATION_TYPE EXCEPTION; -- delegate type not defined

Line 24: g_c_program_name CONSTANT FND_GRANTS.program_name%TYPE := 'BIS_PMV_GRANTS';

20: REM +=======================================================================+
21: */
22: --
23: -- Constants for the FND_GRANTS when used for PMV delegation
24: g_c_program_name CONSTANT FND_GRANTS.program_name%TYPE := 'BIS_PMV_GRANTS';
25: -- Exceptions
26: g_e_INVALID_DATES EXCEPTION; -- either or both dates not
27: g_e_INVALID_DELEGATION_TYPE EXCEPTION; -- delegate type not defined
28: g_e_INVALID_FND_OBJECT EXCEPTION; -- object not defined

Line 38: (parameter1 fnd_grants.parameter1%TYPE -- delegate type

34: -- Note: Need to Populate and stay resident in session memory
35: --
36: -- Define global record type
37: TYPE g_rec_delegate_type_t IS RECORD
38: (parameter1 fnd_grants.parameter1%TYPE -- delegate type
39: ,grantee_type fnd_grants.grantee_type%TYPE
40: ,instance_type fnd_grants.instance_type%TYPE
41: ,object_id fnd_objects.object_id%TYPE --runtime TBD
42: ,object_name fnd_objects.obj_name%TYPE -- grantee object

Line 39: ,grantee_type fnd_grants.grantee_type%TYPE

35: --
36: -- Define global record type
37: TYPE g_rec_delegate_type_t IS RECORD
38: (parameter1 fnd_grants.parameter1%TYPE -- delegate type
39: ,grantee_type fnd_grants.grantee_type%TYPE
40: ,instance_type fnd_grants.instance_type%TYPE
41: ,object_id fnd_objects.object_id%TYPE --runtime TBD
42: ,object_name fnd_objects.obj_name%TYPE -- grantee object
43: ,object_database_object_name fnd_objects.database_object_name%TYPE

Line 40: ,instance_type fnd_grants.instance_type%TYPE

36: -- Define global record type
37: TYPE g_rec_delegate_type_t IS RECORD
38: (parameter1 fnd_grants.parameter1%TYPE -- delegate type
39: ,grantee_type fnd_grants.grantee_type%TYPE
40: ,instance_type fnd_grants.instance_type%TYPE
41: ,object_id fnd_objects.object_id%TYPE --runtime TBD
42: ,object_name fnd_objects.obj_name%TYPE -- grantee object
43: ,object_database_object_name fnd_objects.database_object_name%TYPE
44: ,object_pk1_column_name fnd_objects.pk1_column_name%TYPE --runtime TBD

Line 61: INDEX BY fnd_grants.parameter1%TYPE; -- Index by delegate type indentifier

57: );
58: -- Define global table / collection of record
59: TYPE g_tbl_delegate_type_t
60: IS TABLE OF g_rec_delegate_type_t
61: INDEX BY fnd_grants.parameter1%TYPE; -- Index by delegate type indentifier
62: -- Define global table of records
63: g_tbl_delegate_type g_tbl_delegate_type_t;
64: --
65: --------------------------------------------------------------------------------

Line 100: l_delegate_type fnd_grants.parameter1%TYPE;

96: --------------------------------------------------------------------------------
97: PROCEDURE setup_globals
98: IS
99: --
100: l_delegate_type fnd_grants.parameter1%TYPE;
101: --
102: l_object_id fnd_objects.object_id%TYPE;
103: l_object_database_object_name fnd_objects.database_object_name%TYPE;
104: l_object_pk1_column_name fnd_objects.pk1_column_name%TYPE;

Line 436: FROM fnd_grants g

432: ,cp_parameter1 IN VARCHAR2
433: )
434: IS
435: SELECT g.grant_guid
436: FROM fnd_grants g
437: WHERE g.grantee_type = cp_grantee_type
438: AND g.grantee_key = cp_grantee_key
439: AND g.menu_id = cp_menu_id
440: AND (cp_end_date IS NULL

Line 451: l_grant_guid fnd_grants.grant_guid%TYPE;

447: OR cp_instance_pk2_value = g.instance_pk2_value)
448: AND g.parameter1 = cp_parameter1
449: AND g.program_name = g_c_program_name
450: ;
451: l_grant_guid fnd_grants.grant_guid%TYPE;
452: --
453: BEGIN
454: --
455: dbg(' Grant_Exists----------------');

Line 578: FROM fnd_grants g

574: , g.object_id
575: , g.instance_pk1_value
576: , g.instance_pk2_value
577: , g.parameter1
578: FROM fnd_grants g
579: WHERE g.grantee_type = cp_grantee_type
580: AND (cp_grantee_key IS NULL
581: OR g.grantee_key = cp_grantee_key)
582: AND g.menu_id = cp_menu_id

Line 731: fnd_grants_pkg.revoke_grant

727: OR c_rec.end_date <= l_cp_end_date
728: )
729: THEN -- delete
730: dbg(' deleting completely overlapped grant....');
731: fnd_grants_pkg.revoke_grant
732: (p_api_version =>1.0 --IN NUMBER,
733: ,p_grant_guid =>c_rec.grant_guid --IN raw,
734: ,x_success =>x_success --OUT NOCOPY VARCHAR2,
735: ,x_errorcode =>x_errorcode --OUT NOCOPY NUMBER

Line 750: fnd_grants_pkg.update_grant

746: dbg(' updatting partially overlapped grant....');
747: l_start_date := l_cp_end_date + 1;
748: l_end_date := c_rec.end_date;
749: dbg(' new start_date :'||to_char(l_start_date));
750: fnd_grants_pkg.update_grant
751: (p_api_version => 1.0
752: ,p_grant_guid => c_rec.grant_guid
753: ,p_start_date => l_start_date
754: ,p_end_date => l_end_date

Line 780: fnd_grants_pkg.update_grant

776: l_start_date := LEAST(l_cp_start_date,c_rec.START_DATE);
777: l_end_date := GREATEST(l_cp_end_date,c_rec.end_date);
778: dbg(' new start date :'||TO_CHAR(l_start_date));
779: dbg(' new end date :'||TO_CHAR(l_end_date));
780: fnd_grants_pkg.update_grant
781: (p_api_version => 1.0
782: ,p_grant_guid => c_rec.grant_guid
783: ,p_start_date => l_start_date
784: ,p_end_date => l_end_date

Line 848: fnd_grants_pkg.update_grant

844: );
845: END IF;
846: --
847: dbg(' new end date :'||TO_CHAR(l_end_date));
848: fnd_grants_pkg.update_grant
849: (p_api_version => 1.0
850: ,p_grant_guid => c_rec.grant_guid
851: ,p_start_date => l_start_date
852: ,p_end_date => l_end_date

Line 867: fnd_grants_pkg.revoke_grant

863: ELSE
864: -- Else record has not come into usage as it's future
865: -- so delete
866: dbg(' deleting grant....');
867: fnd_grants_pkg.revoke_grant
868: (p_api_version =>1.0 --IN NUMBER,
869: ,p_grant_guid =>c_rec.grant_guid --IN raw,
870: ,x_success =>x_success --OUT NOCOPY VARCHAR2, /* Boolean */
871: ,x_errorcode =>x_errorcode --OUT NOCOPY NUMBER

Line 927: ,x_grant_guid OUT NOCOPY RAW /fnd_grants pk/

923: ,p_instance_pk5_value IN VARCHAR2 DEFAULT NULL
924: ,p_start_date IN DATE DEFAULT NULL
925: ,p_end_date IN DATE DEFAULT NULL
926: ,p_menu_name IN VARCHAR2
927: ,x_grant_guid OUT NOCOPY RAW /*fnd_grants pk*/
928: ,x_success OUT NOCOPY VARCHAR /* Boolean */
929: ,x_errorcode OUT NOCOPY VARCHAR2
930: )
931: IS

Line 933: -- fnd_grants PK used if need to do update instead of a new record

929: ,x_errorcode OUT NOCOPY VARCHAR2
930: )
931: IS
932: -- Local variables
933: -- fnd_grants PK used if need to do update instead of a new record
934: l_grant_guid fnd_grants.grant_guid%TYPE;
935: -- local parameters for fnd_grants API
936: l_start_date DATE;
937: l_end_date DATE;

Line 934: l_grant_guid fnd_grants.grant_guid%TYPE;

930: )
931: IS
932: -- Local variables
933: -- fnd_grants PK used if need to do update instead of a new record
934: l_grant_guid fnd_grants.grant_guid%TYPE;
935: -- local parameters for fnd_grants API
936: l_start_date DATE;
937: l_end_date DATE;
938: l_menu_id NUMBER; --menu_id for menu name

Line 935: -- local parameters for fnd_grants API

931: IS
932: -- Local variables
933: -- fnd_grants PK used if need to do update instead of a new record
934: l_grant_guid fnd_grants.grant_guid%TYPE;
935: -- local parameters for fnd_grants API
936: l_start_date DATE;
937: l_end_date DATE;
938: l_menu_id NUMBER; --menu_id for menu name
939: --

Line 1042: fnd_grants_pkg.grant_function

1038: -- menu
1039: -- object
1040: dbg(' no matching records found');
1041: dbg(' granting function.....');
1042: fnd_grants_pkg.grant_function
1043: (p_api_version =>1.0 --IN NUMBER,
1044: ,p_menu_name =>p_menu_name--IN VARCHAR2,
1045: ,p_object_name --IN VARCHAR2,
1046: =>g_tbl_delegate_type(p_delegate_type).object_name