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_OBJECTS

Line 41: ,object_id fnd_objects.object_id%TYPE --runtime TBD

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
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD

Line 42: ,object_name fnd_objects.obj_name%TYPE -- grantee object

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
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness

Line 43: ,object_database_object_name fnd_objects.database_object_name%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
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness
47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD

Line 44: ,object_pk1_column_name fnd_objects.pk1_column_name%TYPE --runtime TBD

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
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness
47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD
48: ,object_pk2_column_type fnd_objects.pk2_column_type%TYPE --runtime TBD

Line 45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD

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
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness
47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD
48: ,object_pk2_column_type fnd_objects.pk2_column_type%TYPE --runtime TBD
49: -- may want to derive and store the SQL to from:

Line 47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD

43: ,object_database_object_name fnd_objects.database_object_name%TYPE
44: ,object_pk1_column_name fnd_objects.pk1_column_name%TYPE --runtime TBD
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness
47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD
48: ,object_pk2_column_type fnd_objects.pk2_column_type%TYPE --runtime TBD
49: -- may want to derive and store the SQL to from:
50: -- object name
51: -- object_pkX_column_name

Line 48: ,object_pk2_column_type fnd_objects.pk2_column_type%TYPE --runtime TBD

44: ,object_pk1_column_name fnd_objects.pk1_column_name%TYPE --runtime TBD
45: ,object_pk1_column_type fnd_objects.pk1_column_type%TYPE --runtime TBD
46: --unlikely to need but put in for completeness
47: ,object_pk2_column_name fnd_objects.pk2_column_name%TYPE --runtime TBD
48: ,object_pk2_column_type fnd_objects.pk2_column_type%TYPE --runtime TBD
49: -- may want to derive and store the SQL to from:
50: -- object name
51: -- object_pkX_column_name
52: -- object_pkX_column_type

Line 102: l_object_id fnd_objects.object_id%TYPE;

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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;

Line 103: l_object_database_object_name fnd_objects.database_object_name%TYPE;

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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;

Line 104: l_object_pk1_column_name fnd_objects.pk1_column_name%TYPE;

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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --

Line 105: l_object_pk1_column_type fnd_objects.pk1_column_type%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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --
109: CURSOR csr_fnd_objects

Line 106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;

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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --
109: CURSOR csr_fnd_objects
110: (cp_obj_name fnd_objects.obj_name%TYPE

Line 107: l_object_pk2_column_type fnd_objects.pk2_column_type%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;
105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --
109: CURSOR csr_fnd_objects
110: (cp_obj_name fnd_objects.obj_name%TYPE
111: )

Line 109: CURSOR csr_fnd_objects

105: l_object_pk1_column_type fnd_objects.pk1_column_type%TYPE;
106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --
109: CURSOR csr_fnd_objects
110: (cp_obj_name fnd_objects.obj_name%TYPE
111: )
112: IS
113: SELECT o.object_id

Line 110: (cp_obj_name fnd_objects.obj_name%TYPE

106: l_object_pk2_column_name fnd_objects.pk2_column_name%TYPE;
107: l_object_pk2_column_type fnd_objects.pk2_column_type%TYPE;
108: --
109: CURSOR csr_fnd_objects
110: (cp_obj_name fnd_objects.obj_name%TYPE
111: )
112: IS
113: SELECT o.object_id
114: , o.database_object_name

Line 119: FROM fnd_objects o

115: , o.pk1_column_name
116: , o.pk1_column_type
117: , o.pk2_column_name
118: , o.pk2_column_type
119: FROM fnd_objects o
120: WHERE o.obj_name = cp_obj_name
121: ;
122: --
123: BEGIN

Line 136: IF csr_fnd_objects%ISOPEN THEN

132: l_delegate_type := 'HRI_PER_USRDR_H';
133: -- query object information
134: BEGIN
135: -- Ensure cursor is closed prior to opening
136: IF csr_fnd_objects%ISOPEN THEN
137: CLOSE csr_fnd_objects;
138: END IF;
139: --
140: OPEN csr_fnd_objects(g_tbl_delegate_type('HRI_PER_USRDR_H').object_name);

Line 137: CLOSE csr_fnd_objects;

133: -- query object information
134: BEGIN
135: -- Ensure cursor is closed prior to opening
136: IF csr_fnd_objects%ISOPEN THEN
137: CLOSE csr_fnd_objects;
138: END IF;
139: --
140: OPEN csr_fnd_objects(g_tbl_delegate_type('HRI_PER_USRDR_H').object_name);
141: FETCH csr_fnd_objects INTO

Line 140: OPEN csr_fnd_objects(g_tbl_delegate_type('HRI_PER_USRDR_H').object_name);

136: IF csr_fnd_objects%ISOPEN THEN
137: CLOSE csr_fnd_objects;
138: END IF;
139: --
140: OPEN csr_fnd_objects(g_tbl_delegate_type('HRI_PER_USRDR_H').object_name);
141: FETCH csr_fnd_objects INTO
142: l_object_id
143: ,l_object_database_object_name
144: ,l_object_pk1_column_name

Line 141: FETCH csr_fnd_objects INTO

137: CLOSE csr_fnd_objects;
138: END IF;
139: --
140: OPEN csr_fnd_objects(g_tbl_delegate_type('HRI_PER_USRDR_H').object_name);
141: FETCH csr_fnd_objects INTO
142: l_object_id
143: ,l_object_database_object_name
144: ,l_object_pk1_column_name
145: ,l_object_pk1_column_type

Line 149: IF (csr_fnd_objects%FOUND) THEN

145: ,l_object_pk1_column_type
146: ,l_object_pk2_column_name
147: ,l_object_pk2_column_type
148: ;
149: IF (csr_fnd_objects%FOUND) THEN
150: g_tbl_delegate_type(l_delegate_type).object_id
151: :=l_object_id;
152: g_tbl_delegate_type(l_delegate_type).object_pk1_column_name
153: :=l_object_pk1_column_name;

Line 172: CLOSE csr_fnd_objects;

168: ||g_tbl_delegate_type(l_delegate_type).object_pk1_column_type);
169: ELSE
170: RAISE NO_DATA_FOUND;
171: END IF;
172: CLOSE csr_fnd_objects;
173: --
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF csr_fnd_objects%ISOPEN THEN

Line 176: IF csr_fnd_objects%ISOPEN THEN

172: CLOSE csr_fnd_objects;
173: --
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF csr_fnd_objects%ISOPEN THEN
177: CLOSE csr_fnd_objects;
178: END IF;
179: RAISE g_e_INVALID_FND_OBJECT;
180: END;

Line 177: CLOSE csr_fnd_objects;

173: --
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF csr_fnd_objects%ISOPEN THEN
177: CLOSE csr_fnd_objects;
178: END IF;
179: RAISE g_e_INVALID_FND_OBJECT;
180: END;
181: --