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.GMF_GLR20USR_XMLP_PKG dependencies on FND_PROFILE

Line 10: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');

6: SOURCECP := ' and e.trans_source_code >= ''' || LP_FROM_SOURCE || '''
7: and e.trans_source_code <= ''' || LP_TO_SOURCE || '''';
8: ELSIF LP_FROM_SOURCE IS NULL AND LP_TO_SOURCE IS NULL THEN
9: SOURCECP :='AND 1=1';
10: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');
11: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
12: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NULL THEN
13: SOURCECP := ' and e.trans_source_code >= ''' || LP_FROM_SOURCE || '''';
14: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');

Line 11: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');

7: and e.trans_source_code <= ''' || LP_TO_SOURCE || '''';
8: ELSIF LP_FROM_SOURCE IS NULL AND LP_TO_SOURCE IS NULL THEN
9: SOURCECP :='AND 1=1';
10: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');
11: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
12: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NULL THEN
13: SOURCECP := ' and e.trans_source_code >= ''' || LP_FROM_SOURCE || '''';
14: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
15: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NOT NULL THEN

Line 14: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');

10: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');
11: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
12: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NULL THEN
13: SOURCECP := ' and e.trans_source_code >= ''' || LP_FROM_SOURCE || '''';
14: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
15: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NOT NULL THEN
16: SOURCECP := ' and e.trans_source_code <= ''' || LP_TO_SOURCE || '''';
17: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');
18: END IF;

Line 17: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');

13: SOURCECP := ' and e.trans_source_code >= ''' || LP_FROM_SOURCE || '''';
14: LP_TO_SOURCE := FND_PROFILE.VALUE('SY$ALL');
15: ELSIF LP_FROM_SOURCE IS NOT NULL AND LP_TO_SOURCE IS NOT NULL THEN
16: SOURCECP := ' and e.trans_source_code <= ''' || LP_TO_SOURCE || '''';
17: LP_FROM_SOURCE := FND_PROFILE.VALUE('SY$ALL');
18: END IF;
19: RETURN NULL;
20: END SOURCECFFORMULA;
21: FUNCTION EVENTCFFORMULA RETURN VARCHAR2 IS

Line 28: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');

24: EVENTCP := ' and b.event_code >= ''' || LP_FROM_EVENT || '''
25: and b.event_code <= ''' || LP_TO_EVENT || '''';
26: ELSIF LP_FROM_EVENT IS NULL AND LP_TO_EVENT IS NULL THEN
27: EVENTCP := 'AND 1=1';
28: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NULL THEN
31: EVENTCP := ' and b.event_code >= ''' || LP_FROM_EVENT || '''';
32: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');

Line 29: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');

25: and b.event_code <= ''' || LP_TO_EVENT || '''';
26: ELSIF LP_FROM_EVENT IS NULL AND LP_TO_EVENT IS NULL THEN
27: EVENTCP := 'AND 1=1';
28: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NULL THEN
31: EVENTCP := ' and b.event_code >= ''' || LP_FROM_EVENT || '''';
32: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NOT NULL THEN

Line 32: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');

28: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NULL THEN
31: EVENTCP := ' and b.event_code >= ''' || LP_FROM_EVENT || '''';
32: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NOT NULL THEN
34: EVENTCP := ' and b.event_code <= ''' || LP_TO_EVENT || '''';
35: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');
36: END IF;

Line 35: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');

31: EVENTCP := ' and b.event_code >= ''' || LP_FROM_EVENT || '''';
32: LP_TO_EVENT := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_EVENT IS NOT NULL AND LP_TO_EVENT IS NOT NULL THEN
34: EVENTCP := ' and b.event_code <= ''' || LP_TO_EVENT || '''';
35: LP_FROM_EVENT := FND_PROFILE.VALUE('SY$ALL');
36: END IF;
37: RETURN NULL;
38: END EVENTCFFORMULA;
39: FUNCTION SUBEVENTCFFORMULA RETURN VARCHAR2 IS

Line 46: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');

42: SUBEVENTCP := ' and c.sub_event_code >= ''' || LP_FROM_SUB_EVENT || '''
43: and c.sub_event_code <= ''' || LP_TO_SUB_EVENT || '''';
44: ELSIF LP_FROM_SUB_EVENT IS NULL AND LP_TO_SUB_EVENT IS NULL THEN
45: SUBEVENTCP := 'AND 1=1';
46: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
47: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
48: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NULL THEN
49: SUBEVENTCP := ' and c.sub_event_code >= ''' || LP_FROM_SUB_EVENT || '''';
50: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');

Line 47: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');

43: and c.sub_event_code <= ''' || LP_TO_SUB_EVENT || '''';
44: ELSIF LP_FROM_SUB_EVENT IS NULL AND LP_TO_SUB_EVENT IS NULL THEN
45: SUBEVENTCP := 'AND 1=1';
46: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
47: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
48: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NULL THEN
49: SUBEVENTCP := ' and c.sub_event_code >= ''' || LP_FROM_SUB_EVENT || '''';
50: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
51: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NOT NULL THEN

Line 50: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');

46: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
47: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
48: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NULL THEN
49: SUBEVENTCP := ' and c.sub_event_code >= ''' || LP_FROM_SUB_EVENT || '''';
50: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
51: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NOT NULL THEN
52: SUBEVENTCP := ' and c.sub_event_code <= ''' || LP_TO_SUB_EVENT || '''';
53: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
54: END IF;

Line 53: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');

49: SUBEVENTCP := ' and c.sub_event_code >= ''' || LP_FROM_SUB_EVENT || '''';
50: LP_TO_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
51: ELSIF LP_FROM_SUB_EVENT IS NOT NULL AND LP_TO_SUB_EVENT IS NOT NULL THEN
52: SUBEVENTCP := ' and c.sub_event_code <= ''' || LP_TO_SUB_EVENT || '''';
53: LP_FROM_SUB_EVENT := FND_PROFILE.VALUE('SY$ALL');
54: END IF;
55: RETURN NULL;
56: END SUBEVENTCFFORMULA;
57: FUNCTION ACCTTTLCFFORMULA RETURN VARCHAR2 IS

Line 64: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');

60: ACCTTTLCP := ' and d.acct_ttl_code >= ''' || LP_FROM_ACCT_TTL || '''
61: and d.acct_ttl_code <= ''' || LP_TO_ACCT_TTL || '''';
62: ELSIF LP_FROM_ACCT_TTL IS NULL AND LP_TO_ACCT_TTL IS NULL THEN
63: ACCTTTLCP := 'AND 1=1';
64: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
65: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
66: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NULL THEN
67: ACCTTTLCP := ' and d.acct_ttl_code >= ''' || LP_FROM_ACCT_TTL || '''';
68: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');

Line 65: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');

61: and d.acct_ttl_code <= ''' || LP_TO_ACCT_TTL || '''';
62: ELSIF LP_FROM_ACCT_TTL IS NULL AND LP_TO_ACCT_TTL IS NULL THEN
63: ACCTTTLCP := 'AND 1=1';
64: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
65: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
66: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NULL THEN
67: ACCTTTLCP := ' and d.acct_ttl_code >= ''' || LP_FROM_ACCT_TTL || '''';
68: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
69: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NOT NULL THEN

Line 68: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');

64: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
65: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
66: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NULL THEN
67: ACCTTTLCP := ' and d.acct_ttl_code >= ''' || LP_FROM_ACCT_TTL || '''';
68: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
69: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NOT NULL THEN
70: ACCTTTLCP := ' and d.acct_ttl_code <= ''' || LP_TO_ACCT_TTL || '''';
71: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
72: END IF;

Line 71: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');

67: ACCTTTLCP := ' and d.acct_ttl_code >= ''' || LP_FROM_ACCT_TTL || '''';
68: LP_TO_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
69: ELSIF LP_FROM_ACCT_TTL IS NOT NULL AND LP_TO_ACCT_TTL IS NOT NULL THEN
70: ACCTTTLCP := ' and d.acct_ttl_code <= ''' || LP_TO_ACCT_TTL || '''';
71: LP_FROM_ACCT_TTL := FND_PROFILE.VALUE('SY$ALL');
72: END IF;
73: RETURN NULL;
74: END ACCTTTLCFFORMULA;
75: PROCEDURE GMF_GLR20USR_XMLP_PKG_HDR IS