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

Line 305: l_uom_type fnd_lookups.lookup_type%TYPE;

301: actid IN NUMBER,
302: funcmode IN VARCHAR2,
303: result IN OUT NOCOPY VARCHAR2
304: ) IS
305: l_uom_type fnd_lookups.lookup_type%TYPE;
306: l_uom_code fnd_lookups.lookup_code%TYPE;
307: l_timer_units NUMBER;
308: l_timer_interval NUMBER;
309: l_meaning fnd_lookups.meaning%TYPE;

Line 306: l_uom_code fnd_lookups.lookup_code%TYPE;

302: funcmode IN VARCHAR2,
303: result IN OUT NOCOPY VARCHAR2
304: ) IS
305: l_uom_type fnd_lookups.lookup_type%TYPE;
306: l_uom_code fnd_lookups.lookup_code%TYPE;
307: l_timer_units NUMBER;
308: l_timer_interval NUMBER;
309: l_meaning fnd_lookups.meaning%TYPE;
310: l_conversion NUMBER;

Line 309: l_meaning fnd_lookups.meaning%TYPE;

305: l_uom_type fnd_lookups.lookup_type%TYPE;
306: l_uom_code fnd_lookups.lookup_code%TYPE;
307: l_timer_units NUMBER;
308: l_timer_interval NUMBER;
309: l_meaning fnd_lookups.meaning%TYPE;
310: l_conversion NUMBER;
311: l_found BOOLEAN;
312: l_now DATE := SYSDATE;
313: --

Line 314: CURSOR c_lookups(b_uom_type fnd_lookups.lookup_type%TYPE,

310: l_conversion NUMBER;
311: l_found BOOLEAN;
312: l_now DATE := SYSDATE;
313: --
314: CURSOR c_lookups(b_uom_type fnd_lookups.lookup_type%TYPE,
315: b_uom_code fnd_lookups.lookup_code%TYPE,
316: b_now DATE) IS
317: SELECT meaning
318: FROM fnd_lookups

Line 315: b_uom_code fnd_lookups.lookup_code%TYPE,

311: l_found BOOLEAN;
312: l_now DATE := SYSDATE;
313: --
314: CURSOR c_lookups(b_uom_type fnd_lookups.lookup_type%TYPE,
315: b_uom_code fnd_lookups.lookup_code%TYPE,
316: b_now DATE) IS
317: SELECT meaning
318: FROM fnd_lookups
319: WHERE lookup_type = b_uom_type

Line 318: FROM fnd_lookups

314: CURSOR c_lookups(b_uom_type fnd_lookups.lookup_type%TYPE,
315: b_uom_code fnd_lookups.lookup_code%TYPE,
316: b_now DATE) IS
317: SELECT meaning
318: FROM fnd_lookups
319: WHERE lookup_type = b_uom_type
320: AND lookup_code = b_uom_code
321: AND enabled_flag = 'Y'
322: AND start_date_active <= b_now

Line 780: l_command_type fnd_lookups.lookup_type%TYPE;

776: actid IN NUMBER,
777: funcmode IN VARCHAR2,
778: result IN OUT NOCOPY VARCHAR2
779: ) IS
780: l_command_type fnd_lookups.lookup_type%TYPE;
781: l_command_code fnd_lookups.lookup_code%TYPE;
782: l_meaning fnd_lookups.meaning%TYPE;
783: l_found BOOLEAN;
784: l_now DATE := SYSDATE;

Line 781: l_command_code fnd_lookups.lookup_code%TYPE;

777: funcmode IN VARCHAR2,
778: result IN OUT NOCOPY VARCHAR2
779: ) IS
780: l_command_type fnd_lookups.lookup_type%TYPE;
781: l_command_code fnd_lookups.lookup_code%TYPE;
782: l_meaning fnd_lookups.meaning%TYPE;
783: l_found BOOLEAN;
784: l_now DATE := SYSDATE;
785: --

Line 782: l_meaning fnd_lookups.meaning%TYPE;

778: result IN OUT NOCOPY VARCHAR2
779: ) IS
780: l_command_type fnd_lookups.lookup_type%TYPE;
781: l_command_code fnd_lookups.lookup_code%TYPE;
782: l_meaning fnd_lookups.meaning%TYPE;
783: l_found BOOLEAN;
784: l_now DATE := SYSDATE;
785: --
786: CURSOR c_command IS

Line 791: CURSOR c_lookups(b_command_type fnd_lookups.lookup_type%TYPE,

787: SELECT brm_wf_command_type, brm_wf_command_code
788: FROM jtf_brm_parameters
789: WHERE workflow_process_id = itemkey;
790: --
791: CURSOR c_lookups(b_command_type fnd_lookups.lookup_type%TYPE,
792: b_command_code fnd_lookups.lookup_code%TYPE,
793: b_now DATE) IS
794: SELECT meaning
795: FROM fnd_lookups

Line 792: b_command_code fnd_lookups.lookup_code%TYPE,

788: FROM jtf_brm_parameters
789: WHERE workflow_process_id = itemkey;
790: --
791: CURSOR c_lookups(b_command_type fnd_lookups.lookup_type%TYPE,
792: b_command_code fnd_lookups.lookup_code%TYPE,
793: b_now DATE) IS
794: SELECT meaning
795: FROM fnd_lookups
796: WHERE lookup_type = b_command_type

Line 795: FROM fnd_lookups

791: CURSOR c_lookups(b_command_type fnd_lookups.lookup_type%TYPE,
792: b_command_code fnd_lookups.lookup_code%TYPE,
793: b_now DATE) IS
794: SELECT meaning
795: FROM fnd_lookups
796: WHERE lookup_type = b_command_type
797: AND lookup_code = b_command_code
798: AND enabled_flag = 'Y'
799: AND start_date_active <= b_now