APPS.AHL_PP_MATERIALS_PVT_W SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 122

          t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a35(indx));

Line: 123

          t(ddindx).last_updated_date := rosetta_g_miss_date_in_map(a36(indx));

Line: 455

          a35(indx) := t(ddindx).program_update_date;

Line: 456

          a36(indx) := t(ddindx).last_updated_date;

Line: 1179

    , p_last_update_date  date
    , p_last_updated_by  NUMBER
    , p_creation_date  date
    , p_created_by  NUMBER
    , p_last_update_login  NUMBER
    , p_load_type_code  NUMBER
    , p_transaction_type_code  NUMBER
    , p_workorder_operation_id  NUMBER
    , p_operation_resource_id  NUMBER
    , p_schedule_material_id  NUMBER
    , p_bom_resource_id  NUMBER
    , p_cost_basis_code  NUMBER
    , p_total_required  NUMBER
    , p_assigned_units  NUMBER
    , p_autocharge_type_code  NUMBER
    , p_standard_rate_flag_code  NUMBER
    , p_applied_resource_units  NUMBER
    , p_applied_resource_value  NUMBER
    , p_inventory_item_id  NUMBER
    , p_scheduled_quantity  NUMBER
    , p_scheduled_date  date
    , p_mrp_net_flag  NUMBER
    , p_quantity_per_assembly  NUMBER
    , p_required_quantity  NUMBER
    , p_supply_locator_id  NUMBER
    , p_supply_subinventory  NUMBER
    , p_date_required  date
    , p_operation_type_code  VARCHAR2
    , p_res_sched_start_date  date
    , p_res_sched_end_date  date
    , p_op_scheduled_start_date  date
    , p_op_scheduled_end_date  date
    , p_op_actual_start_date  date
    , p_op_actual_end_date  date
    , p_attribute_category  VARCHAR2
    , p_attribute1  VARCHAR2
    , p_attribute2  VARCHAR2
    , p_attribute3  VARCHAR2
    , p_attribute4  VARCHAR2
    , p_attribute5  VARCHAR2
    , p_attribute6  VARCHAR2
    , p_attribute7  VARCHAR2
    , p_attribute8  VARCHAR2
    , p_attribute9  VARCHAR2
    , p_attribute10  VARCHAR2
    , p_attribute11  VARCHAR2
    , p_attribute12  VARCHAR2
    , p_attribute13  VARCHAR2
    , p_attribute14  VARCHAR2
    , p_attribute15  VARCHAR2
  )

  as
    ddp_last_update_date date;

Line: 1248

    ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);

Line: 1311

      ddp_last_update_date,
      p_last_updated_by,
      ddp_creation_date,
      p_created_by,
      p_last_update_login,
      p_load_type_code,
      p_transaction_type_code,
      p_workorder_operation_id,
      p_operation_resource_id,
      p_schedule_material_id,
      p_bom_resource_id,
      p_cost_basis_code,
      p_total_required,
      p_assigned_units,
      p_autocharge_type_code,
      p_standard_rate_flag_code,
      p_applied_resource_units,
      p_applied_resource_value,
      p_inventory_item_id,
      p_scheduled_quantity,
      ddp_scheduled_date,
      p_mrp_net_flag,
      p_quantity_per_assembly,
      p_required_quantity,
      p_supply_locator_id,
      p_supply_subinventory,
      ddp_date_required,
      p_operation_type_code,
      ddp_res_sched_start_date,
      ddp_res_sched_end_date,
      ddp_op_scheduled_start_date,
      ddp_op_scheduled_end_date,
      ddp_op_actual_start_date,
      ddp_op_actual_end_date,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15);