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

Line 25: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

21: SOURCEWAREHOUSECP := ' and xf.from_warehouse between ''' || P_FROM_SOURCE_WAREHOUSE || '''
22: and ''' || P_TO_SOURCE_WAREHOUSE || '''';
23: ELSIF P_FROM_SOURCE_WAREHOUSE IS NULL AND P_TO_SOURCE_WAREHOUSE IS NULL THEN
24: SOURCEWAREHOUSECP := ' ';
25: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
26: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
27: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NULL THEN
28: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || P_FROM_SOURCE_WAREHOUSE || '''';
29: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

Line 26: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

22: and ''' || P_TO_SOURCE_WAREHOUSE || '''';
23: ELSIF P_FROM_SOURCE_WAREHOUSE IS NULL AND P_TO_SOURCE_WAREHOUSE IS NULL THEN
24: SOURCEWAREHOUSECP := ' ';
25: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
26: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
27: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NULL THEN
28: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || P_FROM_SOURCE_WAREHOUSE || '''';
29: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NOT NULL THEN

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

25: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
26: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
27: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NULL THEN
28: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || P_FROM_SOURCE_WAREHOUSE || '''';
29: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NOT NULL THEN
31: SOURCEWAREHOUSECP := ' and xf.from_warehouse <= ''' || P_TO_SOURCE_WAREHOUSE || '''';
32: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
33: END IF;

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

28: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || P_FROM_SOURCE_WAREHOUSE || '''';
29: CP_TO_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF P_FROM_SOURCE_WAREHOUSE IS NOT NULL AND P_TO_SOURCE_WAREHOUSE IS NOT NULL THEN
31: SOURCEWAREHOUSECP := ' and xf.from_warehouse <= ''' || P_TO_SOURCE_WAREHOUSE || '''';
32: CP_FROM_SOURCE_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
33: END IF;
34: RETURN NULL;
35: END SOURCEWAREHOUSECFFORMULA;
36:

Line 44: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

40: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse between ''' || P_FROM_DESTINATION_WAREHOUSE || '''
41: and ''' || P_TO_DESTINATION_WAREHOUSE || '''';
42: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NULL AND P_TO_DESTINATION_WAREHOUSE IS NULL THEN
43: DESTINATIONWAREHOUSECP := ' ';
44: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
45: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
46: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NULL THEN
47: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || P_FROM_DESTINATION_WAREHOUSE || '''';
48: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

Line 45: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

41: and ''' || P_TO_DESTINATION_WAREHOUSE || '''';
42: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NULL AND P_TO_DESTINATION_WAREHOUSE IS NULL THEN
43: DESTINATIONWAREHOUSECP := ' ';
44: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
45: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
46: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NULL THEN
47: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || P_FROM_DESTINATION_WAREHOUSE || '''';
48: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN

Line 48: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

44: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
45: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
46: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NULL THEN
47: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || P_FROM_DESTINATION_WAREHOUSE || '''';
48: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN
50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse <= ''' || P_TO_DESTINATION_WAREHOUSE || '''';
51: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
52: END IF;

Line 51: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

47: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || P_FROM_DESTINATION_WAREHOUSE || '''';
48: CP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF P_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND P_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN
50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse <= ''' || P_TO_DESTINATION_WAREHOUSE || '''';
51: CP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
52: END IF;
53: RETURN NULL;
54: END DESTINATIONWAREHOUSECFFORMULA;
55:

Line 63: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

59: TRANSFERSTATUSCP := ' and xf.transfer_status between ''' || P_FROM_TRANSFER_STATUS || '''
60: and ''' || P_TO_TRANSFER_STATUS || '''';
61: ELSIF P_FROM_TRANSFER_STATUS IS NULL AND P_TO_TRANSFER_STATUS IS NULL THEN
62: TRANSFERSTATUSCP := ' ';
63: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
64: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
65: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NULL THEN
66: TRANSFERSTATUSCP := ' and xf.transfer_status >= ''' || P_FROM_TRANSFER_STATUS || '''';
67: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

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

60: and ''' || P_TO_TRANSFER_STATUS || '''';
61: ELSIF P_FROM_TRANSFER_STATUS IS NULL AND P_TO_TRANSFER_STATUS IS NULL THEN
62: TRANSFERSTATUSCP := ' ';
63: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
64: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
65: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NULL THEN
66: TRANSFERSTATUSCP := ' and xf.transfer_status >= ''' || P_FROM_TRANSFER_STATUS || '''';
67: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NOT NULL THEN

Line 67: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

63: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
64: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
65: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NULL THEN
66: TRANSFERSTATUSCP := ' and xf.transfer_status >= ''' || P_FROM_TRANSFER_STATUS || '''';
67: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NOT NULL THEN
69: TRANSFERSTATUSCP := ' and xf.transfer_status <= ''' || P_TO_TRANSFER_STATUS || '''';
70: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
71: END IF;

Line 70: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

66: TRANSFERSTATUSCP := ' and xf.transfer_status >= ''' || P_FROM_TRANSFER_STATUS || '''';
67: CP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF P_FROM_TRANSFER_STATUS IS NOT NULL AND P_TO_TRANSFER_STATUS IS NOT NULL THEN
69: TRANSFERSTATUSCP := ' and xf.transfer_status <= ''' || P_TO_TRANSFER_STATUS || '''';
70: CP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
71: END IF;
72: RETURN NULL;
73: END TREANSFERSTATUSCFFORMULA;
74:

Line 124: V_USER_ID := FND_PROFILE.VALUE('USER_ID');

120: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
121: BEGIN
122: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
123: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
124: V_USER_ID := FND_PROFILE.VALUE('USER_ID');
125: SETUP_REPORT;
126: lV_REPORT_TITLE:=substr(V_REPORT_TITLE,1,instr(V_REPORT_TITLE,' (XML)'));
127: RETURN (TRUE);
128: END BEFOREREPORT;

Line 137: V_SET_OF_BOOKS_ID := NVL(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')

133: V_SET_OF_BOOKS_ID NUMBER;
134: BEGIN
135: V_REPORT_NUMBER := 'CMXFER02';
136: V_SUBTITLE := '';
137: V_SET_OF_BOOKS_ID := NVL(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')
138: ,V_DEF_SET_OF_BOOKS_ID);
139: SELECT
140: MIN(NAME)
141: INTO V_SET_OF_BOOKS_NAME