DBA Data[Home] [Help]

APPS.OTA_OFF_BUS dependencies on OTA_GENERAL

Line 422: If ota_general.check_par_child_dates_fun(v_start_date,

418: If p_end_date is null Then
419: p_end_date := v_end_date;
420: End if;
421: */
422: If ota_general.check_par_child_dates_fun(v_start_date,
423: v_end_date,
424: NVL(p_start_date, hr_api.g_sot),
425: NVL(p_end_date, hr_api.g_eot) ) then
426: --

Line 1129: ota_general.check_vendor_is_valid(p_vendor_id,p_date);

1125: begin
1126: --
1127: hr_utility.set_location('Entering:'|| v_proc, 5);
1128: --
1129: ota_general.check_vendor_is_valid(p_vendor_id,p_date);
1130: --
1131: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1132: --
1133: exception

Line 1217: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,

1213: ,p_name in varchar
1214: ) is
1215: --
1216: l_owner_id_changed boolean
1217: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,
1218: p_rec.owner_id);
1219: l_start_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.start_date,
1220: p_rec.start_date);
1221: l_end_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.end_date,

Line 1219: l_start_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.start_date,

1215: --
1216: l_owner_id_changed boolean
1217: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,
1218: p_rec.owner_id);
1219: l_start_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.start_date,
1220: p_rec.start_date);
1221: l_end_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.end_date,
1222: p_rec.end_date);
1223:

Line 1221: l_end_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.end_date,

1217: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,
1218: p_rec.owner_id);
1219: l_start_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.start_date,
1220: p_rec.start_date);
1221: l_end_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.end_date,
1222: p_rec.end_date);
1223:
1224: l_maximum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_attendees,
1225: p_rec.maximum_attendees);

Line 1224: l_maximum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_attendees,

1220: p_rec.start_date);
1221: l_end_date_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.end_date,
1222: p_rec.end_date);
1223:
1224: l_maximum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_attendees,
1225: p_rec.maximum_attendees);
1226: l_maximum_int_att_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_internal_attendees,
1227: p_rec.maximum_internal_attendees);
1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,

Line 1226: l_maximum_int_att_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_internal_attendees,

1222: p_rec.end_date);
1223:
1224: l_maximum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_attendees,
1225: p_rec.maximum_attendees);
1226: l_maximum_int_att_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_internal_attendees,
1227: p_rec.maximum_internal_attendees);
1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,
1229: p_rec.minimum_attendees);
1230: l_actual_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.actual_cost,

Line 1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,

1224: l_maximum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_attendees,
1225: p_rec.maximum_attendees);
1226: l_maximum_int_att_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_internal_attendees,
1227: p_rec.maximum_internal_attendees);
1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,
1229: p_rec.minimum_attendees);
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,

Line 1230: l_actual_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.actual_cost,

1226: l_maximum_int_att_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.maximum_internal_attendees,
1227: p_rec.maximum_internal_attendees);
1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,
1229: p_rec.minimum_attendees);
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,

Line 1232: l_budget_cost_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.budget_cost,

1228: l_minimum_attendees_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.minimum_attendees,
1229: p_rec.minimum_attendees);
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,

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 1236: l_duration_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration,

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);
1240:

Line 1238: l_duration_units_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.duration_units,

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);
1240:
1241: l_vendor_id_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.vendor_id, p_rec.vendor_id);
1242:

Line 1241: l_vendor_id_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.vendor_id, p_rec.vendor_id);

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);
1240:
1241: l_vendor_id_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.vendor_id, p_rec.vendor_id);
1242:
1243: l_budget_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.budget_currency_code, p_rec.budget_currency_code);
1244:
1245: l_price_basis_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.price_basis, p_rec.price_basis);

Line 1243: l_budget_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.budget_currency_code, p_rec.budget_currency_code);

1239: p_rec.duration_units);
1240:
1241: l_vendor_id_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.vendor_id, p_rec.vendor_id);
1242:
1243: l_budget_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.budget_currency_code, p_rec.budget_currency_code);
1244:
1245: l_price_basis_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.price_basis, p_rec.price_basis);
1246:
1247: l_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.currency_code, p_rec.currency_code);

Line 1245: l_price_basis_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.price_basis, p_rec.price_basis);

1241: l_vendor_id_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.vendor_id, p_rec.vendor_id);
1242:
1243: l_budget_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.budget_currency_code, p_rec.budget_currency_code);
1244:
1245: l_price_basis_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.price_basis, p_rec.price_basis);
1246:
1247: l_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.currency_code, p_rec.currency_code);
1248:
1249: begin

Line 1247: l_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.currency_code, p_rec.currency_code);

1243: l_budget_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.budget_currency_code, p_rec.budget_currency_code);
1244:
1245: l_price_basis_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.price_basis, p_rec.price_basis);
1246:
1247: l_currency_code_changed boolean := ota_general.value_changed( ota_off_shd.g_old_rec.currency_code, p_rec.currency_code);
1248:
1249: begin
1250: CHECK_UNIQUE (
1251: p_name,

Line 1388: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,

1384: ) is
1385: --
1386: l_proc varchar2(72) := g_package||'update_validate';
1387: l_owner_id_changed boolean
1388: := ota_general.value_changed(ota_off_shd.g_old_rec.owner_id,
1389: p_rec.owner_id);
1390:
1391: --
1392: Begin