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.AS_ISSUE_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 90: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

86:
87: -- Procedure to validate the fund contact_role_code
88: --
89: -- Validation:
90: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
91: --
92: -- NOTES:
93: --
94: PROCEDURE Validate_fd_contact_role_code (

Line 104: FROM FND_LOOKUP_VALUES

100:
101: CURSOR C_contact_role_code_exists (c_contact_role_code VARCHAR2,
102: c_lookup_type VARCHAR2) IS
103: SELECT 'X'
104: FROM FND_LOOKUP_VALUES
105: WHERE LOOKUP_TYPE = c_lookup_type
106: AND LOOKUP_CODE = c_contact_role_code;
107:
108: l_val VARCHAR2(1);

Line 153: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

149:
150: -- Procedure to validate the fund_strategy
151: --
152: -- Validation:
153: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
154: --
155: -- NOTES:
156: --
157: PROCEDURE Validate_fund_strategy (

Line 167: FROM FND_LOOKUP_VALUES

163:
164: CURSOR C_strategy_exists (c_strategy VARCHAR2,
165: c_lookup_type VARCHAR2) IS
166: SELECT 'X'
167: FROM FND_LOOKUP_VALUES
168: WHERE LOOKUP_TYPE = c_lookup_type
169: AND LOOKUP_CODE = c_strategy;
170:
171: l_val VARCHAR2(1);

Line 215: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

211:
212: -- Procedure to validate the scheme
213: --
214: -- Validation:
215: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
216: --
217: -- NOTES:
218: --
219: PROCEDURE Validate_scheme (

Line 230: FROM FND_LOOKUP_VALUES

226: CURSOR C_scheme_exists (
227: c_scheme VARCHAR2,
228: c_lookup_type VARCHAR2) IS
229: SELECT 'X'
230: FROM FND_LOOKUP_VALUES
231: WHERE LOOKUP_TYPE = c_lookup_type
232: AND LOOKUP_CODE = c_scheme;
233:
234: l_val VARCHAR2(1);

Line 277: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

273:
274: -- Procedure to validate the issue_type
275: --
276: -- Validation:
277: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
278: --
279: -- NOTES:
280: --
281: PROCEDURE Validate_issue_type (

Line 292: FROM FND_LOOKUP_VALUES

288: CURSOR C_issue_type_exists (
289: c_issue_type VARCHAR2,
290: c_lookup_type VARCHAR2) IS
291: SELECT 'X'
292: FROM FND_LOOKUP_VALUES
293: WHERE LOOKUP_TYPE = c_lookup_type
294: AND LOOKUP_CODE = c_issue_type;
295:
296: l_val VARCHAR2(1);

Line 354: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

350:
351: -- Procedure to validate the issue_group_type_code
352: --
353: -- Validation:
354: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
355: --
356: -- NOTES:
357: --
358: PROCEDURE Validate_issue_group_type_code (

Line 428: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.

424:
425: -- Procedure to validate the issue_relationship_type
426: --
427: -- Validation:
428: -- Check if the passed in code is in the FND_LOOKUP_VALUES table.
429: --
430: -- NOTES:
431: --
432: PROCEDURE Validate_is_relationship_type (

Line 443: FROM FND_LOOKUP_VALUES

439: CURSOR C_is_relationship_type_exists (
440: c_issue_relationship_type VARCHAR2,
441: c_lookup_type VARCHAR2) IS
442: SELECT 'X'
443: FROM FND_LOOKUP_VALUES
444: WHERE LOOKUP_TYPE = c_lookup_type
445: AND LOOKUP_CODE = c_issue_relationship_type;
446:
447: l_val VARCHAR2(1);