DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on FND_PROFILE

Line 931: select fnd_profile.value('CS_DEFAULT_LABOR_ITEM') from dual;

927: FROM cs_transaction_types_b
928: WHERE transaction_type_id = p_transaction_type_id;
929:
930: CURSOR c_get_item_from_profile is
931: select fnd_profile.value('CS_DEFAULT_LABOR_ITEM') from dual;
932:
933: lv_exists_flag VARCHAR2(1) := 'N';
934: l_create_charge_flag VARCHAR2(1);
935: l_create_cost_flag VARCHAR2(1);

Line 1127: fnd_profile.value('CS_INV_VALIDATION_ORG') --Bug 7193528

1123: currency_code ,
1124: source_id ,
1125: source_code ,
1126: org_id ,
1127: fnd_profile.value('CS_INV_VALIDATION_ORG') --Bug 7193528
1128: INTO x_incident_id ,
1129: x_transaction_type_id ,
1130: x_txn_billing_type_id ,
1131: x_charge_line_type ,

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

4602: l_numerator NUMBER;
4603: l_denominator NUMBER;
4604: l_return_status VARCHAR2(1);
4605: l_call_api VARCHAR2(1):='Y';
4606: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
4607: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
4608: l_from_currency VARCHAR2(15);
4609:
4610: BEGIN

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

4603: l_denominator NUMBER;
4604: l_return_status VARCHAR2(1);
4605: l_call_api VARCHAR2(1):='Y';
4606: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
4607: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
4608: l_from_currency VARCHAR2(15);
4609:
4610: BEGIN
4611: