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

Line 1268: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'

1264: where cip.party_id = p_party_id
1265: and cip.instance_id = cp.instance_id
1266: and cip.party_source_table = 'HZ_PARTIES')AND
1267: (
1268: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1269: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1270: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1271:
1272: lv_exists_flag VARCHAR2(1) := 'N';

Line 1270: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));

1266: and cip.party_source_table = 'HZ_PARTIES')AND
1267: (
1268: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1269: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1270: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1271:
1272: lv_exists_flag VARCHAR2(1) := 'N';
1273:
1274: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_instance_valid';

Line 5009: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');

5005: ELSE
5006: -- Business Process Id is null
5007: -- Get the Business Process Id from Service Request
5008: -- Check if the profile to get Business Process From SR = 'Y'
5009: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5010:
5011: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5012: THEN
5013: FND_LOG.String

Line 9173: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9169: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
9170: l_price_list_id IS NULL THEN
9171:
9172: --use the default from the price list
9173: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9174:
9175: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9176: THEN
9177: FND_LOG.String

Line 9329: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9325: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
9326: l_price_list_id IS NULL THEN
9327:
9328: --use the default from the price list
9329: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9330:
9331: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9332: THEN
9333: FND_LOG.String

Line 9361: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9357:
9358: ELSE
9359: -- consider this as no contract exists
9360: IF p_charges_detail_rec.price_list_id IS NULL THEN
9361: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9362:
9363: -- get currency_code for the price_list_id
9364: GET_CURRENCY_CODE(
9365: p_api_name => l_api_name,

Line 9409: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9405:
9406: ELSE
9407: --no contract exists
9408: IF p_charges_detail_rec.price_list_id IS NULL THEN
9409: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9410:
9411: -- get currency_code for the price_list_id
9412: GET_CURRENCY_CODE(
9413: p_api_name => l_api_name,

Line 9676: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9672: p_charges_detail_rec.price_list_id = FND_API.G_MISS_NUM AND
9673: l_price_list_id IS NULL THEN
9674:
9675: --use the default from the price list
9676: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9677:
9678: -- get currency_code for the price_list_id
9679: GET_CURRENCY_CODE(
9680: p_api_name => l_api_name,

Line 9762: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9758: ELSE
9759:
9760: --get the default on the profile
9761: --use the default from the price list
9762: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9763:
9764: -- get currency_code for the price_list_id
9765: GET_CURRENCY_CODE(
9766: p_api_name => l_api_name,

Line 9925: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9921: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
9922: l_price_list_id IS NULL THEN
9923:
9924: --use the default from the price list
9925: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9926:
9927: -- get currency_code for the price_list_id
9928: GET_CURRENCY_CODE(
9929: p_api_name => l_api_name,

Line 10020: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

10016: END IF;
10017:
10018: ELSE
10019: --use the default from the price list
10020: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
10021:
10022: -- get currency_code for the price_list_id
10023: GET_CURRENCY_CODE(
10024: p_api_name => l_api_name,

Line 10104: x_charges_detail_rec.conversion_type_code := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');

10100: END IF;
10101: --assign values to out record for conversion_rate, conversion_type_code
10102: --conversion_rate_date
10103: x_charges_detail_rec.conversion_rate := l_rate;
10104: x_charges_detail_rec.conversion_type_code := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
10105: x_charges_detail_rec.conversion_rate_date := SYSDATE;
10106:
10107: ELSE
10108:

Line 11360: l_profile_value := fnd_profile.value('CS_SR_CHG_PRIC_DATE');

11356: l_absolute_quantity_required := x_charges_detail_rec.quantity_required;
11357: END IF;
11358: */
11359: -- Bug 7117553
11360: l_profile_value := fnd_profile.value('CS_SR_CHG_PRIC_DATE');
11361: If l_profile_value = 'CHG_INC_DATE' Then
11362: l_pricing_date := l_incident_date;
11363: Else
11364: l_pricing_date := sysdate;

Line 14414: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');

14410:
14411: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
14412: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
14413: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
14414: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
14415: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
14416: lx_numerator NUMBER;
14417: lx_denominator NUMBER;
14418: lx_rate NUMBER;

Line 14415: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));

14411: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
14412: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
14413: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
14414: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
14415: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
14416: lx_numerator NUMBER;
14417: lx_denominator NUMBER;
14418: lx_rate NUMBER;
14419: