[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_price_update_tolerance NUMBER,
x_processing_lead_time NUMBER,
x_delivery_calendar VARCHAR2,
x_min_order_qty NUMBER,
x_fixed_lot_multiple NUMBER,
x_country_of_origin_code VARCHAR2,
/* VMI FPH START */
x_enable_vmi_flag VARCHAR2,
x_vmi_min_qty NUMBER,
x_vmi_max_qty NUMBER,
x_enable_vmi_auto_repl_flag VARCHAR2,
x_vmi_replenishment_approval VARCHAR2,
/* VMI FPH END */
/* CONSSUP FPI START */
x_consigned_from_supplier_flag VARCHAR2,
x_consigned_billing_cycle NUMBER ,
x_last_billing_date DATE,
/* CONSSUP FPI END */
/*FPJ START*/
x_replenishment_method NUMBER,
x_vmi_min_days NUMBER,
x_vmi_max_days NUMBER,
x_fixed_order_quantity NUMBER,
x_forecast_horizon NUMBER,
x_consume_on_aging_flag VARCHAR2,
x_aging_period NUMBER
/*FPJ END*/
) is
cursor asl_row is SELECT *
FROM po_asl_attributes
WHERE rowid = x_row_id
FOR UPDATE of asl_id NOWAIT;
fnd_message.set_name('FND','FORM_RECORD_DELETED');
AND ((recinfo.price_update_tolerance = x_price_update_tolerance) OR
((recinfo.price_update_tolerance is null) AND
(x_price_update_tolerance is null)))
AND ((recinfo.processing_lead_time = x_processing_lead_time) OR
((recinfo.processing_lead_time is null) AND
(x_processing_lead_time is null)))
AND ((recinfo.delivery_calendar = x_delivery_calendar) OR
((recinfo.delivery_calendar is null) AND
(x_delivery_calendar is null)))
AND ((recinfo.min_order_qty = x_min_order_qty) OR
((recinfo.min_order_qty is null) AND
(x_min_order_qty is null)))
AND ((recinfo.fixed_lot_multiple = x_fixed_lot_multiple) OR
((recinfo.fixed_lot_multiple is null) AND
(x_fixed_lot_multiple is null)))
AND ((recinfo.country_of_origin_code = x_country_of_origin_code) OR
((recinfo.country_of_origin_code is null) AND
(x_country_of_origin_code is null)))
/* VMI FPH START*/
AND ((recinfo.enable_vmi_flag = x_enable_vmi_flag) OR
((recinfo.enable_vmi_flag is null) AND
(x_enable_vmi_flag is null)))
AND ((recinfo.vmi_min_qty = x_vmi_min_qty) OR
((recinfo.vmi_min_qty is null) AND
(x_vmi_min_qty is null)))
AND ((recinfo.vmi_max_qty = x_vmi_max_qty) OR
((recinfo.vmi_max_qty is null) AND
(x_vmi_max_qty is null)))
AND ((recinfo.enable_vmi_auto_replenish_flag = x_enable_vmi_auto_repl_flag) OR
((recinfo.enable_vmi_auto_replenish_flag is null) AND
(x_enable_vmi_auto_repl_flag is null)))
AND ((recinfo.vmi_replenishment_approval = x_vmi_replenishment_approval) OR
((recinfo.vmi_replenishment_approval is null) AND
(x_vmi_replenishment_approval is null)))
/* VMI FPH END*/
/* CONSSUP FPI START */
AND ((recinfo.consigned_from_supplier_flag = x_consigned_from_supplier_flag) OR
((recinfo.consigned_from_supplier_flag is null) AND
(x_consigned_from_supplier_flag is null)))
AND ((recinfo.consigned_billing_cycle = x_consigned_billing_cycle ) OR
((recinfo.consigned_billing_cycle is null) AND
(x_consigned_billing_cycle is null)))
AND ((TRUNC(recinfo.last_billing_date) = TRUNC(x_last_billing_date)) OR
((recinfo.last_billing_date is null) AND
(x_last_billing_date is null)))
/* CONSSUP FPI START */
/*FPJ START */
AND ((recinfo.replenishment_method = x_replenishment_method) OR
((recinfo.replenishment_method is null) AND
(x_replenishment_method is null)))
AND ((recinfo.vmi_min_days = x_vmi_min_days) OR
((recinfo.vmi_min_days is null) AND
(x_vmi_min_days is null)))
AND ((recinfo.vmi_max_days = x_vmi_max_days) OR
((recinfo.vmi_max_days is null) AND
(x_vmi_max_days is null)))
AND ((recinfo.fixed_order_quantity = x_fixed_order_quantity) OR
((recinfo.fixed_order_quantity is null) AND
(x_fixed_order_quantity is null)))
AND ((recinfo.forecast_horizon = x_forecast_horizon) OR
((recinfo.forecast_horizon is null) AND
(x_forecast_horizon is null)))
AND ((recinfo.consume_on_aging_flag = x_consume_on_aging_flag) OR
((recinfo.consume_on_aging_flag is null) AND
(x_consume_on_aging_flag is null)))
AND ((recinfo.aging_period = x_aging_period) OR
((recinfo.aging_period is null) AND
(x_aging_period is null)))
) then
return;