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.OTA_OFF_BUS dependencies on STANDARD

Line 1075: procedure check_amount(p_actual_cost number,p_budget_cost number,p_standard_price number,

1071:
1072: END IF;
1073: end check_duration;
1074:
1075: procedure check_amount(p_actual_cost number,p_budget_cost number,p_standard_price number,
1076: p_budget_currency_code varchar2 ,p_price_basis varchar2,p_currency_code varchar2)
1077: is
1078: begin
1079: if( p_actual_cost < 0 or p_budget_cost < 0 or p_standard_price < 0 or checkDecimal(p_actual_cost,3)

Line 1079: if( p_actual_cost < 0 or p_budget_cost < 0 or p_standard_price < 0 or checkDecimal(p_actual_cost,3)

1075: procedure check_amount(p_actual_cost number,p_budget_cost number,p_standard_price number,
1076: p_budget_currency_code varchar2 ,p_price_basis varchar2,p_currency_code varchar2)
1077: is
1078: begin
1079: if( p_actual_cost < 0 or p_budget_cost < 0 or p_standard_price < 0 or checkDecimal(p_actual_cost,3)
1080: or checkDecimal(p_budget_cost,3) or checkDecimal(p_standard_price,3) )
1081: then
1082: fnd_message.set_name('OTA','OTA_443354_OFF_AMT_NEGATIVE');
1083: fnd_message.raise_error;

Line 1080: or checkDecimal(p_budget_cost,3) or checkDecimal(p_standard_price,3) )

1076: p_budget_currency_code varchar2 ,p_price_basis varchar2,p_currency_code varchar2)
1077: is
1078: begin
1079: if( p_actual_cost < 0 or p_budget_cost < 0 or p_standard_price < 0 or checkDecimal(p_actual_cost,3)
1080: or checkDecimal(p_budget_cost,3) or checkDecimal(p_standard_price,3) )
1081: then
1082: fnd_message.set_name('OTA','OTA_443354_OFF_AMT_NEGATIVE');
1083: fnd_message.raise_error;
1084: end if;

Line 1091: if ( p_price_basis is not null and p_price_basis ='S' and (p_standard_price is null or p_currency_code is null)) then

1087: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');
1088: fnd_message.raise_error;
1089: end if;
1090:
1091: if ( p_price_basis is not null and p_price_basis ='S' and (p_standard_price is null or p_currency_code is null)) then
1092: fnd_message.set_name('OTA','OTA_443348_SE_AMOUNT_FIELD_NUL');
1093: fnd_message.raise_error;
1094: end if;
1095:

Line 1096: if ( p_price_basis is not null and p_price_basis ='C' and (p_standard_price is not null or p_currency_code is null)) then

1092: fnd_message.set_name('OTA','OTA_443348_SE_AMOUNT_FIELD_NUL');
1093: fnd_message.raise_error;
1094: end if;
1095:
1096: if ( p_price_basis is not null and p_price_basis ='C' and (p_standard_price is not null or p_currency_code is null)) then
1097: fnd_message.set_name('OTA','OTA_443348_SE_AMOUNT_FIELD_NUL');
1098: fnd_message.raise_error;
1099: end if;
1100:

Line 1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')

1104:
1105: IF hr_multi_message.exception_add(
1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'
1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'
1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')
1109: THEN
1110:
1111: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1112: RAISE;

Line 1234: l_standard_price_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.standard_price,

1230: l_actual_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.actual_cost,
1231: p_rec.actual_cost);
1232: l_budget_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.budget_cost,
1233: p_rec.budget_cost);
1234: l_standard_price_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.standard_price,
1235: p_rec.standard_price);
1236: l_duration_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration,
1237: p_rec.duration);
1238: l_duration_units_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration_units,

Line 1235: p_rec.standard_price);

1231: p_rec.actual_cost);
1232: l_budget_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.budget_cost,
1233: p_rec.budget_cost);
1234: l_standard_price_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.standard_price,
1235: p_rec.standard_price);
1236: l_duration_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration,
1237: p_rec.duration);
1238: l_duration_units_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration_units,
1239: p_rec.duration_units);

Line 1295: if l_actual_cost_changed or l_budget_cost_changed or l_standard_price_changed or l_budget_currency_code_changed or l_price_basis_changed or l_currency_code_changed

1291:
1292: end if;
1293:
1294:
1295: if l_actual_cost_changed or l_budget_cost_changed or l_standard_price_changed or l_budget_currency_code_changed or l_price_basis_changed or l_currency_code_changed
1296: then
1297: check_amount(p_rec.actual_cost,p_rec.budget_cost,p_rec.standard_price,p_rec.budget_currency_code,p_rec.price_basis,p_rec.currency_code);
1298: end if;
1299:

Line 1297: check_amount(p_rec.actual_cost,p_rec.budget_cost,p_rec.standard_price,p_rec.budget_currency_code,p_rec.price_basis,p_rec.currency_code);

1293:
1294:
1295: if l_actual_cost_changed or l_budget_cost_changed or l_standard_price_changed or l_budget_currency_code_changed or l_price_basis_changed or l_currency_code_changed
1296: then
1297: check_amount(p_rec.actual_cost,p_rec.budget_cost,p_rec.standard_price,p_rec.budget_currency_code,p_rec.price_basis,p_rec.currency_code);
1298: end if;
1299:
1300: if l_vendor_id_changed
1301: then