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.AZW_REPORT dependencies on FND_LOOKUPS

Line 5: g_mode_label fnd_lookups.meaning%TYPE; -- Wizard Mode label

1: PACKAGE BODY AZW_REPORT AS
2: /* $Header: AZWREPTB.pls 115.64 2000/03/08 11:22:40 pkm ship $ */
3: /* Global Variables **********************************************************/
4: g_current_mode VARCHAR2(255); -- Wizard Mode
5: g_mode_label fnd_lookups.meaning%TYPE; -- Wizard Mode label
6: g_blank VARCHAR2(8) := ' '; -- for padding in the hierarchy
7: g_indent INTEGER := 3; -- for indentation in hierarchy
8: g_web_agent VARCHAR2(255) := ''; -- URL for the host server
9: /* labels */

Line 51: g_atmost fnd_lookups.meaning%TYPE := NULL; -- At most

47: g_end VARCHAR2(2000) := NULL; -- End Date
48: g_days VARCHAR2(2000) := NULL; -- Days
49: g_dateformat_msg VARCHAR2(2000) := NULL; -- used by user_param
50: g_timeformat VARCHAR2(2000) := NULL; -- HH:MM AM/PM
51: g_atmost fnd_lookups.meaning%TYPE := NULL; -- At most
52: g_atleast fnd_lookups.meaning%TYPE := NULL; -- At least
53: g_description VARCHAR2(2000) := NULL; -- Process Description
54: g_comments VARCHAR2(2000) := NULL; -- Process Comments
55: /* messages */

Line 52: g_atleast fnd_lookups.meaning%TYPE := NULL; -- At least

48: g_days VARCHAR2(2000) := NULL; -- Days
49: g_dateformat_msg VARCHAR2(2000) := NULL; -- used by user_param
50: g_timeformat VARCHAR2(2000) := NULL; -- HH:MM AM/PM
51: g_atmost fnd_lookups.meaning%TYPE := NULL; -- At most
52: g_atleast fnd_lookups.meaning%TYPE := NULL; -- At least
53: g_description VARCHAR2(2000) := NULL; -- Process Description
54: g_comments VARCHAR2(2000) := NULL; -- Process Comments
55: /* messages */
56: g_welcome_msg VARCHAR2(2000) := NULL; -- welcome message in start_page

Line 400: v_meaning fnd_lookups.meaning%TYPE := p_code;

396: * Given a lookup type and a lookup code, returns its translated meaning.
397: *-----------------------------------------------------------------------*/
398: FUNCTION get_translation(p_type IN VARCHAR2, p_code IN VARCHAR2)
399: RETURN VARCHAR2 IS
400: v_meaning fnd_lookups.meaning%TYPE := p_code;
401:
402: BEGIN
403: SELECT meaning
404: INTO v_meaning

Line 405: FROM fnd_lookups

401:
402: BEGIN
403: SELECT meaning
404: INTO v_meaning
405: FROM fnd_lookups
406: WHERE lookup_type = p_type
407: AND lookup_code = p_code;
408:
409: RETURN v_meaning;

Line 621: FROM fnd_lookups

617: SELECT lookup_code,
618: meaning,
619: DECODE(lookup_code, 'NONE', 1, 'BG', 2, 'SOB', 3, 'OU', 4, 5)
620: display_order
621: FROM fnd_lookups
622: WHERE lookup_type = 'AZ_CONTEXT_TYPE'
623: ORDER BY display_order;
624:
625: BEGIN

Line 945: v_status fnd_lookups.meaning%TYPE;

941: AND agv.hierarchy_parent_id IS NULL;
942:
943: v_exist_cnt NUMBER := -1;
944: v_group group_parent_cursor%ROWTYPE;
945: v_status fnd_lookups.meaning%TYPE;
946: v_locator NUMBER;
947: BEGIN
948: v_locator := 1;
949: OPEN group_parent_cursor;

Line 1089: fnd_lookups fnd

1085: wav.description
1086: FROM az_product_flows apf,
1087: az_groups ag,
1088: wf_activities_vl wav,
1089: fnd_lookups fnd
1090: WHERE apf.application_id = p_application_id
1091: AND apf.process_type = 'IMP'
1092: AND wav.end_date IS NULL
1093: AND wav.item_type like 'AZ%'

Line 1217: v_status fnd_lookups.meaning%TYPE;

1213: SELECT DISTINCT apv.parent_id
1214: FROM az_processes apv
1215: WHERE apv.process_type = g_current_mode;
1216:
1217: v_status fnd_lookups.meaning%TYPE;
1218: v_locator PLS_INTEGER := 0;
1219: BEGIN
1220: -- dbms_output.put_line('get_status_groups: '||p_status);
1221: IF (p_status IS NULL) THEN /* get parents for all processes */

Line 1314: v_status fnd_lookups.meaning%TYPE;

1310: WHERE apv.process_type = g_current_mode
1311: AND ag.process_type = g_current_mode
1312: AND apv.parent_id = ag.group_id;
1313:
1314: v_status fnd_lookups.meaning%TYPE;
1315: v_locator PLS_INTEGER := 0;
1316: BEGIN
1317: -- dbms_output.put_line('get_status_processes:'||p_status);
1318:

Line 1449: v_status fnd_lookups.meaning%TYPE;

1445: AND atv.root_activity = apv.process_name
1446: AND apv.process_type = g_current_mode
1447: AND atv.context_id = apv.context_id;
1448:
1449: v_status fnd_lookups.meaning%TYPE;
1450: v_locator PLS_INTEGER := 0;
1451: BEGIN
1452: -- dbms_output.put_line('get_status_tasks: '||p_status);
1453:

Line 1591: FROM fnd_lookups

1587:
1588: v_locator := 3;
1589: SELECT meaning
1590: INTO g_mode_label
1591: FROM fnd_lookups
1592: WHERE lookup_type = 'AZ_PROCESS_TYPE'
1593: AND lookup_code = g_current_mode;
1594:
1595: g_no_prod_inst := FND_MESSAGE.get_string('AZ', 'AZW_RPT_NO_PROD_INSTALLED');

Line 1768: v_status fnd_lookups.meaning%TYPE;

1764: AND atv.assigned_user = p_user
1765: AND atv.duration >= p_duration
1766: AND apv.process_type = g_current_mode);
1767:
1768: v_status fnd_lookups.meaning%TYPE;
1769: v_locator PLS_INTEGER := 0;
1770:
1771: BEGIN
1772: IF (p_status IS NOT NULL) THEN /* with one status, A or C */

Line 1990: v_status fnd_lookups.meaning%TYPE;

1986: AND atv.assigned_user = p_user
1987: AND atv.duration <= p_duration
1988: AND apv.process_type = g_current_mode);
1989:
1990: v_status fnd_lookups.meaning%TYPE;
1991: v_locator PLS_INTEGER := 0;
1992: BEGIN
1993:
1994: IF (p_status IS NOT NULL) THEN /* with one status, A or C */

Line 2228: v_status fnd_lookups.meaning%TYPE;

2224: OR (atv.begin_date <= p_startdate AND
2225: (atv.end_date >= p_enddate OR atv.end_date IS NULL)))
2226: AND apv.process_type = g_current_mode);
2227:
2228: v_status fnd_lookups.meaning%TYPE;
2229: v_locator PLS_INTEGER := 0;
2230: BEGIN
2231: /*
2232: dbms_output.enable(1000000);

Line 4722: FROM fnd_lookups

4718: PROCEDURE status_param_page IS
4719:
4720: CURSOR statuses_cursor IS
4721: SELECT lookup_code, meaning
4722: FROM fnd_lookups
4723: WHERE lookup_type = 'AZ_PROCESS_STATUS'
4724: ORDER BY lookup_code;
4725:
4726: BEGIN

Line 5022: FROM fnd_lookups

5018: ORDER BY 1;
5019:
5020: CURSOR statuses_cursor IS
5021: SELECT lookup_code, meaning
5022: FROM fnd_lookups
5023: WHERE lookup_type = 'AZ_PROCESS_STATUS'
5024: AND lookup_code IN ('A', 'C')
5025: ORDER BY lookup_code;
5026:

Line 5029: FROM fnd_lookups

5025: ORDER BY lookup_code;
5026:
5027: CURSOR duration_ranges_cursor IS
5028: SELECT lookup_code, meaning
5029: FROM fnd_lookups
5030: WHERE lookup_type = 'AZ_REPORT_DURATION_RANGE'
5031: ORDER BY lookup_code;
5032: v_locator PLS_INTEGER := 0;
5033: