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

Line 28: from FND_PROFILE_OPTIONS

24: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE.INSERT_PROFS2_AT';
25:
26: CURSOR qp_profs_cur is
27: select PROFILE_OPTION_NAME
28: from FND_PROFILE_OPTIONS
29: where (APPLICATION_ID = 661 or
30: PROFILE_OPTION_NAME = 'ORG_ID') and
31: START_DATE_ACTIVE <=sysdate and
32: nvl(END_DATE_ACTIVE,sysdate) >= sysdate and

Line 55: G_PROFILE_VALUES(i) := FND_PROFILE.value(G_PROFILE_NAMES(i));

51: G_PROFILE_NAMES;
52:
53: FOR i in G_PROFILE_NAMES.FIRST..G_PROFILE_NAMES.LAST
54: LOOP
55: G_PROFILE_VALUES(i) := FND_PROFILE.value(G_PROFILE_NAMES(i));
56: END LOOP;
57: ELSE
58: IF l_debug = FND_API.G_TRUE THEN
59: QP_PREQ_GRP.engine_debug('G_PROFILE_NAMES cache has been warmed up and reuse it.');

Line 67: --QP_PREQ_GRP.engine_debug('profile name:'||l_profile_names(i)||' value:'||FND_PROFILE.value(l_profile_names(i)));

63: IF l_debug = FND_API.G_TRUE THEN
64: --FOR i in l_profile_names.FIRST..l_profile_names.LAST
65: FOR i in G_PROFILE_NAMES.FIRST..G_PROFILE_NAMES.LAST
66: LOOP
67: --QP_PREQ_GRP.engine_debug('profile name:'||l_profile_names(i)||' value:'||FND_PROFILE.value(l_profile_names(i)));
68: QP_PREQ_GRP.engine_debug('profile name:'||G_PROFILE_NAMES(i)||' value:'||G_PROFILE_VALUES(i));
69: END LOOP;
70: END IF;
71:

Line 80: --FND_PROFILE.value(l_profile_names(i))

76: PROFILE_OPTION_NAME,
77: PROFILE_OPTION_VALUE)
78: VALUES ( p_request_id,
79: --l_profile_names(i),
80: --FND_PROFILE.value(l_profile_names(i))
81: G_PROFILE_NAMES(i),
82: G_PROFILE_VALUES(i)
83: );
84: COMMIT;

Line 122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;

118: |QP_QUALIFY_SECONDARY_PRICE_LISTS|QP_RETURN_MANUAL_DISCOUNTS|
119: QP_SATIS_QUALS_OPT|QP_SET_REQUEST_NAME|QP_SOURCE_SYSTEM_CODE|
120: QP_TIME_UOM_CONVERSION|QP_FLEX_VALUESET_RESTRICT) */
121:
122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;
123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;

Line 123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;

119: QP_SATIS_QUALS_OPT|QP_SET_REQUEST_NAME|QP_SOURCE_SYSTEM_CODE|
120: QP_TIME_UOM_CONVERSION|QP_FLEX_VALUESET_RESTRICT) */
121:
122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;
123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;

Line 124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;

120: QP_TIME_UOM_CONVERSION|QP_FLEX_VALUESET_RESTRICT) */
121:
122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;
123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;

Line 125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;

121:
122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;
123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;

Line 126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;

122: prof_pattern := FND_PROFILE.VALUE('QP_DEBUG')||G_PATN_SEPERATOR;
123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;

Line 127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;

123: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_INV_DECIMAL_PRECISION')||G_PATN_SEPERATOR;
124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;
131:

Line 128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;

124: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_LIMIT_EXCEED_ACTION')||G_PATN_SEPERATOR;
125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;
131:
132: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_FLEX_VALUESET_RESTRICT');

Line 129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;

125: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS')||G_PATN_SEPERATOR;
126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;
131:
132: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_FLEX_VALUESET_RESTRICT');
133:

Line 130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;

126: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS')||G_PATN_SEPERATOR;
127: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SATIS_QUALS_OPT')||G_PATN_SEPERATOR;
128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;
131:
132: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_FLEX_VALUESET_RESTRICT');
133:
134: --prof_str := prof_str||prof_pattern;

Line 132: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_FLEX_VALUESET_RESTRICT');

128: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SET_REQUEST_NAME')||G_PATN_SEPERATOR;
129: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')||G_PATN_SEPERATOR;
130: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_TIME_UOM_CONVERSION')||G_PATN_SEPERATOR;
131:
132: prof_pattern := prof_pattern||FND_PROFILE.VALUE('QP_FLEX_VALUESET_RESTRICT');
133:
134: --prof_str := prof_str||prof_pattern;
135: G_PROFILE_STR := G_PROFILE_STR||prof_pattern;
136: END IF;